📄 pz_sh.aspx.cs
字号:
object[] obj = new object[DataTypes.Length];
for (int j=0; j<Pk.Length; j++)
{
obj[j] = ((System.Web.UI.HtmlControls.HtmlInputHidden)_item.FindControl(Pk[j].ToString())).Value; //取各项主关键字
}
ArPks.Insert(n,obj);
n++;
}
}
}
return ArPks;
}
private void SH_Dispose(string SH_Type)
{
string[] DataTypes = {"string","string","string","string"};
string[] pk = {"Hidden1","Hidden2","Hidden3","Hidden4"};
ArrayList al=this.GetPk("CheckBox1",DataTypes,pk,this.DataGrid1);
if(al.Count>0)
{
for(int i=0;i<al.Count;i++)
{
try
{
object[] obj=(object[])al[i];
this.CW_PZ.PZBH=obj[0].ToString();
this.CW_PZ.KJND=obj[1].ToString();
this.CW_PZ.KJQJ=obj[2].ToString();
this.CW_PZ.JGDM=obj[3].ToString();
this.CW_PZ=this.CW_PZMgr.GetCW_PZ(this.CW_PZ.PZBH,this.CW_PZ.KJND,this.CW_PZ.KJQJ,this.CW_PZ.JGDM);
if(SH_Type=="审核过帐")
{
this.CW_PZ.SHR=this.CurrentEmployee.EmplID;
this.CW_PZ.SHRQ=DateTime.Now.Date;
this.CW_PZ.GZR=this.CurrentEmployee.EmplID;
this.CW_PZ.GZRQ=DateTime.Now.Date;
this.CW_PZ.GZBJ="1";
this.CW_PZ.BZ="4";
}
else if(SH_Type=="取消审核过帐")
{
this.CW_PZ.SHR=string.Empty;
this.CW_PZ.SHRQ=Convert.ToDateTime("1900-01-01");
this.CW_PZ.GZR=string.Empty;
this.CW_PZ.GZRQ=Convert.ToDateTime("1900-01-01");
this.CW_PZ.GZBJ="0";
this.CW_PZ.BZ="3";
}
cn.Open();
//调用修改方法进行修改
SqlCommand mySqlCommand = new SqlCommand();
mySqlCommand.Connection=cn;
SqlTransaction myTrans = this.cn.BeginTransaction();//建立事务
mySqlCommand.Transaction = myTrans;//绑定事务
if(this.SHJZ(CW_PZ,mySqlCommand)&&this.CW_PZMgr.UpdateCW_PZ(mySqlCommand,CW_PZ))
{
myTrans.Commit();
}
else
{
myTrans.Rollback();
}
cn.Close();
}
catch
{
//重定向到错误页面
Response.Write("<script language=javascript>window.opener.location='../../Publics/Error.aspx?errmsg=凭证审核记帐未能成功。';</script>");
}
}
}
else
{
this.Response.Write("<script>alert('请选择要审核的凭证')</script>");
}
if(SH_Type=="审核过帐")
{
ViewState["sql"]= string.Format("select * from CW_PZ where JGDM='{0}' and KJND ='{1}' and KJQJ='{2}' and GZBJ='0' and BZ='3' order by PZBH DESC",ViewState["JGDM"].ToString(),ViewState["KJND"].ToString(),ViewState["KJQJBH"].ToString()) ;
}
else if(SH_Type=="取消审核过帐")
{
ViewState["sql"]= string.Format("select * from CW_PZ where JGDM='{0}' and KJND ='{1}' and KJQJ='{2}' and GZBJ='1' order by PZBH DESC",ViewState["JGDM"].ToString(),ViewState["KJND"].ToString(),ViewState["KJQJBH"].ToString()) ;
}
//处理DataGrid控件（绑定DataGrid控件 -> 检查是否需要定位 -> 给导航文本赋值）
if(CommonService.BindDataGrid(this, ViewState["sql"].ToString(),this.DataGrid1,"DataSH",true) == false)
this.Response.Redirect("../../publics/Error.aspx?errmsg=在处理数据时发生错误。");
//对页面导航文本进行重新赋值
CommonService.PageNavigatorText(DataGrid1,Label2, Label3, Label4);
}
private bool SHJZ(Com.Ascs.Plp.CW.CW_PZ CWPZ,SqlCommand mySqlCommand)
{
string strsql=string.Format("exec SHJZ '{0}','{1}','{2}','{3}'",CWPZ.KJND,CWPZ.KJQJ,CWPZ.JGDM,CWPZ.PZBH);
DataTable dt=this.CW_PZMgr.CreateDataTableFromSql(strsql);
if(dt.Rows.Count>0)
{
foreach(DataRow row in dt.Rows)
{
try
{
this.CW_KMYE=this.CW_KMYEMgr.GetCW_KMYE(row["KJND"].ToString(),row["KJQJBH"].ToString(),row["JGDM"].ToString(),row["KJKM"].ToString());
if(CW_PZ.GZBJ=="1")
{
if(this.CW_KMYE==null)
{
this.CW_KMYEADD.KJND=row["KJND"].ToString();
this.CW_KMYEADD.KJQJ=row["KJQJBH"].ToString();
this.CW_KMYEADD.JGDM=row["JGDM"].ToString();
this.CW_KMYEADD.KJKM=row["KJKM"].ToString();
this.CW_KMYEADD.QCYE=0;
this.CW_KMYEADD.JFFSE=0;
this.CW_KMYEADD.DFFSE=0;
this.CW_KMYEADD.JFFSE=this.CW_KMYEADD.JFFSE+Convert.ToDecimal(row["JFFSE"].ToString());
this.CW_KMYEADD.DFFSE=this.CW_KMYEADD.DFFSE+Convert.ToDecimal(row["DFFSE"].ToString());
if(this.CW_KMYEMgr.HandleKMYE(mySqlCommand,this.CW_KMYEADD)==false)
{
return false;
}
}
else
{
this.CW_KMYE.JFFSE=this.CW_KMYE.JFFSE+Convert.ToDecimal(row["JFFSE"].ToString());
this.CW_KMYE.DFFSE=this.CW_KMYE.DFFSE+Convert.ToDecimal(row["DFFSE"].ToString());
if(this.CW_KMYEMgr.HandleKMYE(mySqlCommand,this.CW_KMYE) == false)
{
return false;
}
}
}
else
{
if(this.CW_KMYE==null)
{
this.CW_KMYEADD.KJND=row["KJND"].ToString();
this.CW_KMYEADD.KJQJ=row["KJQJBH"].ToString();
this.CW_KMYEADD.JGDM=row["JGDM"].ToString();
this.CW_KMYEADD.KJKM=row["KJKM"].ToString();
this.CW_KMYEADD.QCYE=0;
this.CW_KMYEADD.JFFSE=0;
this.CW_KMYEADD.DFFSE=0;
this.CW_KMYEADD.JFFSE=this.CW_KMYEADD.JFFSE-Convert.ToDecimal(row["JFFSE"].ToString());
this.CW_KMYEADD.DFFSE=this.CW_KMYEADD.DFFSE-Convert.ToDecimal(row["DFFSE"].ToString());
if(this.CW_KMYEMgr.HandleKMYE(mySqlCommand,this.CW_KMYEADD)==false)
{
return false;
}
}
else
{
this.CW_KMYE.JFFSE=this.CW_KMYE.JFFSE-Convert.ToDecimal(row["JFFSE"].ToString());
this.CW_KMYE.DFFSE=this.CW_KMYE.DFFSE-Convert.ToDecimal(row["DFFSE"].ToString());
if(this.CW_KMYEMgr.HandleKMYE(mySqlCommand,this.CW_KMYE)==false)
{
return false;
}
}
}
}
catch(Exception e)
{
string str=e.Message;
}
}
}
return true;
}
private string[] GetDQKJQJ(string JGDM)
{
string strsql=string.Format("select * from CW_KJQJ where JGDM='{0}' and DQQJBJ='1'",JGDM);
DataTable dt=this.CW_PZMgr.CreateDataTableFromSql(strsql);
string[] DQKJQJ=new string[2];
if(dt.Rows.Count==1)
{
DQKJQJ[0]=dt.Rows[0]["KJQJBH"].ToString();
DQKJQJ[1]=dt.Rows[0]["KJND"].ToString();
}
return DQKJQJ;
}
private void DDL_KJQJBH_SelectedIndexChanged(object sender, System.EventArgs e)
{
try
{
ViewState["KJND"]=this.DDL_KJND.SelectedItem.Value.ToString();
ViewState["KJQJBH"]=this.DDL_KJQJBH.SelectedItem.Value.ToString();
if(ViewState["SH"].ToString()=="0")
{
ViewState["sql"]=string.Format("select * from CW_PZ where JGDM='{0}' and KJND ='{1}' and KJQJ='{2}' and GZBJ='0' and BZ='3' order by PZBH DESC",ViewState["JGDM"].ToString(),ViewState["KJND"].ToString(),ViewState["KJQJBH"].ToString()) ;
}
else
{
ViewState["sql"]=string.Format("select * from CW_PZ where JGDM='{0}' and KJND ='{1}' and KJQJ='{2}' and GZBJ='1' order by PZBH DESC",ViewState["JGDM"].ToString(),ViewState["KJND"].ToString(),ViewState["KJQJBH"].ToString()) ;
}
//处理DataGrid控件（绑定DataGrid控件 -> 检查是否需要定位 -> 给导航文本赋值）
if(CommonService.ReBindDataGrid(this, ViewState["sql"].ToString(), DataGrid1, "DataSH", Label2, Label3, Label4) == false)
this.Response.Redirect("../../publics/Error.aspx?errmsg=在处理数据时发生错误。");
}
catch(Exception e1)
{
LogService.Write ("会计期间选择时产生异常。");
LogService.Write (e1.Message);
Prompt.PromptError(this,"会计期间选择时产生异常。");
}
}
private void LinkButton2_Click(object sender, System.EventArgs e)
{
try
{
string[] DataTypes = {"string","string","string","string"};
string[] pk = {"Hidden1","Hidden2","Hidden3","Hidden4"};
ArrayList al=this.GetPk("CheckBox1",DataTypes,pk,this.DataGrid1);
if(al.Count>0)
{
for(int i=0;i<al.Count;i++)
{
try
{
object[] obj=(object[])al[i];
this.CW_PZ = this.CW_PZMgr.GetCW_PZ(obj[0].ToString(),obj[1].ToString(),obj[2].ToString(),obj[3].ToString());
this.CW_PZ.BZ="2";
this.cn.Open();//启动连接
SqlCommand mySqlCommand = new SqlCommand();
mySqlCommand.Connection=cn;
SqlTransaction myTrans = this.cn.BeginTransaction();//建立事务
mySqlCommand.Transaction = myTrans;//绑定事务
bool flag=this.CW_PZMgr.UpdateCW_PZ(mySqlCommand,this.CW_PZ);
if(flag)
{
myTrans.Commit();
}
else
{
myTrans.Rollback();
}
cn.Close();
}
catch(Exception e1)
{
LogService.Write(e1.Message);
this.Response.Redirect("../../Publics/Error.aspx?errmsg=未能未能提交审核凭证。");
return;
}
}
}
//处理DataGrid控件（绑定DataGrid控件 -> 检查是否需要定位 -> 给导航文本赋值）
if(CommonService.BindDataGrid(this, ViewState["sql"].ToString(),this.DataGrid1,"DataSH",true) == false)
this.Response.Redirect("../../publics/Error.aspx?errmsg=在处理数据时发生错误。");
//对页面导航文本进行重新赋值
CommonService.PageNavigatorText(DataGrid1,Label2, Label3, Label4);
}
catch(Exception e1)
{
LogService.Write ("凭证审核退回时产生异常。");
LogService.Write (e1.Message);
Prompt.PromptError(this,"凭证审核退回时产生异常。");
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -