📄 getwarinfo.cs
字号:
if (P_int_inst == 1)
{
P_str_result = "deleteOk";
}// end block if
else
{
P_str_result = "deleteNO";
}// end blcok if
cmd.Connection.Close();
con.Close();
return P_str_result;
}// end block try
catch (Exception e)
{
P_str_result = "deleteError";
return P_str_result;
}// end blokc catch
}// ened block
#endregion
#region//帮定DataGridView 控件 public void GetDatGridView(object Dataview)
public void GetDatGridView(object Dataview)
{
if (Dataview.GetType().ToString() == "System.Windows.Forms.DataGridView")
{
DataGridView ve = (DataGridView)Dataview;
ve.DataSource = this.GetWarrSet().Tables[0].DefaultView;
}//
}// end block if
#endregion
#region//返DataSet 数据集 public DataSet GetWarrSet()
public DataSet GetWarrSet()//用于查找没有审察的记录
{
con = getcon.GetCon();
SqlDataAdapter da = new SqlDataAdapter("select b.warrantId as 凭证编号,a.subName as 科目名称,b.warrantDate as 凭证日期 ,b.subLendmoney as 借方金额 ,b.subGoodsMoney as 贷方金额 ,b.subEquation as 平衡关系 ,b.subRemark as 备注 from tb_subjectInfo a,tb_warrantInfo b where a.subId=b.subid and subEquation is null and (subLendmoney=0 or subGoodsMoney=0)", con);
DataSet ds = new DataSet();
da.Fill(ds, "tb_warrantInfo");
return ds;
}// end block
#endregion
#region//单条审察通过 public string GetShengwarr(int WarrID)
public string GetShengwarr(int WarrID)
{
string P_str_result = null;
try
{
con = getcon.GetCon();
cmd = new SqlCommand();
string P_str_update = "update tb_warrantInfo set subEquation='审核已通过' where warrantId in(select warrantId from tb_warrantInfo where subEquation is null and (subLendmoney=0 or subGoodsMoney=0))and warrantId='" + WarrID + "'";
cmd.CommandText = P_str_update;
cmd.Connection = con;
int P_int_inst = cmd.ExecuteNonQuery();
if (P_int_inst == 1)
{
P_str_result = "updateOk";
}
else
{
P_str_result = "updateNO";
}// end blcok if
cmd.Connection.Close();
con.Close();
return P_str_result;
}// end block try
catch (Exception e)
{
P_str_result = "updateError";
return P_str_result;
}// end blokc catch
}
#endregion
#region//批量审察通过 public string GetShengwarr()
public string GetShengwarr()
{
string P_str_result = null;
try
{
con = getcon.GetCon();
cmd = new SqlCommand();
string P_str_update = "update tb_warrantInfo set subEquation='审核已通过' where warrantId in(select warrantId from tb_warrantInfo where subEquation is null and (subLendmoney=0 or subGoodsMoney=0))";
cmd.CommandText = P_str_update;
cmd.Connection = con;
int P_int_inst = cmd.ExecuteNonQuery();
if (P_int_inst !=0)
{
P_str_result = "updateOk";
}
else
{
P_str_result = "updateNO";
}// end blcok if
cmd.Connection.Close();
con.Close();
return P_str_result;
}// end block try
catch (Exception e)
{
P_str_result = "updateError";
return P_str_result;
}// end blokc catch
}
#endregion
#region//查找是否有要审察的记录 public int GetCount()
public int GetCount()
{
int P_int_count;
con = getcon.GetCon();
cmd = new SqlCommand();
string P_str_select = "select count(*) from tb_warrantInfo where subEquation is null and (subLendmoney=0 or subGoodsMoney=0)";
cmd.CommandText = P_str_select;
cmd.Connection = con;
int P_int_result =(int)cmd.ExecuteScalar();
con.Close();
cmd.Connection.Close();
if (P_int_result != 0)//有记录
{ P_int_count=1; }// end block if
else//没有
{ P_int_count=0; }
return P_int_count;
}// end
#endregion
#region //数据帮定凭证时间 public void GetWarDate()
public void GetWarDate(object Cmb)
{
if (Cmb.GetType().ToString() == "System.Windows.Forms.ComboBox")
{
con = getcon.GetCon();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter("select distinct(warrantDate) from tb_warrantInfo",con);
da.Fill(ds, "tb_warrantInfo");
DataGridView dv = (DataGridView)Cmb;
dv.DataSource = ds.Tables[0].DefaultView;
}//
}// end block if
#endregion
#region //数据帮定凭证编号 public void GetWarID(object Cmb)
public void GetWarID(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 distinct(warrantId) from tb_warrantInfo";
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); }
}// end block if
#endregion
#region//帮定DataGridView 控件 public void GetDatGridView(object Dataview)
public void GetWarrPrint(object Dataview)
{
if (Dataview.GetType().ToString() == "System.Windows.Forms.DataGridView")
{
con = getcon.GetCon();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter("select b.warrantId as 凭证编号,a.subName as 科目名称,b.warrantDate as 凭证日期 ,b.subLendmoney as 借方金额 ,b.subGoodsMoney as 贷方金额 ,b.subEquation as 平衡关系 ,b.subRemark as 备注 from tb_subjectInfo a,tb_warrantInfo b where a.subId=b.subid and subEquation is not null", con);
da.Fill(ds, "tb_warrantInfo");
DataGridView dv = (DataGridView)Dataview;
dv.DataSource = ds.Tables[0].DefaultView;
}//
}// end block if
#endregion
#region//凭证结算 public string GetWarrbalance()
public string GetWarrbalance()
{
string P_str_result = null;
try
{
con = getcon.GetCon();
cmd = new SqlCommand();
string P_str_update = "update tb_warrantInfo set subRemark ='已结算' where (subLendmoney=0 or subGoodsMoney=0) and subEquation is not null";
cmd.CommandText = P_str_update;
cmd.Connection = con;
int P_int_inst = cmd.ExecuteNonQuery();
if (P_int_inst !=0)
{
P_str_result = "updateOk";
}
else
{
P_str_result = "updateNO";
}// end blcok if
cmd.Connection.Close();
con.Close();
return P_str_result;
}// end block try
catch (Exception e)
{
P_str_result = "updateError";
return P_str_result;
}// end blokc catch
}// end block
#endregion
#region//帮定DataGridView 控件查询用凭证编号public void GetDatGridView(object Dataview)
public void GetWarrPrint(object Dataview,int P_int_warrID)
{
if (Dataview.GetType().ToString() == "System.Windows.Forms.DataGridView")
{
con = getcon.GetCon();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter("select b.warrantId as 凭证编号,a.subName as 科目名称,b.warrantDate as 凭证日期 ,b.subLendmoney as 借方金额 ,b.subGoodsMoney as 贷方金额 ,b.subEquation as 平衡关系 ,b.subRemark as 备注 from tb_subjectInfo a,tb_warrantInfo b where a.subId=b.subid and b.warrantId ='" + P_int_warrID + "'", con);
da.Fill(ds, "tb_warrantInfo");
DataGridView dv = (DataGridView)Dataview;
dv.DataSource = ds.Tables[0].DefaultView;
}//
}// end block if
#endregion
#region //凭证号查询 public void GetMoney(object Dataview,int P_int_warrID)
public void GetMoney(object Dataview,int P_int_warrID)
{
if (Dataview.GetType().ToString() == "System.Windows.Forms.DataGridView")
{
con = getcon.GetCon();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter("select a.subid as 科目编号,a.subName as 科目名称 ,a.subMoney as 初期余额,b.subLendmoney as 借方金额 ,b.subGoodsMoney as 贷方金额 ,b.warrantDate as 凭证日期,b.subRemark as 备注,((a.subMoney+b.subLendmoney)-b.subGoodsMoney)as 资金余额 from tb_subjectInfo a,tb_warrantInfo b where (a.subId=b.subid and b.subRemark is not null) and b.warrantId='" + P_int_warrID + "'", con);
da.Fill(ds, "tb_warrantInfo");
DataGridView dv = (DataGridView)Dataview;
dv.DataSource = ds.Tables[0].DefaultView;
}//
}
#endregion
#region//凭证报表 public DataSet getWarRepot(int P_int_warrID)
public DataSet getWarRepot(int P_int_warrID)
{
con = getcon.GetCon();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter("select * from V_Slectt_WarrantID where warrantId='" + P_int_warrID + "'", con);
da.Fill(ds, "View_sub_Wart");
return ds;
}// end bloc if
#endregion
#region//凭证报表 public DataSet getWarRepot(int P_int_warrID)
public DataSet getWarRepotInof(int P_int_warrID)
{
con = getcon.GetCon();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter("select * from V_WarratnInfo where warrantId='" + P_int_warrID + "'", con);
da.Fill(ds, "View_sub_Wart");
return ds;
}// end bloc if
#endregion
#region//凭证报表 public DataSet getWarRepot(int P_int_warrID)
public DataSet getWarRepotInof()
{
con = getcon.GetCon();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter("select * from V_WarratnInfo", con);
da.Fill(ds, "View_sub_Wart");
return ds;
}// end bloc if
#endregion
}// end block class WarrantInfo
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -