private void GetCodeFileData(string Code)
{
ParameterList.Clear();
SYSModel.MaintainCodeFile BCO = new SYSModel.MaintainCodeFile(ConntionDB);
ParameterList.Add(Code);
DataTable Dt = BCO.QueryLineSwitch(SYSModel.MaintainCodeFile.QueryType.CODE, ParameterList);
if (Dt.Rows.Count > 0)
foreach (DataRow dr in Dt.Rows)
SLP_CodeFile3.Items.Add(new ListItem(dr["EXPLAIN"].ToString().Trim(), dr["SCODE"].ToString().Trim()));
UpdatePanel5.Update();
}
public CodeFile()
{
co_main = new BCO.MaintainCodeFile(ConntionDB);
}
public string CodeFileName(string Code,
string Category
)
{
string Name = "";
string ConnectionDBStr = ((DatabaseSettings)ConfigurationManager.GetSection("dataConfiguration")).DefaultDatabase;
MaintainCodeFile BCO = new MaintainCodeFile(ConnectionDBStr);
if (Code != "")
{
ArrayList ParameterList = new ArrayList();
ParameterList.Add(Category);
ParameterList.Add(Code);
DataTable Dt = BCO.QueryLineSwitch(MaintainCodeFile.QueryType.SLP,
ParameterList
);
if (Dt.Rows.Count > 0)
{
Name = Dt.Rows[0]["EXPLAIN"].ToString().Trim();
}
else
{
Name = "查無資料";
}
}
return Name;
}
}//end InsertCancelButton_Click
/// <summary>
/// 由新增模式，確認新增
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void InsertButton_Click(object sender, EventArgs e)
{
int AddRecord = 0;
try
{
#region 取得畫面元件的值
string v_Code = ((WUI.SLP.SLPUnique)FormView1.FindControl("TextBoxCode")).Text.Trim();
string v_Name = ((TextBox)FormView1.FindControl("TextBoxName")).Text.Trim();
DateTime processtime = DateTime.Now;
string v_Explain = ((TextBox)FormView1.FindControl("TextBoxEXPLAIN")).Text.Trim();
ParameterList.Clear();
SYSModel.MaintainProgram Uniq = new SYSModel.MaintainProgram(ConnectionDB);
ParameterList.Add(v_Code);
ParameterList.Add("SYS_CODE_MAIN");
ParameterList.Add("CODE");
ParameterList.Add("");
DataTable Dup = Uniq.QuerySwitch(SYSModel.MaintainProgram.QueryType.Duplicate,
ParameterList
);
if (Dup.Rows.Count > 0)
{
if (Dup.Rows[0]["ENABLE"].ToString() == "1")
{
throw new Exception("資料重覆!");
}
}
#endregion
#endregion
#region 加入輸入條件
ParameterList.Clear();
ParameterList.Add(v_Code);
ParameterList.Add(v_Name);
ParameterList.Add(processtime); //vCreateDate
ParameterList.Add(Session["UID"].ToString()); //vCreateUID
ParameterList.Add(processtime); //vUpdateDate
ParameterList.Add(Session["UID"].ToString()); //vUpdateUID
ParameterList.Add(v_Explain);
#endregion
SYSModel.MaintainCodeFile BCO = new SYSModel.MaintainCodeFile(ConnectionDB);
AddRecord = BCO.CreateCodeFile(ParameterList, null);
if (AddRecord == 0)
{
throw new Exception("新增0筆資料!");
}
else
{
Response.Write("<script>alert('新增完成');location.replace('SYS202.aspx?mode=readonly&ID=" + AddRecord + "');</script>");
}
}
catch (Exception ex)
{
ErrorMsgLabel_Insert.Text = ex.Message;
}
}
}//Initiziatoin_Component
private DataTable Linedata()
{
ParameterList.Clear();
SYSModel.MaintainCodeFile BCO = new SYSModel.MaintainCodeFile(ConntionDB);
ParameterList.Add(Category);
ParameterList.Add(_Code);
DataTable Dt = BCO.QueryLineSwitch(SYSModel.MaintainCodeFile.QueryType.SLP,
ParameterList
);
return Dt;
}
private DataTable Get_CodeFile(string strCategory)
{
ParameterList.Clear();
SYSModel.MaintainCodeFile BCO = new SYSModel.MaintainCodeFile(ConntionDB);
ParameterList.Add(strCategory); //Category
ParameterList.Add(""); //_Code
DataTable dt = BCO.QueryLineSwitch(SYSModel.MaintainCodeFile.QueryType.SLP, ParameterList);
return dt;
}
}//end EditCancelButton_Click
/// <summary>
/// 編輯模式，按下更新確認鈕
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void EditCommitButton_Click(object sender, EventArgs e)
{
//Trace.Warn("EditCommit");
int UpdateRecord = 0;
try
{
if (Dtl_Status != "readonly")
{
throw new Exception("請先將明細資料做[存檔]或[更新]，再按主檔[更新]!");
}
else if (this.PanelDetail2.Visible == true)
{
throw new Exception("請先將清單資料做[存檔]或[更新]，再按主檔[更新]!");
}
else
{
#region 取得畫面元件的值
string v_Name = ((TextBox)FormView1.FindControl("TextBoxName")).Text.Trim();
DateTime processtime = DateTime.Now;
string v_Explain = ((TextBox)FormView1.FindControl("TextBoxEXPLAIN")).Text.Trim();
string v_Enable = "1";// ((WUI.SLP.SLP_Boolean)FormView1.FindControl("SLP_Enable")).Text.Trim();
#region 取得更新前舊值
#region 使用XML轉回DataSet
DataSet Ds = new DataSet();
DataTable Dt = dt_Result;
#endregion
if (Dt.Rows.Count == 0)
{
throw new Exception("抓取不到舊值,更新失敗!");
}
#endregion
DataTable dtData = dt_DetailOLDData;
for (int i = 0; i < dtData.Rows.Count; i++)
{
//檢查SCODE 是否已存在Dt
DataRow[] ins = dtData.Select(string.Format("SCODE='{0}'", dtData.Rows[i]["SCODE"].ToString()));
if (ins.Length > 1)
{
throw new Exception("明細代碼重覆!");
}
}
DataTable dtDetail2 = dt_TempDetail2;
for (int i = 0; i < dtDetail2.Rows.Count; i++)
{
//檢查SCODE 是否已存在Dt
DataRow[] ins = dtDetail2.Select(string.Format("SCODE='{0}' AND CODE='{1}'", dtDetail2.Rows[i]["SCODE"].ToString(), dtDetail2.Rows[i]["CODE"].ToString()));
if (ins.Length > 1)
{
throw new Exception("明細代碼:" + dtDetail2.Rows[i]["SCODE"].ToString() + "內的清單代碼重覆!");
}
}
#region 加入更新條件
ParameterList.Clear();
//舊值
ParameterList.Add(Dt.Rows[0]["ID"]);
ParameterList.Add(Dt.Rows[0]["CODE"]);
ParameterList.Add(Dt.Rows[0]["NAME"]);
ParameterList.Add(Dt.Rows[0]["CREATEDATE"]);
ParameterList.Add(Dt.Rows[0]["CREATEUID"]);
ParameterList.Add(Dt.Rows[0]["UPDATEDATE"]);
ParameterList.Add(Dt.Rows[0]["UPDATEUID"]);
ParameterList.Add(Dt.Rows[0]["ENABLE"]);
ParameterList.Add(Dt.Rows[0]["EXPLAIN"]);
//需要更新值
ParameterList.Add(v_Name);
ParameterList.Add(processtime);
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(v_Explain);
ParameterList.Add(v_Enable);
#endregion
SYSModel.MaintainCodeFile BCO = new SYSModel.MaintainCodeFile(ConnectionDB);
System.Data.Common.DbTransaction DBT = BCO.DBT_Begin();
//Update SYS_Code_MAIN
UpdateRecord = BCO.UpdateCodeFile(ParameterList, DBT);
//Update SYS_Code_DETL
Update_Dtl(DBT);
Update_Dtl2(DBT);
BCO.DBT_End(DBT);
Panel2.Visible = false;
if (UpdateRecord == 0)
{
throw new Exception("更新0筆資料!");
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "SYS202", "<script>alert('更改完成');</script>");
ChangeFormMode(FormViewMode.ReadOnly);
}
}
}
catch (Exception ex)
{
this.ErrorMsgLabel.Text = ex.Message;
if (Dtl_Status == "insert")
{
this.Btn_Insert.Visible = true;
this.Btn_Update.Visible = false;
}
else if (Dtl_Status == "edit")
{
this.Btn_Insert.Visible = false;
this.Btn_Update.Visible = true;
}
}
}
}//databind_Mst
#endregion
/// <summary>
/// 繫結資料 DTL
/// </summary>
private void databind_Dtl()
{
#region
try
{
//ErrorMsgLabel.Text = "";
SYSModel.MaintainCodeFile BCO = new SYSModel.MaintainCodeFile(ConnectionDB);
ParameterList.Clear();
string v_Category = ((WUI.SLP.SLPUnique)FormView1.FindControl("TextBoxCode")).Text.Trim();
ParameterList.Add(v_Category);
DataTable Dt = BCO.QueryLineData(ParameterList);
#region 將明細資料放至DetailDt中
Session[SessionIDName] = Dt;
#endregion
#region 使用XML放置到前端資料
dt_DetailOLDData = Dt;
#endregion
GridView2.DataSource = Dt;
GridView2.PageIndex = 0;
GridView2.DataBind();
Load_TempDetail2();
}
catch (Exception ex)
{
}
#endregion
}//databind_Dtl
}//databind_Dtl
/// <summary>
/// 繫結資料 DTL2
/// </summary>
private void Load_TempDetail2()
{
SYSModel.MaintainCodeFile BCO = new SYSModel.MaintainCodeFile(ConnectionDB);
ParameterList.Clear();
string strCategory = ((WUI.SLP.SLPUnique)FormView1.FindControl("TextBoxCode")).Text.Trim();
ParameterList.Add(strCategory);
ParameterList.Add(DBNull.Value);
ParameterList.Add(DBNull.Value);
DataTable Dt = BCO.QueryTHRID(ParameterList);
dt_TempDetail2 = Dt;//放入暫存檔
lblTitle.Text = "明細清單檔";
lblTab3Msg.Text = "尚未選擇明細代碼";
GridView3.DataSource = null;
GridView3.DataBind();
ButtonNewLine2.Visible = false;
PanelDetail2.Visible = false;
txtDetail2Code.Text = "";
txtDetail2Explain.Text = "";
upTab3Title.Update();
upTab3Detail.Update();
}
/// <summary>
/// 清單插入鈕
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Btn_Detail2Insert_Click(object sender, EventArgs e)
{
try
{
if (dt_TempDetail2.Rows.Count == 0)
{
//從DB讀取一空table回來
SYSModel.MaintainCodeFile BCO = new SYSModel.MaintainCodeFile(ConnectionDB);
ParameterList.Add("X");
ParameterList.Add("X");
ParameterList.Add("X");
dt_TempDetail2 = BCO.QueryTHRID(ParameterList);
}
int tempID = 0;
DataView tempDT = new DataView();
tempDT.Table = dt_TempDetail2.Copy();
tempDT.Sort = "ID ASC";
if (dt_TempDetail2.Rows.Count != 0)
{
tempID = Convert.ToInt32(tempDT[dt_TempDetail2.Rows.Count - 1]["ID"].ToString());
}
//ID和PID暫自訂, 真正寫入CO時會重取
//LineItem畫面元件內容
string strCategory = ((WUI.SLP.SLPUnique)FormView1.FindControl("TextBoxCode")).Text.Trim();
int iPID = int.Parse(hdfSCODE_ID.Value);
string strScode = hdfSCODE.Value;
string strCode = this.txtDetail2Code.Text.Trim();
string strExplain = this.txtDetail2Explain.Text.Trim();
int iID = tempID + 1;
//檢查SCODE 是否已存在Dt
DataRow[] FindRows = dt_TempDetail2.Select(string.Format("CODE='{0}' AND SCODE='{1}'", strCode, strScode));
if (FindRows.Length <= 0) //1:已存在Dt 0:不存在Dt
{
DataRow dRow = dt_TempDetail2.NewRow();
dRow["ID"] = iID;
dRow["PID"] = iPID;
dRow["CREATEDATE"] = DateTime.Now;
dRow["CREATEUID"] = Session["UID"].ToString();
dRow["UPDATEDATE"] = DateTime.Now;
dRow["UPDATEUID"] = Session["UID"].ToString();
dRow["CATEGORY"] = strCategory;
dRow["SCODE"] = strScode;
dRow["CODE"] = strCode;
dRow["EXPLAIN"] = strExplain;
dt_TempDetail2.Rows.Add(dRow);
this.txtDetail2Code.Text = "";
this.txtDetail2Explain.Text = "";
this.PanelDetail2.Visible = false;
BindTempTable_Dtl2(strScode);
this.ButtonNewLine2.Visible = true;
}
else
{
lblTab3Msg.Text = "清單代碼重覆!";
}
}
catch (Exception ex)
{
lblTab3Msg.Text = ex.Message;
}
finally { }
}
}//databind
/// <summary>
/// 繫結資料 MST
/// </summary>
/// <param name=VirtualDataID></param>
private void databind_Mst(FormViewMode fvm)
{
try
{
string SessionIDName = "SYS202_" + PageTimeStamp.Value;
SYSModel.MaintainCodeFile BCO = new SYSModel.MaintainCodeFile(ConnectionDB);
ParameterList.Clear();
if (Request["ID"] != null)
ParameterList.Add(Request["ID"].ToString());
else
ParameterList.Add("0");
dt_Result = BCO.QuerySwitch(SYSModel.MaintainCodeFile.QueryType.ID, ParameterList);
if (dt_Result.Rows.Count > 0)
{
this.hiddenID.Value = dt_Result.Rows[0]["ID"].ToString();
FormView1.DataSource = dt_Result;
FormView1.DataBind();
if (dt_Result.Rows[0]["ENABLE"].ToString() == "0")
{
((Button)FormView1.FindControl("EditButton")).Visible = false;
((Button)FormView1.FindControl("DeleteButton")).Visible = false;
}
}
AuthorityControls(this);
//ToolBarStatus
switch (fvm)
{
case FormViewMode.Edit:
ToolBarStatus("edit");
TextBox txtcode = ((TextBox)this.FormView1.FindControl("TextBoxCode").FindControl("TextBoxCode"));
TextBox txtname = ((TextBox)this.FormView1.FindControl("TextBoxCode").FindControl("TextBoxName"));
txtname.Visible = false;
txtcode.Width = Unit.Parse("18");
break;
case FormViewMode.Insert:
ToolBarStatus("insert");
//TextBox txtcode2 = ((WUI.SLP.SLPUnique)this.FormView1.FindControl("TextBoxCode")).TextBox_Code;
//txtcode2.Width = Unit.Parse("18");
TextBox txtcode2 = ((TextBox)this.FormView1.FindControl("TextBoxCode").FindControl("TextBoxCode"));
txtcode2.Width = Unit.Parse("18");
break;
case FormViewMode.ReadOnly:
ToolBarStatus("readonly");
TextBox txtcode1 = ((TextBox)this.FormView1.FindControl("TextBoxCode").FindControl("TextBoxCode"));
TextBox txtname1 = ((TextBox)this.FormView1.FindControl("TextBoxCode").FindControl("TextBoxName"));
txtname1.Visible = false;
txtcode1.Width = Unit.Parse("18");
break;
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}//databind_Mst
}//ButtonNewLine2_Click
/// <summary>
/// 明細插入鈕
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Btn_Insert_Click(object sender, EventArgs e)
{
DataTable Dt = new DataTable();
DataSet Ds = new DataSet();
DataTable Ds_detl = new DataTable();
if (dt_DetailOLDData != null)
{
Ds_detl = dt_DetailOLDData;
}
try
{
if (Ds_detl.Rows.Count == 0) //if (Ds.Tables.Count == 0)
{
//從DB讀取一空table回來
string SessionIDName = "SYS202_" + PageTimeStamp.Value;
SYSModel.MaintainCodeFile BCO = new SYSModel.MaintainCodeFile(ConnectionDB);
ParameterList.Clear();
Dt = BCO.QueryLineSwitch(SYSModel.MaintainCodeFile.QueryType.Empty, ParameterList);
}
else
{
Dt = Ds_detl;//Ds.Tables[0];
}
tempID_dtl = 0;
DataView tempDT = new DataView();
tempDT.Table = Dt.Copy();
tempDT.Sort = "ID ASC";
if (Dt.Rows.Count != 0)
{
tempID_dtl = Convert.ToInt32(tempDT[Dt.Rows.Count - 1]["ID"].ToString());
}
//ID和PID暫自訂, 真正寫入CO時會重取
//LineItem畫面元件內容
string v_Code = ((WUI.SLP.SLPUnique)FormView1.FindControl("TextBoxCode")).Text.Trim();
string v_Scode = this.TextBoxScode_Uniq.Text.Trim();
string v_Explain = this.TextBoxExplain_Fvm.Text.Trim();
int v_PID = int.Parse(((TextBox)FormView1.FindControl("TextBoxID")).Text.Trim());
int v_ID = tempID_dtl + 1;
//檢查SCODE 是否已存在Dt
DataRow[] ins = Dt.Select(string.Format("SCODE='{0}'", v_Scode));
if (ins.Length <= 0) //1:已存在Dt 0:不存在Dt
{
DataRow dRow = Dt.NewRow();
dRow["ID"] = v_ID;
dRow["PID"] = v_PID;
dRow["CREATEDATE"] = DateTime.Now;
dRow["UPDATEDATE"] = DateTime.Now;
dRow["CREATEUID"] = Session["UID"];
dRow["UPDATEUID"] = Session["UID"];
dRow["ENABLE"] = "1";
dRow["CATEGORY"] = v_Code;
dRow["SCODE"] = v_Scode;
dRow["EXPLAIN"] = v_Explain;
Dt.Rows.Add(dRow);
}
else
{
this.ShowErrorMessage("明細代碼重覆!");
}
this.TextBoxScode_Uniq.Text = " ";
this.TextBoxExplain_Fvm.Text = " ";
this.PanelDetail.Visible = false;
#region 使用XML放置到前端資料
dt_DetailOLDData = Dt;
#endregion
BindTempTable_Dtl();
this.ButtonNewLine.Visible = true;
Dtl_Status = "readonly";
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
finally { }
}
protected void Update_Dtl2(System.Data.Common.DbTransaction DBT)
{
#region 取得temp中之資料
try
{
SYSModel.MaintainCodeFile BCO = new SYSModel.MaintainCodeFile(ConnectionDB);
string strCATEGORY = ((WUI.SLP.SLPUnique)FormView1.FindControl("TextBoxCode")).Text.Trim();
DataTable dtData = dt_TempDetail2;
//N_ID IN NUMBER,
//V_CODE IN VARCHAR2,
//V_SCODE IN VARCHAR2,
//V_CATEGORY IN VARCHAR2,
//D_UPDATEDATE IN DATE,
//V_UPDATEUID IN VARCHAR2,
//D_OLDUPDATEDATE IN DATE,
//V_OLDUPDATEUID IN VARCHAR2
ParameterList.Clear();
ParameterList.Add(DBNull.Value);
ParameterList.Add(DBNull.Value);
ParameterList.Add(DBNull.Value);
ParameterList.Add(strCATEGORY);
ParameterList.Add(DateTime.Now);
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(DBNull.Value);
ParameterList.Add(DBNull.Value);
BCO.DeleteTHRID(ParameterList, DBT);
for (int i = 0; i < dtData.Rows.Count; i++)
{
//N_PID IN NUMBER,
//D_CREATEDATE IN DATE,
//V_CREATEUID IN VARCHAR2,
//D_UPDATEDATE IN DATE,
//V_UPDATEUID IN VARCHAR2,
//V_CATEGORY IN VARCHAR2,
//V_SCODE IN VARCHAR2,
//V_CODE IN VARCHAR2,
//V_EXPLAIN
ParameterList.Clear();
ParameterList.Add(int.Parse(dtData.Rows[i]["PID"].ToString()));
ParameterList.Add(DateTime.Now);
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(DateTime.Now);
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(dtData.Rows[i]["CATEGORY"].ToString());
ParameterList.Add(dtData.Rows[i]["SCODE"].ToString());
ParameterList.Add(dtData.Rows[i]["CODE"].ToString());
ParameterList.Add(dtData.Rows[i]["EXPLAIN"].ToString());
BCO.CreateTHRID(ParameterList, DBT);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);//error訊息丟出顯示
}
#endregion
}
//Update GridView2
protected void Update_Dtl(System.Data.Common.DbTransaction DBT)
{
#region 取得temp中之資料
try
{
SYSModel.MaintainCodeFile BCO = new SYSModel.MaintainCodeFile(ConnectionDB);
string strCode = ((WUI.SLP.SLPUnique)FormView1.FindControl("TextBoxCode")).Text.Trim();
DataTable dtData = dt_DetailOLDData;
ParameterList.Clear();
ParameterList.Add(strCode);
ParameterList.Add(DateTime.Now);
ParameterList.Add(Session["UID"].ToString());
BCO.DelCodeFileDTLByCode(ParameterList, DBT);
for (int i = 0; i < dtData.Rows.Count; i++)
{
ParameterList.Clear();
ParameterList.Add(dtData.Rows[i]["PID"]); //CODE_MAIN的ID欄位
ParameterList.Add(dtData.Rows[i]["CREATEDATE"]);
ParameterList.Add(dtData.Rows[i]["CREATEUID"]);
ParameterList.Add(DateTime.Now);
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(dtData.Rows[i]["CATEGORY"]);//CODE_MAIN的CODE欄位
ParameterList.Add(dtData.Rows[i]["SCODE"]);
ParameterList.Add(dtData.Rows[i]["EXPLAIN"]);
BCO.CreateCodeFileDTL(ParameterList, DBT);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);//error訊息丟出顯示
}
#endregion
}
/// <summary>
/// 查詢資料庫取得資料
/// </summary>
private void databind()
{
//抓取本頁初次登記的時間
string SessionIDName = "SYS201_" + PageTimeStamp.Value;
SYSModel.MaintainCodeFile BCO = new SYSModel.MaintainCodeFile(ConntionDB);
ParameterList.Clear();
ParameterList.Add(TextBoxCode.Text.Trim());
ParameterList.Add(TextBoxName.Text.Trim());
ParameterList.Add(TextBoxMain_Explain.Text.Trim());
ParameterList.Add(TextBoxScode.Text.Trim());
ParameterList.Add(TextBoxExplain.Text.Trim());
ParameterList.Add("1");//SLP_Enable.Text.Trim());
ParameterList.Add(TextBoxRowCountLimit.Text.Trim());
DataTable Dt = BCO.QueryRow(ParameterList, CheckBoxLikeSearch.Checked);
Session[SessionIDName] = Dt;
GridView1.DataSource = Dt;
//設定分頁大小
if (TextBoxPagesize.Text == "0")
{
GridView1.PageSize = 1;
}
else
{
GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
}
GridView1.PageIndex = 0;
GridView1.DataBind();
#region 將Key值存到Session中
ArrayList arl_Key = new ArrayList();
foreach (DataRow drRow in Dt.Rows)
{ arl_Key.Add("id=" + drRow["ID"].ToString()); }
Session["SYS20_SortKey" + this.PageTimeStamp.Value] = arl_Key;
#endregion
//if (Dt.Rows.Count == 0)
//{ this.ErrorMsgLabel.Text = "查無資料"; }
}
private void Loaddata(string NewCode)
{
SYSModel.MaintainCodeFile BCO = new SYSModel.MaintainCodeFile(ConnectionDB);
ParameterList.Clear();
ParameterList.Add(NewCode);
DataTable Dt = BCO.QueryCodeFileByCode(ParameterList);
if (Dt != null)
{
if (Dt.Rows.Count == 0)
{
ArrayList AL = (ArrayList)Session["SYS20_SortKey" + Request.QueryString["SYS202_PageTimeStamp"]];
string strRemove = "id=" + NewCode;
AL.Remove(strRemove);
Session["SYS20_SortKey" + Request.QueryString["SYS202_PageTimeStamp"]] = AL;
throw new Exception("此筆資料已被其他使用者刪除,請點選上一筆/下一筆鈕或回查詢頁重新查詢!");
}
}
}
private DataTable GetCodeFile(string strCategory)
{
ParameterList.Clear();
SYSModel.MaintainCodeFile BCO = new SYSModel.MaintainCodeFile(ConntionDB);
ParameterList.Add(strCategory); //CATEGORY
ParameterList.Add(""); //NAME
ParameterList.Add(""); //SCODE
ParameterList.Add(""); //EXPLAIN
ParameterList.Add(9999);
return BCO.QueryByLikeForSLP(ParameterList);
}
/// <summary>
/// 取得所有Master資料以巡覽
/// </summary>
private void GetAllMasterRecordsForBrowse()
{
#region
SYSModel.MaintainCodeFile BCO = new SYSModel.MaintainCodeFile(ConnectionDB);
DataTable dtTemp = BCO.QueryCodeFileByALL();
DataView dvForBrowse = dtTemp.DefaultView;
dtForBrowse = dvForBrowse.ToTable();
#endregion
}
}//ButtonQuery_Click
private void databind()
{
//抓取本頁初次登記的時間
string SessionIDName = "SYS_CodeFile_" + PageTimeStamp.Value;
ParameterList.Clear();
SYSModel.MaintainCodeFile BCO = new SYSModel.MaintainCodeFile(ConntionDB);
//ParameterList.Add(TextBoxCode.Text);
ParameterList.Add(Category); //CATEGORY
ParameterList.Add(TextBoxName.Text); //NAME
ParameterList.Add(TextBoxScode.Text); //SCODE
ParameterList.Add(TextBoxExplain.Text); //EXPLAIN
ParameterList.Add(TextBoxRowCountLimit.Text.Trim());
DataTable Dt = BCO.QueryByLikeForSLP(ParameterList);
firstpage = 0;
firstindex = -1;
//DataTable Dt = BCO.QueryLineSwitch(SYSModel.MaintainCodeFile.QueryType.CODE,
// ParameterList
// );
Session[SessionIDName] = Dt;
GridView1.DataSource = Dt;
//設定分頁大小
if (TextBoxPagesize.Text == "0")
{
GridView1.PageSize = 1;
}
else
{
GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
}
GridView1.PageIndex = 0;
GridView1.DataBind();
GridView1.SelectedIndex = -1;
}//databind
protected void DoAddDetail()
{
try
{
txtCheckQty.Text = txtAdjQty.Text;
MaintainStoreTransfer bco = new MaintainStoreTransfer(ConnectionDB);
DataTable dtPriceInfo = null;
//依第一筆商品明細，取得 稅別、群分類、是否檔期、票期
//並更新對應欄位的值
ArrayList parameterList = new ArrayList();
parameterList.Add(Session.SessionID);
parameterList.Add(txtStore.Text);
parameterList.Add(txtItem.Text);
parameterList.Add(txtPeriod.Text);
parameterList.Add(Convert.ToDateTime(txtSignDate.Text).ToString("yyyyMMdd"));
if (int.Parse(ddlIOType.Text) == 24)
parameterList.Add(31);
else if (int.Parse(ddlIOType.Text) == 25)
parameterList.Add(33);
else
parameterList.Add(int.Parse(ddlIOType.Text));
dtPriceInfo = bco.GetPriceInfoList_PROMOTE(true, parameterList);
if (dtPriceInfo.Rows[0]["PriceDiscountKind"].ToString() == "0")
{
ErrorMsgLabel.Text = dtPriceInfo.Rows[0]["MESSAGE"].ToString();
return;
}
if (GridView1.Rows.Count == 0)
{
string taxType, rootNo, isSchedule;
rootNo = dtPriceInfo.Rows[0]["RootNo"].ToString();
taxType = dtPriceInfo.Rows[0]["TaxType"].ToString();
int i = int.Parse(dtPriceInfo.Rows[0]["PriceDiscountKind"].ToString());
isSchedule = i >= 64 ? "1" : "0";
InvoiceDateRange = dtPriceInfo.Rows[0]["ChargeDate"].ToString();
SLP_COL_DAYS.Text = InvoiceDateRange;
rblTaxType.Text = taxType;
txtRootNo.Text = rootNo;
rblIsSchedule.Text = isSchedule;
ItemKey = rootNo + taxType + isSchedule + InvoiceDateRange;
slpPROMOTE_ID.Text = dtPriceInfo.Rows[0]["PROMOTE_ID"].ToString();
}
else
{
if (RowMode == RowEditMode.Add)
{
int i = int.Parse(dtPriceInfo.Rows[0]["PriceDiscountKind"].ToString());
string isSchedule = i >= 64 ? "1" : "0";
if (dtPriceInfo.Rows[0]["RootNo"].ToString() +
dtPriceInfo.Rows[0]["TaxType"].ToString() +
isSchedule +
dtPriceInfo.Rows[0]["ChargeDate"].ToString() != ItemKey)
{
ErrorMsgLabel.Text = "稅別、群分類、是否檔期或票期不同無法新增";
return;
}
if (slpPROMOTE_ID.Text.Trim() != dtPriceInfo.Rows[0]["PROMOTE_ID"].ToString().Trim())
{
ErrorMsgLabel.Text = "檔期編號不同無法新增";
return;
}
}
}
//3.4 記錄在暫存的TABLE內，待按下新增時才會存到資料庫
//itemName, stAcceptQty, backwardQty, listDisRate, listPrice, retailPrice
//品名 進貨數 退貨數 牌價折扣率 牌價 零售價
MaintainCodeFile BCO = new MaintainCodeFile(ConnectionDB);
ArrayList parameters = new ArrayList();
DataTable dt = null;
switch (RowMode)
{
case RowEditMode.Add:
MaintainSKU sku = new MaintainSKU(ConnectionDB);
ArrayList list = new ArrayList();
list.Add(txtItem.Text);
DataTable dtItem = sku.QuerySKUByCode(list);
string itemName = dtItem.Rows[0]["ITEM_NAME"].ToString();
IDataReader dr = bco.GetInvInfo(txtStore.Text, txtItem.Text, txtPeriod.Text);
string stAcceptQty, backwardQty = "";
if (!dr.Read())
{
stAcceptQty = "0";
backwardQty = "0";
}
else
{
stAcceptQty = dr["ST_ACCEPT_QTY"].ToString();
backwardQty = dr["BACKWARD_QTY"].ToString();
}
dr.Close();
string listDisRate, listPrice, retailPrice, srcCostPrice, priceDiscountKind;
listDisRate = dtPriceInfo.Rows[0]["LISTDISRATE"].ToString();
listPrice = dtPriceInfo.Rows[0]["LISTPRICE"].ToString();
retailPrice = dtPriceInfo.Rows[0]["SRC_RETAILPRICE"].ToString();
srcCostPrice = dtPriceInfo.Rows[0]["SRC_COSTPRICE"].ToString();
priceDiscountKind = dtPriceInfo.Rows[0]["PRICEDISCOUNTKIND"].ToString();
DataRow row = DiffData.NewRow();
row["Item"] = txtItem.Text;
row["ITEM_NAME"] = itemName;
row["Period"] = txtPeriod.Text;
row["PSS_ST_ACCEPT_QTY"] = stAcceptQty;
row["PSS_BACKWARD_QTY"] = backwardQty;
row["DIFF_QTY"] = txtAdjQty.Text;
if (txtCheckQty.Text.Length > 0)
{
row["CHECK_QTY"] = txtCheckQty.Text;
}
else
{
row["CHECK_QTY"] = System.DBNull.Value;
}
row["Cost"] = srcCostPrice;
row["Cost_Dis_Rate"] = decimal.Parse(listDisRate);
row["Cost_Dis"] = decimal.Parse(listPrice);
row["Price"] = decimal.Parse(retailPrice);
row["PDKIND"] = int.Parse(priceDiscountKind);
if (txtReason.Text.Length > 0)
{
row["CHECK_REASON"] = txtReason.Text;
}
else
{
row["CHECK_REASON"] = System.DBNull.Value;
}
parameters.Add("1"); /* 1是原因判斷的Category */
parameters.Add(txtReason.Text);
dt = BCO.QueryLineSwitch(MaintainCodeFile.QueryType.SLP,
parameters
);
row["EXPLAIN"] = dt.Rows[0]["EXPLAIN"].ToString();
DiffData.Rows.Add(row);
break;
case RowEditMode.Edit:
DataRow[] dra = DiffData.Select(string.Format("Item = '{0}' AND Period = '{1}'", txtItem.Text, txtPeriod.Text));
parameters.Add("1"); /* 1是原因判斷的Category */
parameters.Add(txtReason.Text);
dt = BCO.QueryLineSwitch(MaintainCodeFile.QueryType.SLP,
parameters
);
if (txtReason.Text.Length > 0)
{
dra[0]["CHECK_REASON"] = txtReason.Text;
}
else
{
dra[0]["CHECK_REASON"] = System.DBNull.Value;
}
dra[0]["EXPLAIN"] = dt.Rows[0]["EXPLAIN"].ToString();
dra[0]["DIFF_QTY"] = txtAdjQty.Text;
if (txtCheckQty.Text.Length > 0)
{
dra[0]["CHECK_QTY"] = txtCheckQty.Text;
}
else
{
dra[0]["CHECK_QTY"] = System.DBNull.Value;
}
break;
}
GridView1.DataSource = DiffData;
GridView1.DataBind();
txtItem.Text = txtPeriod.Text = txtAdjQty.Text = txtCheckQty.Text = txtReason.Text = "";
pnlAddDiffItem1.Visible = false;
btnAddDiffItem.Visible = true;
}
catch (Exception ex)
{
WaringLogProcess(ex.Message);
this.ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個
}
finally { Finally_Function(); }
}
