?? pzmx_mod.aspx.cs
字號:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using com.ascs.plp.publics;
using com.unicafe.ui;
using com.unicafe.common;
using com.unicafe.security;
using com.ascs.plp.common;
namespace PLP.CWZZ.PZGL
{
/// <summary>
/// PZMX_MOD 的摘要說明。
/// </summary>
public class PZMX_MOD : com.unicafe.ui.UnicafePage
{
protected System.Web.UI.WebControls.TextBox tb_ZY;
protected System.Web.UI.WebControls.TextBox tb_JFJE;
protected System.Web.UI.WebControls.TextBox tb_DFJE;
protected System.Web.UI.WebControls.DropDownList DDL_WLHLX;
protected System.Web.UI.WebControls.TextBox KJKM;
protected System.Web.UI.WebControls.TextBox KMMC;
protected System.Web.UI.WebControls.LinkButton datacheck;
protected System.Web.UI.WebControls.DropDownList DDL_GSBM;
protected System.Web.UI.WebControls.DropDownList DDL_GSYG;
protected System.Web.UI.WebControls.DropDownList DDL_WLH;
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
Com.Ascs.Plp.CW.CW_PZXM CW_PZXM=new Com.Ascs.Plp.CW.CW_PZXM();
Com.Ascs.Plp.CW.CW_PZXMMgr CW_PZXMMgr=new Com.Ascs.Plp.CW.CW_PZXMMgr();
Com.Ascs.Plp.CW.CW_PZMgr CW_PZMgr = new Com.Ascs.Plp.CW.CW_PZMgr();
protected System.Web.UI.WebControls.RangeValidator RangeValidator1;
protected System.Web.UI.WebControls.RangeValidator RangeValidator2;
Com.Ascs.Plp.CW.CW_PZ CW_PZ = new Com.Ascs.Plp.CW.CW_PZ();
private void Page_Load(object sender, System.EventArgs e)
{
try
{
// 在此處放置用戶代碼以初始化頁面
this.VerifyPage();
this.VerifyPage("zz_pzgl_mgr");
ViewState["JGDM"]=this.CurrentJGXX.JGDM;
this.CW_PZXM.PZBH=this.Request.QueryString["PZBH"];
this.CW_PZXM.KJND=this.Request.QueryString["KJND"];
this.CW_PZXM.KJQJ=this.Request.QueryString["KJQJ"];
this.CW_PZXM.JGDM=this.Request.QueryString["JGDM"];
ViewState["KJND"]=this.Request.QueryString["KJND"];
ViewState["CD"]=this.CW_PZXMMgr.GetYJKMCD();
this.CW_PZXM.XH=Convert.ToInt32(this.Request.QueryString["XH"]);
this.CW_PZXM = this.CW_PZXMMgr.GetCW_PZXM(this.CW_PZXM.PZBH,this.CW_PZXM.XH,this.CW_PZXM.KJND,this.CW_PZXM.KJQJ,this.CW_PZXM.JGDM);
this.CW_PZ=this.CW_PZMgr.GetCW_PZ(this.CW_PZXM.PZBH,this.CW_PZXM.KJND,this.CW_PZXM.KJQJ,this.CW_PZXM.JGDM);
if(this.CW_PZ.KGLBJ=="1")
{
this.tb_DFJE.Enabled=false;
this.tb_JFJE.Enabled=false;
}
if(!this.IsPostBack)
{
try
{
this.tb_ZY.Text=this.CW_PZXM.ZY;
this.KMMC.Text=this.CW_PZXM.KJKM;
this.KJKM.Text=this.CW_PZXM.KJKM;
if(this.CW_PZXM.JFJE!=0)
{
this.tb_JFJE.Text=this.CW_PZXM.JFJE.ToString();
}
if(this.CW_PZXM.DFJE!=0)
{
this.tb_DFJE.Text=this.CW_PZXM.DFJE.ToString();
}
this.DDLBind();
this.DDL_GSBM.SelectedIndex=-1;
if(this.CW_PZXM.BMBH.ToString().Trim()!=string.Empty)
this.DDL_GSBM.Items.FindByValue(this.CW_PZXM.BMBH.ToString().Trim()).Selected=true;
this.DDL_GSYG.SelectedIndex=-1;
if(this.CW_PZXM.YGBH.ToString().Trim()!=string.Empty)
this.DDL_GSYG.Items.FindByValue(this.CW_PZXM.YGBH.ToString().Trim()).Selected=true;
this.DDL_WLHLX.SelectedIndex=-1;
if(this.CW_PZXM.WLHLX.ToString().Trim()!=string.Empty)
this.DDL_WLHLX.Items.FindByValue(this.CW_PZXM.WLHLX.ToString().Trim()).Selected=true;
if(this.DDL_WLHLX.SelectedIndex>0)
{
this.DDL_WLHBIND();
this.DDL_WLH.SelectedIndex=-1;
if(this.CW_PZXM.WLHBM.ToString().Trim()!=string.Empty)
this.DDL_WLH.Items.FindByValue(this.CW_PZXM.WLHBM.ToString().Trim()).Selected=true;
}
}
catch(Exception e1)
{
LogService.Write(e1.Message);
this.Response.Redirect("../../Publics/Error.aspx?errmsg=未能獲取憑證細目的完整信息。");
return;
}
}
}
catch(Exception e1)
{
LogService.Write ("顯示會計憑證細目時產生異常。");
LogService.Write (e1.Message);
Prompt.PromptError(this,"顯示會計憑證細目時產生異常。");
}
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN：該調用是 ASP.NET Web 窗體設計器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內容。
/// </summary>
private void InitializeComponent()
{
this.DDL_WLHLX.SelectedIndexChanged += new System.EventHandler(this.DDL_WLHLX_SelectedIndexChanged);
this.datacheck.Click += new System.EventHandler(this.LinkButton1_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void LinkButton1_Click(object sender, System.EventArgs e)
{
try
{
//對表對象進行賦值
try
{
this.CW_PZXM.ZY=this.tb_ZY.Text;
this.CW_PZXM.KJKM=this.KMMC.Text.Trim();
string sReturn=this.CHECKKJKM(this.CW_PZXM.KJND,this.CW_PZXM.KJKM,this.DDL_GSBM.SelectedIndex,this.DDL_GSYG.SelectedIndex,this.DDL_WLH.SelectedIndex,this.DDL_WLHLX.SelectedIndex);
if(sReturn!=string.Empty)
{
this.Response.Write("<script>alert('"+sReturn+"')</script>");
return;
}
if(this.DDL_GSBM.SelectedIndex>-1)
{
CW_PZXM.BMBH=this.DDL_GSBM.SelectedItem.Value;
}
else
{
CW_PZXM.BMBH=string.Empty;
}
if(this.DDL_GSYG.SelectedIndex>-1)
{
CW_PZXM.YGBH=this.DDL_GSYG.SelectedItem.Value;
}
else
{
CW_PZXM.BMBH=string.Empty;
}
if(this.DDL_WLH.SelectedIndex>-1)
{
CW_PZXM.WLHBM = this.DDL_WLH.SelectedItem.Value;
}
else
{
CW_PZXM.WLHBM=string.Empty;
}
if(this.DDL_WLHLX.SelectedIndex>-1)
{
CW_PZXM.WLHLX = this.DDL_WLHLX.SelectedItem.Value;
}
else
{
CW_PZXM.WLHLX=string.Empty;
}
if(this.tb_JFJE.Text.Trim()!=string.Empty)
{
this.CW_PZXM.JFJE=Convert.ToDecimal(this.tb_JFJE.Text);
}
else
{
CW_PZXM.JFJE=0;
}
if(this.tb_DFJE.Text.Trim()!=string.Empty)
{
this.CW_PZXM.DFJE=Convert.ToDecimal(this.tb_DFJE.Text);
}
else
{
CW_PZXM.DFJE=0;
}
}
catch(Exception e1)
{
LogService.Write(e1.Message);
this.Response.Redirect("../../Publics/Error.aspx?errmsg=未能獲取憑證細目的完整信息。");
return;
}
cn.Open();
SqlCommand mySqlCommand = new SqlCommand();
mySqlCommand.Connection=cn;
SqlTransaction myTrans = this.cn.BeginTransaction();//建立事務
mySqlCommand.Transaction = myTrans;//綁定事務
//調用修改方法進行修改
bool Flag = this.CW_PZXMMgr.UpdateCW_PZXM(mySqlCommand,this.CW_PZXM);
string ReturnURL=PLP.CWZZ.PZGL.PZMX_ADD.PZXMADD_CreatReturnURL(this,CW_PZXM);
//執行完畢，提示后返回
if(Flag == true)
{
this.MODKJKM_SYBJ(this.CW_PZXM.KJND,this.CW_PZXM.KJKM);
//刷新父頁面并關閉本窗口
Response.Write("<script language=javascript>window.opener.location='" + ReturnURL + "';window.close();</script>");
myTrans.Commit();
}
else
{
//重定向到錯誤頁面
Response.Write("<script language=javascript>window.opener.location='../../Publics/Error.aspx?errmsg=憑證細目未能成功修改。';</script>");
myTrans.Rollback();
}
cn.Close();
}
catch(Exception e1)
{
LogService.Write ("修改會計憑證細目時產生異常。");
LogService.Write (e1.Message);
Prompt.PromptError(this,"修改會計憑證細目時產生異常。");
}
}
{
string sql=string.Empty;
sql=string.Format("select DeptID,DeptName from Departments where JGDM='{0}' or DeptID='0'",ViewState["JGDM"].ToString());
DataTable dt=this.CW_PZMgr.CreateDataTableFromSql(sql);
if(dt.Rows.Count>0)
{
this.DDL_GSBM.DataSource=dt;
this.DDL_GSBM.DataTextField="DeptName";
this.DDL_GSBM.DataValueField="DeptID";
this.DDL_GSBM.DataBind();
this.DDL_GSBM.Items.Insert(0,new ListItem("請選擇",""));
}
sql=string.Format("SELECT Employees.EmplID,Employees.EmplNameL + Employees.EmplNameF AS EmplNameL,Departments.JGDM, Employees.EmplEnabled FROM Employees INNER JOIN EmplDept ON Employees.EmplID = EmplDept.EmplID INNER JOIN Departments ON EmplDept.DeptID = Departments.DeptID where EmplEnabled='1'and JGDM='{0}'",ViewState["JGDM"].ToString());
DataTable dt1=this.CW_PZMgr.CreateDataTableFromSql(sql);
if(dt1.Rows.Count>0)
{
this.DDL_GSYG.DataSource=dt1;
this.DDL_GSYG.DataTextField="EmplNameL";
this.DDL_GSYG.DataValueField="EmplID";
this.DDL_GSYG.DataBind();
this.DDL_GSYG.Items.Insert(0,new ListItem("請選擇",""));
}
}
private void DDL_WLHBIND()
{
string sql=string.Empty;
DataTable dt;
switch(this.DDL_WLHLX.SelectedItem.Value)
{
case "0":
this.DDL_WLH.Items.Clear();
this.DDL_WLH.Items.Insert(0,new ListItem("請選擇",""));
break;
case "1":
sql=string.Format("select KHDM,KHMC from KHXX where JGDM='{0}'",ViewState["JGDM"].ToString());
dt=this.CW_PZMgr.CreateDataTableFromSql(sql);
if(dt.Rows.Count>0)
{
this.DDL_WLH.DataSource=dt;
this.DDL_WLH.DataTextField="KHMC";
this.DDL_WLH.DataValueField="KHDM";
this.DDL_WLH.DataBind();
this.DDL_WLH.Items.Insert(0,new ListItem("請選擇",""));
}
break;
case "2":
sql=string.Format("select GYSDM,GYSMC from GYSXX where JGDM='{0}'",ViewState["JGDM"].ToString());
dt=this.CW_PZMgr.CreateDataTableFromSql(sql);
if(dt.Rows.Count>0)
{
this.DDL_WLH.DataSource=dt;
this.DDL_WLH.DataTextField="GYSMC";
this.DDL_WLH.DataValueField="GYSDM";
this.DDL_WLH.DataBind();
this.DDL_WLH.Items.Insert(0,new ListItem("請選擇",""));
}
break;
case "3":
sql=string.Format("select JGDM,JGMC from JGXX");
dt=this.CW_PZMgr.CreateDataTableFromSql(sql);
if(dt.Rows.Count>0)
{
this.DDL_WLH.DataSource=dt;
this.DDL_WLH.DataTextField="JGMC";
this.DDL_WLH.DataValueField="JGDM";
this.DDL_WLH.DataBind();
this.DDL_WLH.Items.Insert(0,new ListItem("請選擇",""));
}
break;
}
}
private void DDL_WLHLX_SelectedIndexChanged(object sender, System.EventArgs e)
{
try
{
this.DDL_WLHBIND();
}
catch(Exception e1)
{
LogService.Write ("選擇往來戶類型時產生異常。");
LogService.Write (e1.Message);
Prompt.PromptError(this,"選擇往來戶類型時產生異常。");
}
}
private void MODKJKM_SYBJ(string KJND,string KJKM)
{
Com.Ascs.Plp.CW.CW_KJKM CW_KJKM=new Com.Ascs.Plp.CW.CW_KJKM();
Com.Ascs.Plp.CW.CW_KJKMMgr CW_KJKMMgr=new Com.Ascs.Plp.CW.CW_KJKMMgr();
CW_KJKM=CW_KJKMMgr.GetCW_KJKM(KJND,KJKM);
CW_KJKM.SFYJSY="1";
CW_KJKMMgr.UpdateCW_KJKM(cn,CW_KJKM);
}
private string CHECKKJKM(string KJND,string KJKM,int BMBM,int YGBM,int WLHBM,int WLHLX)
{
string sReturn=string.Empty;
string sql=string.Format("select * from CW_KJKM where KJND='{0}' and KMBM='{1}' and TYBJ='0' and SFMX='1'",KJND,KJKM);
DataTable dt=this.CW_PZMgr.CreateDataTableFromSql(sql);
if(dt.Rows.Count==1)
{
if(dt.Rows[0]["SFBMHS"].ToString()=="1"&&BMBM<1)
{
sReturn="該科目部門核算，請選擇部門！";
}
else if(dt.Rows[0]["SFBMHS"].ToString()=="0"&&BMBM>0)
{
sReturn="該科目沒有部門核算，請不要選擇部門！";
this.DDL_GSBM.SelectedIndex=0;
}
if(dt.Rows[0]["SFYGHS"].ToString()=="1"&&YGBM<1)
{
sReturn+="該科目員工核算，請選擇員工！";
}
else if(dt.Rows[0]["SFYGHS"].ToString()=="0"&&YGBM>0)
{
sReturn+="該科目沒有員工核算，請不要選擇員工！";
this.DDL_GSYG.SelectedIndex=0;
}
if(dt.Rows[0]["SFWLHHS"].ToString()=="1"&&WLHBM<1)
{
sReturn+="該科目往來戶核算，請選擇往來戶！";
}
else if(dt.Rows[0]["SFWLHHS"].ToString()=="0")
{
if(WLHBM>0||WLHLX>0)
{
sReturn+="該科目沒有往來戶核算，請不要選擇往來戶！";
this.DDL_WLHLX.SelectedIndex=0;
this.DDL_WLH.SelectedIndex=0;
}
}
}
else
{
sReturn="科目編碼書寫有誤請重新填寫！原因有可能是：1.該科目不存在。2.該科目不是末級科目。3.該科目已經停用。";
}
return sReturn;
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -