📄 getsubject.cs
字号:
{
P_int_result = Convert.ToInt32(dr[0].ToString()) + 1;
}// end block wheile
dr.Close();
cmd.Connection.Close();
con.Close();
// }// end block if
}// end block
if (P_int_result == 0)// 表示表中没有记录
{ P_int_result = 1001; }// end blokc
return P_int_result;
}// end block try
catch (Exception e)
{
P_int_result = 0;
return P_int_result;
}// end blokc catch
}
#endregion
#region//在数据库中查找科目名称是否存在 public int FindSubName(SubInfo sub)
public int FindSubName(SubInfo sub)
{
int P_int_SubjectName;
try
{
con = getCon.GetCon();
cmd = new SqlCommand();
string P_str_select = "select count(*) from tb_subjectInfo where subId='" + sub.getsubId() + "'";
cmd.CommandText = P_str_select;
cmd.Connection = con;
int p_int_id = (int)cmd.ExecuteScalar();
if (p_int_id == 1)
{ P_int_SubjectName = p_int_id; }//end block if 已存在
else
{ P_int_SubjectName = -1; }// end block mehtod if //不存在
return P_int_SubjectName;
}// end block try
catch (Exception e)
{
P_int_SubjectName = 0;
return P_int_SubjectName;
}// end bloc catch
}
#endregion
#region//无条件和有条件查找，返回所有数据集 public DataSet SubDataSet()
public DataSet SubDataSet()
{
con = getCon.GetCon();
string P_str_select = "select * from tb_subjectInfo ";
SqlDataAdapter da = new SqlDataAdapter(P_str_select, con);
da.Fill(ds, "tb_subjectInfo");
return ds;
}// end block menthod SubDataSet()
public DataSet SubDataSet(int p_int_selectId)
{
con = getCon.GetCon();
string P_str_select = "select * from tb_subjectInfo where subId='" + p_int_selectId + "'";
SqlDataAdapter da = new SqlDataAdapter(P_str_select, con);
da.Fill(ds, "tb_subjectInfo");
return ds;
}// end block menthod SubDataSet()
public DataSet SubDataSet(string p_int_selectId)
{
con = getCon.GetCon();
string P_str_select = "select * from tb_subjectInfo where subName='" + p_int_selectId + "'";
SqlDataAdapter da = new SqlDataAdapter(P_str_select, con);
da.Fill(ds, "tb_subjectInfo");
return ds;
}// end block menthod SubDataSet()
#endregion
#region //条件查找，返回所有的值 public DataSet SubDataSet(SubInfo su)
public DataSet SubDataSet(SubInfo su)
{
con = getCon.GetCon();
string P_str_select = "select subId as 科目编号,subGkb as 拼音简码,subName as 科目名称,subMoney as 初期余额,subPage 总账页码 from tb_subjectInfo where subId='" + su.getsubId() + "'";
SqlDataAdapter da = new SqlDataAdapter(P_str_select, con);
da.Fill(ds, "tb_subjectInfo");
return ds;
}// end block menthod SubDataSet()
#endregion
#region ////无条件查找，返回科目编号 public DataTable SubDataSetSubId()
public DataTable SubDataSetSubId()
{
con = getCon.GetCon();
string P_str_select = "select * from tb_subjectInfo";
SqlDataAdapter da = new SqlDataAdapter(P_str_select, con);
da.Fill(ds, "tb_subjectInfo");
return ds.Tables["tb_subjectInfo"];
}// end block menthod SubDataSet()
#endregion
#region//条件查找，返回所有的值Dr public SqlDataReader getSelectDr(SubInfo su)
public SqlDataReader getSelectDr(SubInfo su)
{
con = getCon.GetCon();
string P_str_select = "select * from tb_subjectInfo where subId='" + su.getsubId() + "'";
cmd = new SqlCommand(P_str_select,con);
SqlDataReader dr = cmd.ExecuteReader();
return dr;
}// end blokc SqlDataReader getSelectDr()
#endregion
#region//条件查找，返回所有的值Dr 无条件的 public SqlDataReader getSelectDr()
public SqlDataReader getSelectDr()
{
con = getCon.GetCon();
string P_str_select = "select * from tb_subjectInfo ";
cmd = new SqlCommand(P_str_select, con);
SqlDataReader dr = cmd.ExecuteReader();
return dr;
}// end blokc SqlDataReader getSelectDr()
#endregion
#region //填冲编号 public void fillId(object ct)
public void fillId(object ct)
{
try
{
if (ct.GetType().ToString() == "System.Windows.Forms.ComboBox")
{
ComboBox bo = (ComboBox)ct;
bo.Items.Clear();
con = getCon.GetCon();
string P_str_select = "select * from tb_subjectInfo";
cmd = new SqlCommand(P_str_select, con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
bo.Items.Add(dr.GetValue(0).ToString());
}
dr.Close();
cmd.Connection.Close();
con.Close();
}// end block if
}
catch (Exception ee)
{ MessageBox.Show(ee.Message); }
}
#endregion
#region//帮定listView1控件有条件的 public void GedListView(Object list,SubInfo su)
public void GedListView(Object list,SubInfo su)
{
if (list.GetType().ToString() == "System.Windows.Forms.ListView")
{
ListView lv = (ListView)list;//p实例对象
SqlDataReader dr= getSelectDr(su);//数据集
lv.Items.Clear();//清空
lv.View=View.Details;//显示示图
while(dr.Read())
{
ListViewItem lt =new ListViewItem(dr.GetValue(0).ToString());
lt.SubItems.Add(dr.GetValue(1).ToString());
lt.SubItems.Add(dr.GetValue(2).ToString());
lt.SubItems.Add(dr.GetValue(4).ToString());
lv.Items.Add(lt);
}
dr.Close();
}// end blokc
}
#endregion
#region//帮定listView1控件无条件的 public void GedListView(Object list)
public void GedListView(Object list)
{
if (list.GetType().ToString() == "System.Windows.Forms.ListView")
{
ListView lv = (ListView)list;//p实例对象
SqlDataReader dr = getSelectDr();//数据集
lv.Items.Clear();//清空
lv.View = View.Details;//显示示图
while (dr.Read())
{
ListViewItem lt = new ListViewItem(dr.GetValue(0).ToString());
lt.SubItems.Add(dr.GetValue(1).ToString());
lt.SubItems.Add(dr.GetValue(2).ToString());
lt.SubItems.Add(dr.GetValue(4).ToString());
lv.Items.Add(lt);
}
dr.Close();
}// end blokc
}
#endregion
#region//帮定DataGrid控件有条件的 public void GetdDataGrid(Object DatGrid,SubInfo su)
public void GetdDataGrid(Object DatGrid,SubInfo su)
{
con = getCon.GetCon();
string P_str_select = "select subId as 科目编号,subGkb as 拼音简码,subName as 科目名称,subMoney as 初期余额,subPage 总账页码 from tb_subjectInfo where subId='" + su.getsubId() + "'";
SqlDataAdapter da = new SqlDataAdapter(P_str_select, con);
da.Fill(ds, "tb_subjectInfo");
if (DatGrid.GetType().ToString() == "System.Windows.Forms.DataGridView")
{
DataGridView dg = (DataGridView)DatGrid;
dg.DataSource = ds.Tables[0].DefaultView;
}//
}
#endregion
#region
public string GetDataGridInfo(Object DatGrid, SubInfo su)
{
string P_str_result = null ;
con = getCon.GetCon();
string P_str_select = "select count(*) from tb_subjectInfo where subName='" + su.getsubName() + "'";
cmd = new SqlCommand();
cmd.CommandText = P_str_select;
cmd.Connection = con;
int p_int_select = (int)cmd.ExecuteScalar();
cmd.Connection.Close();
con.Close();
if (p_int_select != 0)//科目名称存在
{
con = getCon.GetCon();
DataSet ds = new DataSet();
string P_str_select1 = "select subId as 科目编号,subGkb as 拼音简码,subName as 科目名称,subMoney as 初期余额,subPage 总账页码 from tb_subjectInfo where subName='" + su.getsubName() + "'";
SqlDataAdapter da = new SqlDataAdapter(P_str_select1, con);
da.Fill(ds, "tb_subjectInfo");
if (DatGrid.GetType().ToString() == "System.Windows.Forms.DataGridView")
{
DataGridView dg = (DataGridView)DatGrid;
dg.DataSource =ds.Tables[0].DefaultView;
}//
}// end block if
else
{ P_str_result = "NO"; }// end block if
return P_str_result;
}
#endregion
#region//帮定DataGrid控件无条件的 public void GetdDataGrid(Object DatGrid,SubInfo su)
public void GetdDataGrid(Object DatGrid)
{
con = getCon.GetCon();
string P_str_select = "select subId as 科目编号,subGkb as 拼音简码,subName as 科目名称,subMoney as 初期余额,subPage 总账页码 from tb_subjectInfo";
SqlDataAdapter da = new SqlDataAdapter(P_str_select, con);
da.Fill(ds, "tb_subjectInfo");
if (DatGrid.GetType().ToString() == "System.Windows.Forms.DataGridView")
{
DataGridView dg = (DataGridView)DatGrid;
dg.DataSource = ds.Tables[0].DefaultView;
}//
}
#endregion
#region//报表用的数据集，
public DataSet getds(int p_int_id,string P_str_table)
{
string P_str_select = null;
con = getCon.GetCon();
if (P_str_table == "subjectid")
{
P_str_select = "select * from View_sub_Wart where subid='" + p_int_id + "'";
}
if (P_str_table == "WarId")
{
P_str_select = "select * from View_sub_Wart where warrantId='" + p_int_id + "'";
}
if (P_str_table == "one")
{
P_str_select = "select * from View_sub_Wart ";
}
//string P_str_select = "select top 2 * from tb_subjectInfo";
SqlDataAdapter da = new SqlDataAdapter(P_str_select, con);
da.Fill(ds, "tb_subjectInfo");
return ds;
}
public DataSet getds()
{
con = getCon.GetCon();
string P_str_select = "select * from View_sub_Wart";
//string P_str_select = "select top 2 * from tb_subjectInfo";
SqlDataAdapter da = new SqlDataAdapter(P_str_select, con);
da.Fill(ds, "tb_subjectInfo");
return ds;
}
#endregion
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -