private void Loaddata(string NewCode)
{
CGDModel.CGD36_BCO BCO = new CGDModel.CGD36_BCO(ConnectionDB);
ParameterList.Clear();
ParameterList.Add(NewCode);
DataTable Dt = BCO.QuerySwitch(CGDModel.CGD36_BCO.QueryType.ID, ParameterList);
if (Dt != null)
{
if (Dt.Rows.Count == 0)
{
ArrayList AL = (ArrayList)Session["CGD36_SortKey" + Request.QueryString["CGD362_PageTimeStamp"]];
string strRemove = "id=" + NewCode;
AL.Remove(strRemove);
Session["CGD36_SortKey" + Request.QueryString["CGD362_PageTimeStamp"]] = AL;
ErrorMsgLabel.Text = "此筆資料已被其他使用者刪除,請點選上一筆/下一筆鈕或回查詢頁重新查詢!";
}
}
}
}//end InsertCancelButton_Click
/// <summary>
/// 由新增模式，確認新增
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void InsertButton_Click(object sender, EventArgs e)
{
int AddRecord = 0;
CGDModel.CGD36_BCO BCO = new CGDModel.CGD36_BCO(ConnectionDB);
System.Data.Common.DbTransaction DBT = BCO.DBT_Begin();
try
{
if (Dtl_Status != "readonly")
{
ErrorMsgLabel.Text = "請先將明細資料做[存檔]或[更新]，再按主檔[更新]!";
}
else
{
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();
ParameterList.Add(v_Code);
DataTable Dup = BCO.QuerySwitch(CGDModel.CGD36_BCO.QueryType.CODE, ParameterList);
if (Dup.Rows.Count > 0)
{
ErrorMsgLabel.Text = "代碼重覆!";
return;
}
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);
AddRecord = BCO.CreateCodeFile(ParameterList, DBT);
if (AddRecord == 0)
{
ErrorMsgLabel.Text = "新增0筆資料!";
return;
}
else
{
DataTable dtData = dt_DetailOLDData;
for (int i = 0; i < dtData.Rows.Count; i++)
{
ParameterList.Clear();
ParameterList.Add(AddRecord); //CODE_MAIN的ID欄位
ParameterList.Add(processtime);
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(processtime);
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(v_Code);//CODE_MAIN的CODE欄位
ParameterList.Add(dtData.Rows[i]["SCODE"]);
ParameterList.Add(dtData.Rows[i]["EXPLAIN"]);
ParameterList.Add(dtData.Rows[i]["FIX_COLUMN"]);
BCO.CreateCodeFileDTL(ParameterList, DBT);
}
DBT.Commit();
Response.Write("<script>alert('新增完成');location.replace('CGD362.aspx?code=CGD36&mode=readonly&ID=" + AddRecord + "');</script>");
}
}
}
catch (Exception ex)
{
ErrorMsgLabel_Insert.Text = ex.Message;
}
}
}//databind
/// <summary>
/// 繫結資料 MST
/// </summary>
/// <param name=VirtualDataID></param>
private void databind_Mst(FormViewMode fvm)
{
try
{
CGDModel.CGD36_BCO BCO = new CGDModel.CGD36_BCO(ConnectionDB);
ParameterList.Clear();
if (Request["ID"] != null)
ParameterList.Add(Request["ID"].ToString());
else
ParameterList.Add("0");
dt_Result = BCO.QuerySwitch(CGDModel.CGD36_BCO.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 = ((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
