protected void Page_Load(object sender, EventArgs e)
{
try
{
#region 清空Message
this.ErrorMsgLabel.Text = string.Empty;
this.RightMsgLabel.Text = string.Empty;
#endregion
if (!IsPostBack)
{
#region Attributes
this.but_Close.Attributes["onclick"] += "window.close();";
#endregion
#region 取得異常資料
#region 傳入參數
ParameterList.Clear();
ParameterList.Add(Session["UID"].ToString());
#endregion
#region 連結資料庫
BCO.MaintainPreItem bco = new BCO.MaintainPreItem(ConntionDB);
DataTable dt_Return = bco.QUERYERRORBYFIND(ParameterList);
#endregion
#region 檢查回傳資料
if (dt_Return.Rows.Count == 0)
{
this.ErrorMsgLabel.Text = "查無資料";
return;
}
else
{
this.gv_Result.DataSource = dt_Return;
this.gv_Result.DataBind();
}
#endregion
#endregion
}
}
catch (Exception ex)
{
WaringLogProcess(ex.Message);
this.ErrorMsgLabel.Text = ex.Message;
}
finally { }
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
this.ErrorMsgLabel.Text = string.Empty;
if (!IsPostBack)
{
ViewState["ID"] = "";
ViewState["UPDATEDATE"] = "";
ViewState["UPDATEUID"] = "";
btnSave.Enabled = false;
this.btnCancel.Attributes["onclick"] += "window.close();";
if (Request.QueryString["ID"] == null)
{
this.ErrorMsgLabel.Text = "ID參數為NULL";
return;
}
string strID = Request.QueryString["ID"].ToString();
BCO.MaintainPreItem bco = new BCO.MaintainPreItem(ConntionDB);
ParameterList.Clear();
ParameterList.Add(int.Parse(strID));
DataTable dtData = bco.QueryPreItemByID(ParameterList);
if (dtData.Rows.Count == 0)
{
this.ErrorMsgLabel.Text = "查無資料";
return;
}
else
{
lblITEM.Text = dtData.Rows[0]["ITEM"].ToString();
lblITEM_NAME.Text = dtData.Rows[0]["ITEM_NAME"].ToString();
txtRETURN_MEMO.Text = "";
btnSave.Enabled = true;
ViewState["ID"] = strID;
ViewState["UPDATEDATE"] = dtData.Rows[0]["UPDATEDATE"].ToString();
ViewState["UPDATEUID"] = dtData.Rows[0]["UPDATEUID"].ToString();
}
}
}
catch (Exception ex)
{
WaringLogProcess(ex.Message);
this.ErrorMsgLabel.Text = ex.Message;
}
finally { }
}
public SLP_PreItem()
{
co_main = new MaintainSKU(ConntionDB);
co_PreItem = new MaintainPreItem(ConntionDB);
}
protected void GridView1_RowCommand(Object sender, GridViewDeleteEventArgs e)
{
int index = Convert.ToInt32(e.RowIndex);
string v_ID = GridView1.DataKeys[index].Value.ToString();
ParameterList.Clear();
ParameterList.Add(v_ID);
DataTable dt = bco.QueryItemClassifyByID(ParameterList);
if (dt.Rows.Count == 0)
{
ErrorMsgLabel.Text = "刪除失敗，此資料已被其他使用者刪除，請重新查詢";
return;
}
// Display the selected author.
int res = 0;
try
{
ParameterList.Clear();
DataRow dr = dt.Rows[0];
MaintainSKU bcoSKU = new MaintainSKU(ConntionDB);
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.PATTERN_NO", dr["PATTERN_NO"].ToString() + "%", "like", "and");
DataTable dtExists = bcoSKU.QuerySKUByFind_1(ParameterList);
if (dtExists.Rows.Count > 0)
{
Alert("PatternNo使用中，無法刪除");
return;
}
MaintainPreItem bcoPreItem = new MaintainPreItem(ConntionDB);
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.PATTERN_NO", dr["PATTERN_NO"].ToString() + "%", "like", "and");
dtExists = bcoPreItem.QueryPreItemByFind_1(ParameterList);
if (dtExists.Rows.Count > 0)
{
Alert("PatternNo使用中，無法刪除");
return;
}
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_ID", dr["ID"].ToString()); //OLD_ID
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_UPDATEDATE", DateTime.Now); //NEW_UPDATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_UPDATEUID", Session["UID"].ToString()); //NEW_UPDATEUID
bco.DeleteItemClassify(ParameterList, null);
Page currentPage = (Page)HttpContext.Current.Handler;
string name = "alert";
string script = "alert('資料已刪除');location.replace('ITM241.aspx?Code=ITM24');";
ScriptManager.RegisterClientScriptBlock(currentPage, currentPage.GetType(), name, script, true);
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
finally { }
}
/// <summary>
/// 編輯模式，按下更新確認鈕
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void EditCommitButton_Click(object sender, EventArgs e)
{
int res = 0;
try
{
DataTable dt = bco.ConvertXMLToDataTable(MasterOLDData.InnerHtml);
DataRow dr = dt.Rows[0];
#region 新舊值比對
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.ID", dr["ID"].ToString(), "=", "and");
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.ENABLE", 1, "=", "and");
DataTable dtOld = bco.QueryItemClassifyByFind_1(ParameterList);
if (dtOld.Rows.Count == 0)
{ Alert("資料已被刪除，更新失敗"); return; }
else
{
DataRow drOld = dtOld.Rows[0];
if (dr["UpdateUid"].ToString() != drOld["UpdateUid"].ToString() ||
dr["UpdateDate"].ToString() != drOld["UpdateDate"].ToString())
{
Alert("更新失敗，此資料已被其他使用者異動，請重新查詢再進行編輯"); return;
}
}
#endregion
#region 取得畫面元件的值
string v_ID = ((TextBox)FormView1.FindControl("TextBoxID")).Text.Trim();
string v_ITEM_LAYER = ((RadioButtonList)FormView1.FindControl("rblITEM_LAYER")).Text.Trim();
string v_CODE = ((TextBox)FormView1.FindControl("txtCODE")).Text.Trim();
string v_NAME = ((TextBox)FormView1.FindControl("txtNAME")).Text.Trim();
string v_PATTERN_NAME = ((TextBox)FormView1.FindControl("txtPATTERN_NAME")).Text.Trim();
string v_PATTERN_ALIAS = ((TextBox)FormView1.FindControl("txtPATTERN_ALIAS")).Text.Trim();
object v_PARENTCODE = null;
string v_PATTERN_NO = "";
switch (v_ITEM_LAYER)
{
case "0":
if (v_CODE.Length != 1)
{
ErrorMsgLabel.Text = "群分類代碼須為一位";
return;
}
v_PATTERN_NO = string.Format("{0}", v_CODE);
break;
case "1":
v_PARENTCODE = ((DropDownList)FormView1.FindControl("ddlROOTNO")).Text.Trim();
if (v_CODE.Length != 2)
{
ErrorMsgLabel.Text = "大分類代碼須為兩位";
return;
}
if (v_PARENTCODE.ToString().Length == 0)
{
ErrorMsgLabel.Text = "未選擇群分類";
return;
}
v_PATTERN_NO = string.Format("{0}{1}",
v_PARENTCODE.ToString().Substring(0, 1),
v_CODE);
break;
case "2":
if (v_CODE.Length != 2)
{
ErrorMsgLabel.Text = "中分類代碼須為兩位";
return;
}
if (((DropDownList)FormView1.FindControl("ddlPMA")).Text.Trim() == "")
v_PARENTCODE = dt.Rows[0]["PARENTCODE"].ToString();
else
v_PARENTCODE = ((DropDownList)FormView1.FindControl("ddlPMA")).Text.Trim();
v_PATTERN_NO = string.Format("{0}{1}",
v_PARENTCODE.ToString().Substring(0, 3),
v_CODE);
break;
case "3":
if (v_CODE.Length != 2)
{
ErrorMsgLabel.Text = "小分類代碼須為兩位";
return;
}
if (((DropDownList)FormView1.FindControl("ddlCATEGORY")).Text.Trim() == "")
v_PARENTCODE = dt.Rows[0]["PARENTCODE"].ToString();
else
v_PARENTCODE = ((DropDownList)FormView1.FindControl("ddlCATEGORY")).Text.Trim();
v_PATTERN_NO = string.Format("{0}{1}",
v_PARENTCODE.ToString().Substring(0, 5),
v_CODE);
break;
}
#endregion 取得畫面元件的值
#region 資料檢查
if (v_CODE == "") { Alert("分類代碼不可空白"); return; }
if (v_NAME == "") { Alert("代碼名稱不可空白"); return; }
if (v_PATTERN_NO == "") { Alert("Pattern代碼不可空白"); return; }
if (v_ITEM_LAYER == "") { Alert("所屬層級不可空白"); return; }
if (Get_Byte_Length(v_PATTERN_NAME) > 30) { Alert("欄位[Pattern名稱]長度不可大於 30 Byte"); return; }
if (Get_Byte_Length(v_PATTERN_ALIAS) > 10) { Alert("欄位[Pattern簡稱]長度不可大於 10 Byte"); return; }
if (dr["ITEM_LAYER"].ToString() == "3")
{
ParameterList.Clear();
ParameterList.Add(dr["ID"].ToString());
bool IsExist = bco.CheckInUseItem(ParameterList);
if (IsExist == true)
{
Alert("PATTERN_NO使用中，無法修改");
return;
}
IsExist = bco.CheckInUsePreItem(ParameterList);
if (IsExist == true)
{
Alert("PATTERN_NO使用中，無法修改");
return;
}
}
else
{
ParameterList.Clear();
ParameterList.Add(dr["ID"].ToString());
bool IsExist = bco.CheckSubItemExist(ParameterList);
if (IsExist == true)
{
Alert("子項目已存在，無法修改");
return;
}
}
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.PATTERN_NO", v_PATTERN_NO, "=", "and");
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.PATTERN_NO", dr["PATTERN_NO"].ToString(), "<>", "and");
DataTable dtExists = bco.QueryItemClassifyByFind_1(ParameterList);
if (dtExists.Rows.Count > 0)
{
Alert("Pattern代碼已經存在");
return;
}
MaintainSKU bcoSKU = new MaintainSKU(ConntionDB);
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.PATTERN_NO", v_PATTERN_NO + "%", "like", "and");
dtExists = bcoSKU.QuerySKUByFind_1(ParameterList);
if (dtExists.Rows.Count > 0)
{
Alert("PatternNo使用中，無法修改");
return;
}
MaintainPreItem bcoPreItem = new MaintainPreItem(ConntionDB);
ParameterList.Clear();
ParameterList.Add(DBNull.Value); //N_ID
ParameterList.Add(DBNull.Value); //V_ITEM
ParameterList.Add(v_PATTERN_NO + "%"); //V_PATTERN_NO
dtExists = bcoPreItem.QueryPreItemByFind_1(ParameterList);
if (dtExists.Rows.Count > 0)
{
Alert("PatternNo使用中，無法修改");
return;
}
#endregion
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_ID", dr["ID"].ToString()); //OLD_ID
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_CODE", dr["CODE"].ToString()); //OLD_CODE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_NAME", dr["NAME"].ToString()); //OLD_NAME
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_PATTERN_NO", dr["PATTERN_NO"].ToString()); //OLD_PATTERN_NO
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_PATTERN_ALIAS", dr["PATTERN_ALIAS"].ToString()); //OLD_PATTERN_ALIAS
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_PARENTCODE", dr["PARENTCODE"].ToString()); //OLD_PARENTCODE
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_ITEM_LAYER", dr["ITEM_LAYER"].ToString()); //OLD_ITEM_LAYER
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_PATTERN_NAME", dr["PATTERN_NAME"].ToString()); //OLD_PATTERN_NAME
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_MEMO", dr["MEMO"].ToString()); //OLD_MEMO
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_UPDATEDATE", dr["UPDATEDATE"].ToString()); //OLD_UPDATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_UPDATEUID", dr["UPDATEUID"].ToString()); //OLD_UPDATEUID
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_CREATEUID", dr["CREATEUID"].ToString()); //OLD_CREATEUID
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_CREATEDATE", dr["CREATEDATE"].ToString()); //OLD_CREATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_ENABLE", dr["ENABLE"].ToString()); //OLD_ENABLE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_CODE", v_CODE); //NEW_CODE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_NAME", v_NAME); //NEW_NAME
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_PATTERN_NO", v_PATTERN_NO); //NEW_PATTERN_NO
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_PATTERN_ALIAS", v_PATTERN_ALIAS); //NEW_PATTERN_ALIAS
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_PARENTCODE", v_PARENTCODE); //NEW_PARENTCODE
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "NEW_ITEM_LAYER", v_ITEM_LAYER); //NEW_ITEM_LAYER
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_PATTERN_NAME", v_PATTERN_NAME); //NEW_PATTERN_NAME
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_MEMO", ""); //NEW_MEMO
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_UPDATEDATE", DateTime.Now); //NEW_UPDATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_UPDATEUID", Session["UID"].ToString()); //NEW_UPDATEUID
bco.UpdateItemClassify(ParameterList, null);
Response.Redirect("ITM242.aspx?Code=ITM24&isToolBar=N&SessionName=" + Request.QueryString["SessionName"] + "&arl_Key=" + Request.QueryString["arl_Key"] + "&ID=" + v_ID + "&showalert=YES");
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
finally { }
}//end EditCommitButton_Click
}//end InsertCancelButton_Click
/// <summary>
/// 於檢視模式，按下刪除鈕
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void DeleteButton_Click(object sender, EventArgs e)
{
int res = 0;
try
{
ParameterList.Clear();
DataTable dt = bco.ConvertXMLToDataTable(MasterOLDData.InnerHtml);
DataRow dr = dt.Rows[0];
MaintainSKU bcoSKU = new MaintainSKU(ConntionDB);
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.PATTERN_NO", dr["PATTERN_NO"].ToString() + "%", "like", "and");
DataTable dtExists = bcoSKU.QuerySKUByFind_1(ParameterList);
if (dtExists.Rows.Count > 0)
{
Alert("PatternNo使用中，無法刪除");
return;
}
MaintainPreItem bcoPreItem = new MaintainPreItem(ConntionDB);
ParameterList.Clear();
ParameterList.Add(DBNull.Value); //N_ID
ParameterList.Add(DBNull.Value); //V_ITEM
ParameterList.Add(dr["PATTERN_NO"].ToString() + "%"); //V_PATTERN_NO
dtExists = bcoPreItem.QueryPreItemByFind_1(ParameterList);
if (dtExists.Rows.Count > 0)
{
Alert("PatternNo使用中，無法刪除");
return;
}
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_ID", dr["ID"].ToString()); //OLD_ID
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_UPDATEDATE", DateTime.Now); //OLD_CREATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_UPDATEUID", Session["UID"].ToString()); //OLD_ENABLE
bco.DeleteItemClassify(ParameterList, null);
//Response.Write("<script>alert('刪除完成');location.replace('ITM241.aspx?Code=ITM24');</script>");
Script("alert('刪除完成');location.replace('ITM241.aspx?Code=ITM24');");
}
catch (Exception ex)
{
if (ex.Message.IndexOf("其他使用者異動,刪除") != -1)
ErrorMsgLabel.Text = "刪除失敗，此資料已被其他使用者刪除，請重新查詢";
else
ErrorMsgLabel.Text = ex.Message;
}
finally { }
}//DeleteButton_Click
/// <summary>
/// 寫LOG檔
/// </summary>
private void WriteLogFile(string strLogMsg, bool bOK)
{
ITMModel.MaintainPreItem bco = new ITMModel.MaintainPreItem(ConnnectionString);
bco.LogAdd(LogName, bOK, strLogMsg);
}
/// <summary>
/// 主檔載入:新品主檔(VDS_ITM_PRE_ITEM)send_flg=1 的資料
/// </summary>
/// <returns></returns>
private bool Transfer_ALL_ITEM()
{
bool bResult = false;
try
{
ITMModel.MaintainPreItem BCO = new ITMModel.MaintainPreItem(ConnnectionString);
ArrayList Para = new ArrayList();
Para.Clear();
Para.Add("VDS2G");
int iOK = 0;
int iNG = 0;
int iTotal = 0;
BCO.Transfer_ALL_ITEM(Para, null, out iOK, out iNG, out iTotal);
if (iNG == 0)
{
bResult = true;
}
WriteLogFile("處理筆數:" + iTotal.ToString() + ",成功:" + iOK.ToString() + ",失敗:" + iNG.ToString(), true);
}
catch (Exception ex)
{
throw ex;
}
return bResult;
}
public string PreItemName(string Code)
{
string Name = "";
string ConnectionDBStr = ((DatabaseSettings)ConfigurationManager.GetSection("dataConfiguration")).DefaultDatabase;
MaintainSKU co_main = new MaintainSKU(ConnectionDBStr);
MaintainPreItem co_PreItem = new MaintainPreItem(ConnectionDBStr);
ArrayList ParameterList = new ArrayList();
ParameterList.Add(Code);
DataTable dt = co_main.QuerySKUByCode(ParameterList);
if (dt.Rows.Count > 0)
{
Name = "已存在";
}
else
{
dt = co_PreItem.QueryPreItemByCode(ParameterList);
if (dt.Rows.Count > 0)
Name = "已存在";
else
Name = "查無資料";
}
return Name;
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
this.ErrorMsgLabel.Text = string.Empty;
if (txtRETURN_MEMO.Text.Trim() == "")
{
this.ErrorMsgLabel.Text = "請輸入退件原因";
return;
}
//N_ID in NUMBER,
//V_RETURN_MEMO in varchar,
//D_OLD_UPDATEDATE in date,
//V_OLD_UPDATEUID in varchar,
//D_NEW_UPDATEDATE in date,
//V_NEW_UPDATEUID in varchar
ParameterList.Clear();
ParameterList.Add(int.Parse(ViewState["ID"].ToString()));
ParameterList.Add(txtRETURN_MEMO.Text.Trim());
ParameterList.Add(DateTime.ParseExact(ViewState["UPDATEDATE"].ToString(), "yyyy/MM/dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture));
ParameterList.Add(ViewState["UPDATEUID"].ToString());
ParameterList.Add(DateTime.Now);
ParameterList.Add(Session["UID"].ToString());
BCO.MaintainPreItem bco = new BCO.MaintainPreItem(ConntionDB);
bco.UpdateReturn(ParameterList, null);
ScriptManager.RegisterStartupScript(this.up_Msg, typeof(UpdatePanel), "ITM182R", "alert('退件完成');window.returnValue='OK';window.close();", true);
}
catch (Exception ex)
{
this.ErrorMsgLabel.Text = ex.Message;
}
finally { }
}