public string BusDocumentMetaName(string Code)
{
string Name = "";
string ConnectionDBStr = ((DatabaseSettings)ConfigurationManager.GetSection("dataConfiguration")).DefaultDatabase;
MaintainBusDocumentMeta BCO = new MaintainBusDocumentMeta(ConnectionDBStr);
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(Code);
if (Code != "")
{
DataTable Dt = BCO.QueryForSLP(ParameterList);
if (Dt.Rows.Count > 0)
{
Name = Dt.Rows[0]["Name"].ToString().Trim();
}
else
{
Name = "無資料";
}
}
return Name;
}
/// <summary>
/// 於檢視模式，按下刪除鈕
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void DeleteButton_Click(object sender, EventArgs e)
{
int DeleteRecord = 0;
try
{
#region 取得畫面元件的值
DateTime processtime = DateTime.Now;
#endregion
#region 取得刪除前舊值
#region 使用XML轉回DataSet
DataSet Ds = new DataSet();
DataTable Dt = dt_Result;
#endregion
if (Dt.Rows.Count == 0)
{
throw new Exception("抓取不到舊值,更新失敗!");
}
#endregion
#region 加入更新條件
ParameterList.Clear();
//舊值
ParameterList.Add(Dt.Rows[0]["ID"]);
ParameterList.Add(Dt.Rows[0]["CODE"]);
ParameterList.Add(Dt.Rows[0]["NAME"]);
ParameterList.Add(DateTime.Parse((Dt.Rows[0]["CREATEDATE"]).ToString()));
ParameterList.Add(Dt.Rows[0]["CREATEUID"]);
ParameterList.Add(DateTime.Parse((Dt.Rows[0]["UPDATEDATE"]).ToString()));
ParameterList.Add(Dt.Rows[0]["UPDATEUID"]);
ParameterList.Add(Dt.Rows[0]["ENABLE"]);
ParameterList.Add(Dt.Rows[0]["MODEL"]);
ParameterList.Add(Dt.Rows[0]["DESCRIPTION"]);
ParameterList.Add(Dt.Rows[0]["IOTYPE"]);
ParameterList.Add(Dt.Rows[0]["WEBURL"]);
ParameterList.Add(Dt.Rows[0]["DOCIDSERIALNEXT"]);
ParameterList.Add(Dt.Rows[0]["DOCCODESERIALNEXT"]);
ParameterList.Add(Dt.Rows[0]["PRECODE"]);
ParameterList.Add(DateTime.Parse((Dt.Rows[0]["APLDATE"]).ToString()).ToString("yyyyMMdd"));
ParameterList.Add(Dt.Rows[0]["SERIALFORMAT"]);
//需要更新值
ParameterList.Add(processtime);
ParameterList.Add(Session["UID"].ToString());
#endregion
SYSModel.MaintainBusDocumentMeta BCO = new SYSModel.MaintainBusDocumentMeta(ConnectionDB);
DeleteRecord = BCO.DeleteBusDocumentMetaReturn(ParameterList, null);
if (DeleteRecord == 0)
{
throw new Exception("刪除失敗!");
}
else
{
Response.Write("<script>alert('刪除完成');location.replace('SYS091.aspx?Code=SYS09');</script>");
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
}//end EditCancelButton_Click
/// <summary>
/// 編輯模式，按下更新確認鈕
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void EditCommitButton_Click(object sender, EventArgs e)
{
try
{
ErrorMsgLabel.Text = "";
int UpdateRecord = 0;
#region 取得畫面元件的值
string v_Name = ((TextBox)FormView1.FindControl("TextBoxName")).Text.Trim();
DateTime processtime = DateTime.Now;
string v_Model = ((TextBox)FormView1.FindControl("TextBoxModel")).Text.Trim();
string v_Description = ((TextBox)FormView1.FindControl("TextBoxDescription")).Text.Trim();
string v_Weburl = ((TextBox)FormView1.FindControl("TextBoxWebURL")).Text.Trim();
string v_Doctid = ((TextBox)FormView1.FindControl("TextBoxDocIDSerialNext")).Text.Trim();
string v_DocCode = ((TextBox)FormView1.FindControl("TextBoxDocCodeSerialNext")).Text.Trim();
string v_IOtype = ((WUI.SLP.ENVIOType)FormView1.FindControl("SLP_IOType")).Text.Trim();
string v_PreCode = ((TextBox)FormView1.FindControl("TextBoxPreCode")).Text.Trim();
string v_AplDate = "";
if (((WUI.SLP.SLPDate)FormView1.FindControl("SLP_AplDate")).Text == "")
{
v_AplDate = "";
}
else
{
DateTime newapldate;
newapldate = DateTime.Parse(((WUI.SLP.SLPDate)FormView1.FindControl("SLP_AplDate")).Text.Trim());
DateTime sysdate;
sysdate = DateTime.Now;
if (newapldate.ToString("yyyyMMdd") != sysdate.ToString("yyyyMMdd"))
{
if (newapldate.CompareTo(sysdate) < 0)
{
ShowErrorMessage("業務日期需大於等於系統日期");
return;
}
else
{
v_AplDate = ((WUI.SLP.SLPDate)FormView1.FindControl("SLP_AplDate")).Text.Trim().Replace("/", "");
}
}
else
{
v_AplDate = ((WUI.SLP.SLPDate)FormView1.FindControl("SLP_AplDate")).Text.Trim().Replace("/", "");
}
}
string v_SerialFormat = ((TextBox)FormView1.FindControl("TextBoxSerialFormat")).Text.Trim();
string v_Enable = "1";// ((WUI.SLP.SLP_Boolean)FormView1.FindControl("SLP_Enable")).Text.Trim();
#endregion
#region 取得更新前舊值
#region 使用XML轉回DataSet
DataSet Ds = new DataSet();
DataTable Dt = dt_Result;
#endregion
if (Dt.Rows.Count == 0)
{
throw new Exception("抓取不到舊值,更新失敗!");
}
#endregion
#region 加入更新條件
ParameterList.Clear();
//舊值
ParameterList.Add(Dt.Rows[0]["ID"]);
ParameterList.Add(Dt.Rows[0]["CODE"]);
ParameterList.Add(Dt.Rows[0]["NAME"]);
ParameterList.Add(DateTime.Parse((Dt.Rows[0]["CREATEDATE"]).ToString()));
ParameterList.Add(Dt.Rows[0]["CREATEUID"]);
ParameterList.Add(DateTime.Parse((Dt.Rows[0]["UPDATEDATE"]).ToString()));
ParameterList.Add(Dt.Rows[0]["UPDATEUID"]);
ParameterList.Add(Dt.Rows[0]["ENABLE"]);
ParameterList.Add(Dt.Rows[0]["MODEL"]);
ParameterList.Add(Dt.Rows[0]["DESCRIPTION"]);
ParameterList.Add(Dt.Rows[0]["IOTYPE"]);
ParameterList.Add(Dt.Rows[0]["WEBURL"]);
ParameterList.Add(Dt.Rows[0]["DOCIDSERIALNEXT"]);
ParameterList.Add(Dt.Rows[0]["DOCCODESERIALNEXT"]);
ParameterList.Add(Dt.Rows[0]["PRECODE"]);
if (Dt.Rows[0]["APLDATE"].ToString() != "")
{
ParameterList.Add(DateTime.Parse((Dt.Rows[0]["APLDATE"]).ToString()).ToString("yyyyMMdd"));
}
else
{
ParameterList.Add(Dt.Rows[0]["APLDATE"]);
}
ParameterList.Add(Dt.Rows[0]["SERIALFORMAT"]);
//需要更新值
ParameterList.Add(v_Name);
ParameterList.Add(processtime);
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(v_Model);
ParameterList.Add(v_Description);
if (v_IOtype != "")
{ ParameterList.Add(int.Parse(v_IOtype)); }
else
{ ParameterList.Add(0); }
ParameterList.Add(v_Weburl);
if (v_Doctid != "")
{ ParameterList.Add(Decimal.Parse(v_Doctid)); }
else
{ ParameterList.Add(1); }
if (v_DocCode != "")
{ ParameterList.Add(Decimal.Parse(v_DocCode));
}
else
{ ParameterList.Add(1); }
ParameterList.Add(v_PreCode);
ParameterList.Add(v_AplDate);//YYMMDD
ParameterList.Add(v_SerialFormat);
ParameterList.Add(v_Enable);
#endregion
SYSModel.MaintainBusDocumentMeta BCO = new SYSModel.MaintainBusDocumentMeta(ConnectionDB);
UpdateRecord = BCO.UpdateBusDocumentMetaReturn(ParameterList, null);
if (UpdateRecord == 0)
{
throw new Exception("更新0筆資料!");
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "SYS092", "<script>alert('更改完成');</script>");
ChangeFormMode(FormViewMode.ReadOnly);
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
}//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
{
ErrorMsgLabel.Text = "";
#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_Model = ((TextBox)FormView1.FindControl("TextBoxModel")).Text.Trim();
string v_Description = ((TextBox)FormView1.FindControl("TextBoxDescription")).Text.Trim();
string v_Weburl = ((TextBox)FormView1.FindControl("TextBoxWebURL")).Text.Trim();
string v_Doctid = ((TextBox)FormView1.FindControl("TextBoxDocIDSerialNext")).Text.Trim();
string v_DocCode = ((TextBox)FormView1.FindControl("TextBoxDocCodeSerialNext")).Text.Trim();
string v_IOtype = ((WUI.SLP.ENVIOType)this.FormView1.FindControl("SLP_IOType")).Text.Trim();
string v_PreCode = ((TextBox)FormView1.FindControl("TextBoxPreCode")).Text.Trim();
string v_AplDate = DateTime.Now.ToString("yyyyMMdd").ToString();
string v_SerialFormat = ((TextBox)FormView1.FindControl("TextBoxSerialFormat")).Text.Trim();
string v_Is_Need_Date = ((WUI.SLP.SLP_Boolean)FormView1.FindControl("SLP_NeedDate")).Text.Trim();
string v_Is_Need_Check = ((WUI.SLP.SLP_Boolean)FormView1.FindControl("SLP_NeedCheck")).Text.Trim();
ParameterList.Clear();
SYSModel.MaintainProgram Uniq = new SYSModel.MaintainProgram(ConnectionDB);
ParameterList.Add(v_Code);
ParameterList.Add("SYS_BusDocumentMeta");
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
#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_Model);
ParameterList.Add(v_Description);
if (v_IOtype != "")
{ ParameterList.Add(int.Parse(v_IOtype));}
else
{ ParameterList.Add(0);}
ParameterList.Add(v_Weburl);
if (v_Doctid != "")
{ ParameterList.Add(Decimal.Parse(v_Doctid)); }
else
{ ParameterList.Add(0);}
if (v_DocCode != "")
{ ParameterList.Add(int.Parse(v_DocCode)); }
else
{ ParameterList.Add(1); }
ParameterList.Add(v_PreCode);
ParameterList.Add(v_AplDate);//ParameterList.Add(v_AplDate.Replace("/", ""));
ParameterList.Add(v_SerialFormat);
if (v_Is_Need_Date != "")
{ ParameterList.Add(int.Parse(v_Is_Need_Date)); }
else
{ ParameterList.Add(1);}
if (v_Is_Need_Check != "")
{ ParameterList.Add(int.Parse(v_Is_Need_Check)); }
else
{ ParameterList.Add(0); }
#endregion
SYSModel.MaintainBusDocumentMeta BCO = new SYSModel.MaintainBusDocumentMeta(ConnectionDB);
AddRecord = BCO.CreateBusDocumentMeta(ParameterList, null);
if (AddRecord == 0)
{
throw new Exception("新增0筆資料!");
}
else
{
Response.Write("<script>alert('新增完成');location.replace('SYS092.aspx?mode=readonly&ID=" + AddRecord + "');</script>");
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
/// <summary>
/// 取得所有Master資料以巡覽
/// </summary>
private void GetAllMasterRecordsForBrowse()
{
#region
SYSModel.MaintainBusDocumentMeta BCO = new SYSModel.MaintainBusDocumentMeta(ConnectionDB);
DataTable dtTemp = BCO.QueryBusDocumentMetaByALL();
DataView dvForBrowse = dtTemp.DefaultView;
dtForBrowse = dvForBrowse.ToTable();
#endregion
}
private void Loaddata(string NewCode)
{
SYSModel.MaintainBusDocumentMeta BCO = new SYSModel.MaintainBusDocumentMeta(ConnectionDB);
ParameterList.Clear();
ParameterList.Add(NewCode);
DataTable Dt = BCO.QueryBusDocumentMetaByID(ParameterList);
if (Dt != null)
{
if (Dt.Rows.Count == 0)
{
ArrayList AL = (ArrayList)Session["SYS09_SortKey" + Request.QueryString["SYS092_PageTimeStamp"]];
string strRemove = "id=" + NewCode;
AL.Remove(strRemove);
Session["SYS09_SortKey" + Request.QueryString["SYS092_PageTimeStamp"]] = AL;
throw new Exception("此筆資料已被其他使用者刪除,請點選上一筆/下一筆鈕或回查詢頁重新查詢!");
}
}
}
/// <summary>
/// 繫結資料
/// </summary>
/// <param name=VirtualDataID></param>
private void databind(FormViewMode fvm)
{
try
{
SYSModel.MaintainBusDocumentMeta BCO = new SYSModel.MaintainBusDocumentMeta(ConnectionDB);
ParameterList.Clear();
if (Request["ID"] != null)
ParameterList.Add(Request["ID"].ToString());
else
ParameterList.Add("0");
dt_Result = BCO.QuerySwitch(SYSModel.MaintainBusDocumentMeta.QueryType.ID,
ParameterList
);
if (dt_Result.Rows.Count > 0)
{
this.hiddenID.Value = dt_Result.Rows[0]["ID"].ToString();
FormView1.DataSource = dt_Result;
FormView1.DataBind();
}
AuthorityControls(this);
//ToolBarStatus
switch (fvm)
{
case FormViewMode.Edit:
//修改All換為空值
DropDownList D1 = ((DropDownList)this.FormView1.FindControl("SLP_IOType").FindControl("D1"));
D1.Items.RemoveAt(0);
TextBox edit_txtname = ((TextBox)this.FormView1.FindControl("TextBoxCode").FindControl("TextBoxName"));
edit_txtname.Visible = false;
ToolBarStatus("edit");
break;
case FormViewMode.Insert:
((TextBox)this.FormView1.FindControl("SLP_AplDate").FindControl("TextBoxCode")).Text = DateTime.Now.ToString("yyyy/MM/dd");
ToolBarStatus("insert");
break;
case FormViewMode.ReadOnly:
//修改All換為空值
DropDownList D3 = ((DropDownList)this.FormView1.FindControl("SLP_IOType").FindControl("D1"));
D3.Items[0].Text = "";
TextBox txtname = ((TextBox)this.FormView1.FindControl("TextBoxCode").FindControl("TextBoxName"));
txtname.Visible = false;
ToolBarStatus("readonly");
break;
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}//databind
/// <summary>
/// 查詢資料庫取得資料
/// </summary>
private void databind()
{
//抓取本頁初次登記的時間
string SessionIDName = "SYS091_" + PageTimeStamp.Value;
SYSModel.MaintainBusDocumentMeta BCO = new SYSModel.MaintainBusDocumentMeta(ConntionDB);
ParameterList.Clear();
ParameterList.Add(TextBoxCode.Text.Trim());
ParameterList.Add(TextBoxName.Text.Trim());
ParameterList.Add(TextBoxCreateDate.StartDate.Trim());
ParameterList.Add(TextBoxCreateDate.EndDate.Trim());
ParameterList.Add(TextBoxCreateUID.Text.Trim());
ParameterList.Add(TextBoxUpdateDate.StartDate.Trim());
ParameterList.Add(TextBoxUpdateDate.EndDate.Trim());
ParameterList.Add(TextBoxUpdateUID.Text.Trim());
ParameterList.Add(TextBoxModel.Text.Trim());
ParameterList.Add(TextBoxDescription.Text.Trim());
ParameterList.Add(TextBoxWebURL.Text.Trim());
ParameterList.Add(TextBoxDocIDSerialNext.Text.Trim());
ParameterList.Add("1");//SLP_Enable.Text.Trim());
ParameterList.Add(((DropDownList)SLP_IOType.FindControl("D1")).SelectedValue);
ParameterList.Add(TextBoxPreCode.Text.Trim());
ParameterList.Add(TextBoxSerialFormat.Text.Trim());
ParameterList.Add(SLP_AplDate.Text.Trim().Replace("/",""));
ParameterList.Add(TextBoxDocCodeSerialNext.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["SYS09_SortKey" + this.PageTimeStamp.Value] = arl_Key;
#endregion
if (Dt.Rows.Count == 0)
{ this.ErrorMsgLabel.Text = "查無資料"; }
}
public BusDocumentMeta()
{
co_main = new BCO.MaintainBusDocumentMeta(ConntionDB);
}
}//Initiziatoin_Component
private void dataget()
{
ParameterList.Clear();
SYSModel.MaintainBusDocumentMeta BCO = new SYSModel.MaintainBusDocumentMeta(ConntionDB);
ParameterList.Add(_Code);
if (_Code != "")
{
DataTable Dt = BCO.QueryForSLP(ParameterList);
//DataTable Dt = BCO.QuerySwitch(SYSModel.MaintainBusDocumentMeta.QueryType.CODE,
// ParameterList
// );
if (Dt.Rows.Count > 0)
{
_Name = Dt.Rows[0]["Name"].ToString().Trim();
}
else
{
_Name = "無資料";
}
}
HiddenField1.Value = _Name;
TextBoxName.Text = _Name;
}//dataget