?? pz_view.aspx.cs
字號(hào):
//處理DataGrid控件（綁定DataGrid控件 -> 檢查是否需要定位 -> 給導(dǎo)航文本賦值）
if(CommonService.HandleDataGrid(this, sql, DataGrid1, "Data", Label2, Label3, Label4) == false)
this.Response.Redirect("../../publics/Error.aspx?errmsg=在處理數(shù)據(jù)時(shí)發(fā)生錯(cuò)誤。");
}
catch(Exception e1)
{
LogService.Write ("會(huì)計(jì)年度選擇時(shí)產(chǎn)生異常。");
LogService.Write (e1.Message);
Prompt.PromptError(this,"會(huì)計(jì)年度選擇時(shí)產(chǎn)生異常。");
}
}
public static string GetToEmpName(Object obj)
{
string sql=string.Format("select (EmplNameL+EmpLNameF) as EmplNameL from Employees where EmplID='{0}'",obj.ToString());
string sReturn=string.Empty;
Com.Ascs.Plp.CW.CW_PZMgr CW_PZMgr1 = new Com.Ascs.Plp.CW.CW_PZMgr();
DataTable dt=CW_PZMgr1.CreateDataTableFromSql(sql);
if(dt.Rows.Count>0)
{
sReturn=dt.Rows[0]["EmplNameL"].ToString();
}
return sReturn;
}
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];
string DQKJQJ=this.CW_KJQJMgr.GetDQKJQJ(obj[3].ToString())[0];
this.CreateCXPZ(obj[0].ToString(),obj[1].ToString(),obj[2].ToString(),obj[3].ToString(),DQKJQJ);
}
catch
{
//重定向到錯(cuò)誤頁(yè)面
Response.Write("<script language=javascript>window.opener.location='../../Publics/Error.aspx?errmsg=憑證細(xì)目未能成功修改。';</script>");
}
}
}
if(this.DropDownList1.SelectedItem.Value.ToString()!="0")
{
ViewState["sql"]=string.Format("select * from CW_PZ where JGDM='{0}' and KJND ='{1}' and KJQJ='{2}' and PZLX='{3}' order by PZBH DESC",ViewState["JGDM"].ToString(),ViewState["KJND"].ToString(),ViewState["KJQJBH"].ToString(),this.DropDownList1.SelectedItem.Value.ToString()) ;
}
else
{
ViewState["sql"]=string.Format("select * from CW_PZ where JGDM='{0}' and KJND ='{1}' and KJQJ='{2}' order by PZBH DESC",ViewState["JGDM"].ToString(),ViewState["KJND"].ToString(),ViewState["KJQJBH"].ToString()) ;
}
//處理DataGrid控件（綁定DataGrid控件 -> 檢查是否需要定位 -> 給導(dǎo)航文本賦值）
if(CommonService.ReBindDataGrid(this, ViewState["sql"].ToString(), DataGrid1, "Data", Label2, Label3, Label4) == false)
this.Response.Redirect("../../publics/Error.aspx?errmsg=在處理數(shù)據(jù)時(shí)發(fā)生錯(cuò)誤。");
}
catch(Exception e1)
{
LogService.Write ("沖銷會(huì)計(jì)憑證時(shí)產(chǎn)生異常。");
LogService.Write (e1.Message);
Prompt.PromptError(this,"沖銷會(huì)計(jì)憑證時(shí)產(chǎn)生異常。");
}
}
private ArrayList GetPk(string CheckBoxName,string[] DataTypes,string[] Pk,DataGrid dg)
{
ArrayList ArPks=new ArrayList();
int n=0;
if(dg.Items.Count>0)
{
for (int i=0; i<dg.Items.Count; i++)
{
//將當(dāng)前行賦值給一個(gè)DataGridItem對(duì)象
DataGridItem _item = dg.Items[i];
//判斷當(dāng)前行上的CheckBox控件賦值給一個(gè)CheckBox對(duì)象
CheckBox CheckFlag = (CheckBox)_item.FindControl(CheckBoxName);
//判斷當(dāng)前行上的復(fù)選框是否被選中，如果被選中則進(jìn)行刪除處理，否則不予處理
if(CheckFlag.Checked == true)
{
//獲取關(guān)鍵字的值，逐個(gè)加入對(duì)象數(shù)組obj
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; //取各項(xiàng)主關(guān)鍵字
}
ArPks.Insert(n,obj);
n++;
}
}
}
return ArPks;
}
private string CreateCXPZ(string PZBH,string KJND,string KJQJ,string JGDM,string DQKJQJ)
{
this.VerifyPage();
string sReturn=string.Empty;
this.CW_PZYS=this.CW_PZMgrCX.GetCW_PZ(PZBH,KJND,KJQJ,JGDM);
this.CW_PZCX=this.CW_PZMgrCX.GetCW_PZ(PZBH,KJND,KJQJ,JGDM);
if(this.CW_PZYS.DCBJ=="1")
{
sReturn="已沖銷過(guò)的憑證不能再?zèng)_銷！";
}
else if(this.CW_PZYS.GZBJ=="0")
{
sReturn="未審核記帳的憑證不能沖銷！";
}
else
{
try
{
this.CW_PZYS.DCBJ="1";
this.cn.Open();//啟動(dòng)連接
SqlCommand mySqlCommand=new SqlCommand();
mySqlCommand.Connection=cn;
SqlTransaction myTrans = this.cn.BeginTransaction();//建立事務(wù)
mySqlCommand.Transaction = myTrans;//綁定事務(wù)
string New_PZBH=this.CW_PZMgrCX.Create_PZBH(mySqlCommand,JGDM,KJND,DQKJQJ);
this.CW_PZCX.PZBH=New_PZBH;
this.CW_PZCX.KJND=KJND;
this.CW_PZCX.KJQJ=DQKJQJ;
this.CW_PZCX.ZDR=this.CurrentEmployee.EmplID;
this.CW_PZCX.ZDRQ=DateTime.Parse(System.DateTime.Now.ToShortDateString());
this.CW_PZCX.SHR=string.Empty;
this.CW_PZCX.SHRQ=Convert.ToDateTime("1900-01-01");
this.CW_PZCX.CNR=string.Empty;
this.CW_PZCX.CNRQ=Convert.ToDateTime("1900-01-01");
this.CW_PZCX.GZR=string.Empty;
this.CW_PZCX.GZRQ=Convert.ToDateTime("1900-01-01");
this.CW_PZCX.GZBJ="0";
this.CW_PZCX.KGLBJ="0";
this.CW_PZCX.DCBJ="2";
this.CW_PZCX.BZ="2";
this.CW_PZCX.DCBH=string.Format("{0},{1}",KJQJ,PZBH);
//新增會(huì)計(jì)憑證
if (CW_PZMgr.AddCW_PZ(mySqlCommand,CW_PZCX)&&this.CW_PZMgrCX.UpdateCW_PZ(mySqlCommand,this.CW_PZYS))
{
myTrans.Commit();
}
else
{
myTrans.Rollback();
}
string strsql=string.Format("select * from CW_PZXM where PZBH='{0}' and KJND='{1}' and KJQJ='{2}' and JGDM='{3}'",PZBH,KJND,KJQJ,JGDM);
DataTable dt=this.CW_PZMgrCX.CreateDataTableFromSql(strsql);
if(dt.Rows.Count>0)
{
foreach(DataRow row in dt.Rows)
{
this.CW_PZXM.PZBH=New_PZBH;
this.CW_PZXM.KJND=KJND;
this.CW_PZXM.KJQJ=DQKJQJ;
this.CW_PZXM.JGDM=row["JGDM"].ToString();
this.CW_PZXM.ZY=string.Format("沖銷{0}年度第{1}會(huì)計(jì)期間{2}號(hào)憑證",KJND,KJQJ,PZBH);
this.CW_PZXM.KJKM=row["KJKM"].ToString();
this.CW_PZXM.BMBH=row["BMBH"].ToString();
this.CW_PZXM.YGBH=row["YGBH"].ToString();
this.CW_PZXM.WLHLX=row["WLHLX"].ToString();
this.CW_PZXM.WLHBM=row["WLHBM"].ToString();
if(row["DFJE"].ToString()!=string.Empty)
{
this.CW_PZXM.DFJE=-(Convert.ToDecimal(row["DFJE"]));
}
else
{
this.CW_PZXM.DFJE=0;
}
if(row["JFJE"].ToString()!=string.Empty)
{
this.CW_PZXM.JFJE=-(Convert.ToDecimal(row["JFJE"]));
}
else
{
this.CW_PZXM.JFJE=0;
}
SqlCommand mySqlCommandXM = new SqlCommand();
mySqlCommandXM.Connection=cn;
SqlTransaction myTransXM = this.cn.BeginTransaction();//建立事務(wù)
mySqlCommandXM.Transaction = myTransXM;//綁定事務(wù)
if(this.CW_PZXMMgr.AddCW_PZXM(mySqlCommandXM,this.CW_PZXM))
{
myTransXM.Commit();
}
else
{
myTransXM.Rollback();
}
}
}
cn.Close();
}
catch(Exception e)
{
cn.Close();
string str=e.Message;
//重定向到錯(cuò)誤頁(yè)面
Response.Write("<script language=javascript>window.opener.location='../../Publics/Error.aspx?errmsg=沖銷憑證未能成功生成。';</script>");
}
}
return sReturn;
}
private void GetJZBJ(string JGDM,string KJND,string KJQJBH)
{
this.CW_KJQJ=this.CW_KJQJMgr.GetCW_KJQJ(JGDM,KJND,KJQJBH);
if(this.CW_KJQJ!=null)
{
if(this.CW_KJQJ.JZBJ=="1")
{
ViewState["JZBJ"]="1";
}
else
{
ViewState["JZBJ"]="0";
}
}
}
/// **************************************************************************
/// BEIGIN
/// <summary>
/// 將字段值“是”、“否”由標(biāo)志改為中文描述
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
/// **************************************************************************
public static string ValueToString(Object obj)
{
string sReturn=string.Empty;
switch(obj.ToString())
{
case "1":
sReturn="臨時(shí)憑證";
break;
case "2":
sReturn="待審核";
break;
case "3":
sReturn="已提交";
break;
case "4":
sReturn="已審核";
break;
}
return sReturn;
}
/// **************************************************************************
/// END
/// **************************************************************************
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(this.DropDownList1.SelectedItem.Value.ToString()!="0")
{
ViewState["sql"]=string.Format("select * from CW_PZ where JGDM='{0}' and KJND ='{1}' and KJQJ='{2}' and PZLX='{3}' order by PZBH DESC",ViewState["JGDM"].ToString(),ViewState["KJND"].ToString(),ViewState["KJQJBH"].ToString(),this.DropDownList1.SelectedItem.Value.ToString()) ;
}
else
{
ViewState["sql"]=string.Format("select * from CW_PZ where JGDM='{0}' and KJND ='{1}' and KJQJ='{2}' order by PZBH DESC",ViewState["JGDM"].ToString(),ViewState["KJND"].ToString(),ViewState["KJQJBH"].ToString()) ;
}
this.GetJZBJ(ViewState["JGDM"].ToString(),this.DDL_KJND.SelectedItem.Value.ToString(),this.DDL_KJQJBH.SelectedItem.Value.ToString());
//處理DataGrid控件（綁定DataGrid控件 -> 檢查是否需要定位 -> 給導(dǎo)航文本賦值）
if(CommonService.ReBindDataGrid(this, ViewState["sql"].ToString(), DataGrid1, "Data", Label2, Label3, Label4) == false)
this.Response.Redirect("../../publics/Error.aspx?errmsg=在處理數(shù)據(jù)時(shí)發(fā)生錯(cuò)誤。");
}
catch(Exception e1)
{
LogService.Write ("會(huì)計(jì)期間選擇時(shí)產(chǎn)生異常。");
LogService.Write (e1.Message);
Prompt.PromptError(this,"會(huì)計(jì)期間選擇時(shí)產(chǎn)生異常。");
}
}
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -