}//ButtonQuery_Click
private void databind()
{
//抓取本頁初次登記的時間
string SessionIDName = "POP_CGDVENDOR_" + PageTimeStamp.Value;
CGDModel.CGD32_BCO BCO = new CGDModel.CGD32_BCO(ConntionDB);
ParameterList.Clear();
ParameterList.Add(DBNull.Value);
ParameterList.Add(DBPara("%" + txtVENDOR.Text.Trim() + "%", ParaType.Varchar2));
ParameterList.Add(DBPara("%" + txtVENDOR_NAME.Text.Trim() + "%", ParaType.Varchar2));
ParameterList.Add(DBPara(TextBoxRowCountLimit.Text.Trim(), ParaType.Number));
DataTable Dt = BCO.DoQuerySLP(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 GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
string SessionIDName = "POP_CGDVENDOR_" + PageTimeStamp.Value;
CGDModel.CGD32_BCO BCO = new CGDModel.CGD32_BCO(ConntionDB);
ParameterList.Clear();
ParameterList.Add(DBNull.Value);
ParameterList.Add(DBPara("%" + txtVENDOR.Text.Trim() + "%", ParaType.Varchar2));
ParameterList.Add(DBPara("%" + txtVENDOR_NAME.Text.Trim() + "%", ParaType.Varchar2));
ParameterList.Add(DBPara(TextBoxRowCountLimit.Text.Trim(), ParaType.Number));
DataTable dt = BCO.DoQuerySLP(ParameterList);
DataRow[] drs = dt.Select(string.Format("ID='{0}'", GridView1.DataKeys[e.NewSelectedIndex].Value));
if (drs.Length > 0)
{
DataRow dr = drs[0];
this.lblVENDOR.Text = dr["VENDOR"].ToString();
this.lblVENDOR_NAME.Text = dr["VENDOR_NAME"].ToString();
}
}//GridView1_SelectedIndexChanging
/// <summary>
/// 查詢資料庫取得資料
/// </summary>
private void databind()
{
//抓取本頁初次登記的時間
string SessionIDName = "CGD321_" + PageTimeStamp.Value;
CGDModel.CGD32_BCO BCO = new CGDModel.CGD32_BCO(ConntionDB);
string N_ID = string.Empty;
string V_VENDOR = SLP_CGDVENDOR1.Text.Trim();
string V_VENDOR_NAME = txtVENDOR_NAME.Text.Trim();
string V_BOSS = txtBOSS.Text.Trim();
string D_VENDOR_OPEN_DATE_S = SLP_VENDOR_OPEN_DATE.StartDate;
string D_VENDOR_OPEN_DATE_E = SLP_VENDOR_OPEN_DATE.EndDate;
string D_VENDOR_CLOSE_DATE_S = SLP_VENDOR_CLOSE_DATE.StartDate;
string D_VENDOR_CLOSE_DATE_E = SLP_VENDOR_CLOSE_DATE.EndDate;
string V_VENDOR_SERVICE_TEL_AREA = SLP_VENDOR_SERVICE_TEL.TextBox_Fax.Text.Trim();
string V_VENDOR_SERVICE_TEL = SLP_VENDOR_SERVICE_TEL.TextBox_Tel.Text.Trim();
string V_MAIL_ADDR = txtMAIL_ADDR.Text.Trim();
string V_STORE_FEE_PARAM1_OP = ConvertSign(SLP_PARA1.Operator);
string N_STORE_FEE_PARAM1 = SLP_PARA1.Text.Trim();
string V_STORE_FEE_PARAM2_OP = ConvertSign(SLP_PARA2.Operator);
string N_STORE_FEE_PARAM2 = SLP_PARA2.Text.Trim();
string N_SUBSIDY_FLAG = ddlSUBSIDY_FLAG.SelectedValue;
string N_FINE_FLAG = ddlFINE_FLAG.SelectedValue;
string V_INV_TEL_AREA = SLP_INV_TEL.TextBox_Fax.Text.Trim();
string V_INV_TEL = SLP_INV_TEL.TextBox_Tel.Text.Trim();
string V_INV_FAX_AREA = SLP_INV_FAX.TextBox_Fax.Text.Trim();
string V_INV_FAX = SLP_INV_FAX.TextBox_Tel.Text.Trim();
string V_INV_PDZ_NO = txtINV_PDZ_NO.Text.Trim();
string V_INV_ADDR = txtINV_ADDR.Text.Trim();
string V_BUSINESS_TEL_AREA = SLP_BUSINESS_TEL.TextBox_Fax.Text.Trim();
string V_BUSINESS_TEL = SLP_BUSINESS_TEL.TextBox_Tel.Text.Trim();
string V_BUSINESS_FAX_AREA = SLP_BUSINESS_FAX.TextBox_Fax.Text.Trim();
string V_BUSINESS_FAX = SLP_BUSINESS_FAX.TextBox_Tel.Text.Trim();
string V_BUSINESS_PDZ_NO = txtBUSINESS_PDZ_NO.Text.Trim();
string V_BUSINESS_ADDR = txtBUSINESS_ADDR.Text.Trim();
string V_MNOTES = txtMNOTES.Text.Trim();
string D_CREATEDATE_S = SLP_CREATEDATE.StartDate;
string D_CREATEDATE_E = SLP_CREATEDATE.EndDate;
string V_CREATEUID = SLP_CREATEUID.Text;
string D_UPDATEDATE_S = SLP_UPDATEDATE.StartDate;
string D_UPDATEDATE_E = SLP_UPDATEDATE.EndDate;
string V_UPDATEUID = SLP_UPDATEUID.Text;
string V_EMP_ID = txtEMP_ID.Text.Trim();
string V_EMP_NAME = txtEMP_NAME.Text.Trim();
string V_PNOTES = txtDNOTES.Text.Trim();
string V_KIND = string.Empty;
string N_ROWNUM = TextBoxRowCountLimit.Text.Trim();
for (int i = 0; i < cblKIND.Items.Count; i++)
{
if (cblKIND.Items[i].Selected == true)
{
if (V_KIND != "")
V_KIND += ",";
V_KIND += cblKIND.Items[i].Value;
}
}
ParaSQL PSQL = ParaSQL.Equal;
if (CheckBoxLikeSearch.Checked == true)
PSQL = ParaSQL.Like;
ParameterList.Clear();
ParameterList.Add(DBPara(N_ID, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(V_VENDOR, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(V_VENDOR_NAME, ParaType.Varchar2, PSQL));
ParameterList.Add(DBPara(V_BOSS, ParaType.Varchar2, PSQL));
ParameterList.Add(DBPara(D_VENDOR_OPEN_DATE_S, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(D_VENDOR_OPEN_DATE_E, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(D_VENDOR_CLOSE_DATE_S, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(D_VENDOR_CLOSE_DATE_E, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(V_VENDOR_SERVICE_TEL_AREA, ParaType.Varchar2, PSQL));
ParameterList.Add(DBPara(V_VENDOR_SERVICE_TEL, ParaType.Varchar2, PSQL));
ParameterList.Add(DBPara(V_MAIL_ADDR, ParaType.Varchar2, PSQL));
ParameterList.Add(DBPara(V_STORE_FEE_PARAM1_OP, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(N_STORE_FEE_PARAM1, ParaType.Number, ParaSQL.Equal));
ParameterList.Add(DBPara(V_STORE_FEE_PARAM2_OP, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(N_STORE_FEE_PARAM2, ParaType.Number, ParaSQL.Equal));
ParameterList.Add(DBPara(N_SUBSIDY_FLAG, ParaType.Number, ParaSQL.Equal));
ParameterList.Add(DBPara(N_FINE_FLAG, ParaType.Number, ParaSQL.Equal));
ParameterList.Add(DBPara(V_INV_TEL_AREA, ParaType.Varchar2, PSQL));
ParameterList.Add(DBPara(V_INV_TEL, ParaType.Varchar2, PSQL));
ParameterList.Add(DBPara(V_INV_FAX_AREA, ParaType.Varchar2, PSQL));
ParameterList.Add(DBPara(V_INV_FAX, ParaType.Varchar2, PSQL));
ParameterList.Add(DBPara(V_INV_PDZ_NO, ParaType.Varchar2, PSQL));
ParameterList.Add(DBPara(V_INV_ADDR, ParaType.Varchar2, PSQL));
ParameterList.Add(DBPara(V_BUSINESS_TEL_AREA, ParaType.Varchar2, PSQL));
ParameterList.Add(DBPara(V_BUSINESS_TEL, ParaType.Varchar2, PSQL));
ParameterList.Add(DBPara(V_BUSINESS_FAX_AREA, ParaType.Varchar2, PSQL));
ParameterList.Add(DBPara(V_BUSINESS_FAX, ParaType.Varchar2, PSQL));
ParameterList.Add(DBPara(V_BUSINESS_PDZ_NO, ParaType.Varchar2, PSQL));
ParameterList.Add(DBPara(V_BUSINESS_ADDR, ParaType.Varchar2, PSQL));
ParameterList.Add(DBPara(V_MNOTES, ParaType.Varchar2, PSQL));
ParameterList.Add(DBPara(D_CREATEDATE_S, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(D_CREATEDATE_E, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(V_CREATEUID, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(D_UPDATEDATE_S, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(D_UPDATEDATE_E, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(V_UPDATEUID, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(V_EMP_ID, ParaType.Varchar2, PSQL));
ParameterList.Add(DBPara(V_EMP_NAME, ParaType.Varchar2, PSQL));
ParameterList.Add(DBPara(V_PNOTES, ParaType.Varchar2, PSQL));
ParameterList.Add(DBPara(V_KIND, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(N_ROWNUM, ParaType.Number, ParaSQL.Equal));
DataTable Dt = BCO.DoQueryMain(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();
#region 將Key值存到Session中
ArrayList arl_Key = new ArrayList();
foreach (DataRow drRow in Dt.Rows)
{ arl_Key.Add(drRow["ID"].ToString()); }
Session["CGD32_SortKey" + this.PageTimeStamp.Value] = arl_Key;
#endregion
#region 檢查回傳資料
if (Dt.Rows.Count == 0)
{ this.ErrorMsgLabel.Text = "查無資料"; }
#endregion
}
/// <summary>
/// Page_Load事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
try
{
ErrorMsgLabel.Text = "";
AuthorityControls(this);
//SetAuthCRUD();
if (!IsPostBack)
{
//寫入首次載入Page TimeStamp
PageTimeStamp.Value = string.Format("{0}{1}{2}{3}{4}{5}",
DateTime.Now.Year.ToString(),
DateTime.Now.Month.ToString().PadLeft(2, '0'),
DateTime.Now.Day.ToString().PadLeft(2, '0'),
DateTime.Now.Hour.ToString().PadLeft(2, '0'),
DateTime.Now.Minute.ToString().PadLeft(2, '0'),
DateTime.Now.Second.ToString().PadLeft(2, '0')
);
//設定GridView預設的狀態
Initialization_Component();
//設定ToolBar預設狀態
ToolBarInit();
ddlSUBSIDY_FLAG.Items.Clear();
ddlSUBSIDY_FLAG.Items.Add(new ListItem("ALL", ""));
ddlSUBSIDY_FLAG.Items.Add(new ListItem("Y", "1"));
ddlSUBSIDY_FLAG.Items.Add(new ListItem("N", "0"));
ddlSUBSIDY_FLAG.SelectedIndex = 0;
ddlFINE_FLAG.Items.Clear();
ddlFINE_FLAG.Items.Add(new ListItem("ALL", ""));
ddlFINE_FLAG.Items.Add(new ListItem("Y", "1"));
ddlFINE_FLAG.Items.Add(new ListItem("N", "0"));
ddlFINE_FLAG.SelectedIndex = 0;
CGDModel.CGD32_BCO BCO = new CGDModel.CGD32_BCO(ConntionDB);
DataTable dtKind = BCO.DoQueryKind();
for (int i = 0; i < dtKind.Rows.Count; i++)
{
cblKIND.Items.Add(new ListItem(dtKind.Rows[i]["KIND_DESC"].ToString(), dtKind.Rows[i]["OUTSOURCE_ID"].ToString()));
}
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
finally { }
}//page_load
}//databind
private void bindEMP(string strPID)
{
string SessionIDName = "CGD322_EMP_" + PageTimeStamp.Value;
bool bResult = false; //false:無資料 true:有資料
CGDModel.CGD32_BCO BCO = new CGDModel.CGD32_BCO(ConnectionDB);
ParameterList.Clear();
ParameterList.Add(strPID);
DataTable dtEMP = BCO.DoQueryEMP_PID(ParameterList);
Session[SessionIDName] = dtEMP;
if (dtEMP.Rows.Count == 0)
{
AddEmp();
}
else
{
for (int i = 0; i < dtEMP.Rows.Count; i++)
{
dtEMP.Rows[i]["ID"] = i;
}
BindGV1();
}
}
protected void Btn_Save_Click(object sender, EventArgs e)
{
try
{
if (this.hid_PageStatus.Value == "INSERT")
{
WriteToCache();
string SessionIDName = "CGD322_EMP_" + PageTimeStamp.Value;
DataTable dtEMP = (DataTable)Session[SessionIDName];
if (SaveCheck() == false)
{
return;
}
CGDModel.CGD32_BCO BCO = new CGDModel.CGD32_BCO(ConnectionDB);
string V_VENDOR = txtVENDOR.Text.Trim();
string V_VENDOR_NAME = txtVENDOR_NAME.Text.Trim();
string V_BOSS = txtBOSS.Text.Trim();
string D_VENDOR_OPEN_DATE = SLP_VENDOR_OPEN_DATE.Text.Trim();
string D_VENDOR_CLOSE_DATE = SLP_VENDOR_CLOSE_DATE.Text.Trim();
string V_VENDOR_SERVICE_TEL_AREA = SLP_VENDOR_SERVICE_TEL.TextBox_Fax.Text.Trim();
string V_VENDOR_SERVICE_TEL = SLP_VENDOR_SERVICE_TEL.TextBox_Tel.Text.Trim();
string V_MAIL_ADDR = txtMAIL_ADDR.Text.Trim();
string N_STORE_FEE_PARAM1 = SLP_PARA1.Text.Trim();
string N_STORE_FEE_PARAM2 = SLP_PARA2.Text.Trim();
string N_SUBSIDY_FLAG = "0";
if (ddlSUBSIDY_FLAG.Text == "Y")
N_SUBSIDY_FLAG = "1";
string N_FINE_FLAG = "0";
if (ddlFINE_FLAG.Text == "Y")
N_FINE_FLAG = "1";
string V_INV_TEL_AREA = SLP_INV_TEL.TextBox_Fax.Text.Trim();
string V_INV_TEL = SLP_INV_TEL.TextBox_Tel.Text.Trim();
string V_INV_FAX_AREA = SLP_INV_FAX.TextBox_Fax.Text.Trim();
string V_INV_FAX = SLP_INV_FAX.TextBox_Tel.Text.Trim();
string V_INV_PDZ_NO = txtINV_PDZ_NO.Text.Trim();
string V_INV_ADDR = txtINV_ADDR.Text.Trim();
string V_BUSINESS_TEL_AREA = SLP_BUSINESS_TEL.TextBox_Fax.Text.Trim();
string V_BUSINESS_TEL = SLP_BUSINESS_TEL.TextBox_Tel.Text.Trim();
string V_BUSINESS_FAX_AREA = SLP_BUSINESS_FAX.TextBox_Fax.Text.Trim();
string V_BUSINESS_FAX = SLP_BUSINESS_FAX.TextBox_Tel.Text.Trim();
string V_BUSINESS_PDZ_NO = txtBUSINESS_PDZ_NO.Text.Trim();
string V_BUSINESS_ADDR = txtBUSINESS_ADDR.Text.Trim();
string V_NOTES = txtMNOTES.Text.Trim();
string D_CREATEDATE = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
string V_CREATEUID = Session["UID"].ToString();
string D_UPDATEDATE = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
string V_UPDATEUID = Session["UID"].ToString();
string strID = string.Empty;
if (CheckPK("", V_VENDOR) == true)
return;
ParameterList.Clear();
ParameterList.Add(DBPara(V_VENDOR, ParaType.Varchar2));
ParameterList.Add(DBPara(V_VENDOR_NAME, ParaType.Varchar2));
ParameterList.Add(DBPara(V_BOSS, ParaType.Varchar2));
ParameterList.Add(DBPara(D_VENDOR_OPEN_DATE, ParaType.Date));
ParameterList.Add(DBPara(D_VENDOR_CLOSE_DATE, ParaType.Date));
ParameterList.Add(DBPara(V_VENDOR_SERVICE_TEL_AREA, ParaType.Varchar2));
ParameterList.Add(DBPara(V_VENDOR_SERVICE_TEL, ParaType.Varchar2));
ParameterList.Add(DBPara(V_MAIL_ADDR, ParaType.Varchar2));
ParameterList.Add(DBPara(N_STORE_FEE_PARAM1, ParaType.Number));
ParameterList.Add(DBPara(N_STORE_FEE_PARAM2, ParaType.Number));
ParameterList.Add(DBPara(N_SUBSIDY_FLAG, ParaType.Number));
ParameterList.Add(DBPara(N_FINE_FLAG, ParaType.Number));
ParameterList.Add(DBPara(V_INV_TEL_AREA, ParaType.Varchar2));
ParameterList.Add(DBPara(V_INV_TEL, ParaType.Varchar2));
ParameterList.Add(DBPara(V_INV_FAX_AREA, ParaType.Varchar2));
ParameterList.Add(DBPara(V_INV_FAX, ParaType.Varchar2));
ParameterList.Add(DBPara(V_INV_PDZ_NO, ParaType.Varchar2));
ParameterList.Add(DBPara(V_INV_ADDR, ParaType.Varchar2));
ParameterList.Add(DBPara(V_BUSINESS_TEL_AREA, ParaType.Varchar2));
ParameterList.Add(DBPara(V_BUSINESS_TEL, ParaType.Varchar2));
ParameterList.Add(DBPara(V_BUSINESS_FAX_AREA, ParaType.Varchar2));
ParameterList.Add(DBPara(V_BUSINESS_FAX, ParaType.Varchar2));
ParameterList.Add(DBPara(V_BUSINESS_PDZ_NO, ParaType.Varchar2));
ParameterList.Add(DBPara(V_BUSINESS_ADDR, ParaType.Varchar2));
ParameterList.Add(DBPara(V_NOTES, ParaType.Varchar2));
ParameterList.Add(DBPara(D_CREATEDATE, ParaType.Date));
ParameterList.Add(DBPara(V_CREATEUID, ParaType.Varchar2));
ParameterList.Add(DBPara(D_UPDATEDATE, ParaType.Date));
ParameterList.Add(DBPara(V_UPDATEUID, ParaType.Varchar2));
ArrayList ParaKind = new ArrayList();
ParaKind.Clear();
if (cblKIND1.Items[0].Selected == true)
ParaKind.Add(cblKIND1.Items[0].Value);
for (int i = 0; i < cblKIND2.Items.Count; i++)
{
if (cblKIND2.Items[i].Selected == true)
ParaKind.Add(cblKIND2.Items[i].Value);
}
ArrayList ParaXYZ = new ArrayList();
ParaXYZ.Clear();
ParaXYZ.Add(BoolToInt(cblXYZ.Items[0].Selected));
ParaXYZ.Add(BoolToInt(cblXYZ.Items[1].Selected));
ParaXYZ.Add(BoolToInt(cblXYZ.Items[2].Selected));
BCO.InsertOne(ParameterList, DT_Filter(dtEMP, "ENABLE=1 AND EMP_ID<>'' AND EMP_NAME<>''"), ParaKind, ParaXYZ, out strID);
ArrayList arl_Key = new ArrayList();
arl_Key.Add(strID);
Session["CGD32_SortKey" + this.PageTimeStamp.Value] = arl_Key;
////用本頁新增的 PageTimeStamp
Response.Redirect("CGD322.aspx?code=CGD32&MSG=NEW&mode=VIEW&ID=" + strID + "&CGD322_PageTimeStamp=" + this.PageTimeStamp.Value, false);
}
else if (this.hid_PageStatus.Value == "EDIT")
{
WriteToCache();
string SessionIDName = "CGD322_EMP_" + PageTimeStamp.Value;
DataTable dtEMP = (DataTable)Session[SessionIDName];
if (SaveCheck() == false)
{
return;
}
if (SaveCheckUse() == false)
{
return;
}
CGDModel.CGD32_BCO BCO = new CGDModel.CGD32_BCO(ConnectionDB);
string N_ID = hiddenID.Value;
string V_VENDOR = txtVENDOR.Text.Trim();
string V_VENDOR_NAME = txtVENDOR_NAME.Text.Trim();
string V_BOSS = txtBOSS.Text.Trim();
string D_VENDOR_OPEN_DATE = SLP_VENDOR_OPEN_DATE.Text.Trim();
string D_VENDOR_CLOSE_DATE = SLP_VENDOR_CLOSE_DATE.Text.Trim();
string V_VENDOR_SERVICE_TEL_AREA = SLP_VENDOR_SERVICE_TEL.TextBox_Fax.Text.Trim();
string V_VENDOR_SERVICE_TEL = SLP_VENDOR_SERVICE_TEL.TextBox_Tel.Text.Trim();
string V_MAIL_ADDR = txtMAIL_ADDR.Text.Trim();
string N_STORE_FEE_PARAM1 = SLP_PARA1.Text.Trim();
string N_STORE_FEE_PARAM2 = SLP_PARA2.Text.Trim();
string N_SUBSIDY_FLAG = "0";
if (ddlSUBSIDY_FLAG.Text == "Y")
N_SUBSIDY_FLAG = "1";
string N_FINE_FLAG = "0";
if (ddlFINE_FLAG.Text == "Y")
N_FINE_FLAG = "1";
string V_INV_TEL_AREA = SLP_INV_TEL.TextBox_Fax.Text.Trim();
string V_INV_TEL = SLP_INV_TEL.TextBox_Tel.Text.Trim();
string V_INV_FAX_AREA = SLP_INV_FAX.TextBox_Fax.Text.Trim();
string V_INV_FAX = SLP_INV_FAX.TextBox_Tel.Text.Trim();
string V_INV_PDZ_NO = txtINV_PDZ_NO.Text.Trim();
string V_INV_ADDR = txtINV_ADDR.Text.Trim();
string V_BUSINESS_TEL_AREA = SLP_BUSINESS_TEL.TextBox_Fax.Text.Trim();
string V_BUSINESS_TEL = SLP_BUSINESS_TEL.TextBox_Tel.Text.Trim();
string V_BUSINESS_FAX_AREA = SLP_BUSINESS_FAX.TextBox_Fax.Text.Trim();
string V_BUSINESS_FAX = SLP_BUSINESS_FAX.TextBox_Tel.Text.Trim();
string V_BUSINESS_PDZ_NO = txtBUSINESS_PDZ_NO.Text.Trim();
string V_BUSINESS_ADDR = txtBUSINESS_ADDR.Text.Trim();
string V_NOTES = txtMNOTES.Text.Trim();
string D_UPDATEDATE = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
string V_UPDATEUID = Session["UID"].ToString();
string D_OLD_UPDATEDATE = txtUpdateDate.Text;
string V_OLD_UPDATEUID = SLP_UPDATEUID.Text;
if (CheckPK(N_ID, V_VENDOR) == true)
return;
ParameterList.Clear();
ParameterList.Add(DBPara(N_ID, ParaType.Number));
ParameterList.Add(DBPara(V_VENDOR, ParaType.Varchar2));
ParameterList.Add(DBPara(V_VENDOR_NAME, ParaType.Varchar2));
ParameterList.Add(DBPara(V_BOSS, ParaType.Varchar2));
ParameterList.Add(DBPara(D_VENDOR_OPEN_DATE, ParaType.Date));
ParameterList.Add(DBPara(D_VENDOR_CLOSE_DATE, ParaType.Date));
ParameterList.Add(DBPara(V_VENDOR_SERVICE_TEL_AREA, ParaType.Varchar2));
ParameterList.Add(DBPara(V_VENDOR_SERVICE_TEL, ParaType.Varchar2));
ParameterList.Add(DBPara(V_MAIL_ADDR, ParaType.Varchar2));
ParameterList.Add(DBPara(N_STORE_FEE_PARAM1, ParaType.Number));
ParameterList.Add(DBPara(N_STORE_FEE_PARAM2, ParaType.Number));
ParameterList.Add(DBPara(N_SUBSIDY_FLAG, ParaType.Number));
ParameterList.Add(DBPara(N_FINE_FLAG, ParaType.Number));
ParameterList.Add(DBPara(V_INV_TEL_AREA, ParaType.Varchar2));
ParameterList.Add(DBPara(V_INV_TEL, ParaType.Varchar2));
ParameterList.Add(DBPara(V_INV_FAX_AREA, ParaType.Varchar2));
ParameterList.Add(DBPara(V_INV_FAX, ParaType.Varchar2));
ParameterList.Add(DBPara(V_INV_PDZ_NO, ParaType.Varchar2));
ParameterList.Add(DBPara(V_INV_ADDR, ParaType.Varchar2));
ParameterList.Add(DBPara(V_BUSINESS_TEL_AREA, ParaType.Varchar2));
ParameterList.Add(DBPara(V_BUSINESS_TEL, ParaType.Varchar2));
ParameterList.Add(DBPara(V_BUSINESS_FAX_AREA, ParaType.Varchar2));
ParameterList.Add(DBPara(V_BUSINESS_FAX, ParaType.Varchar2));
ParameterList.Add(DBPara(V_BUSINESS_PDZ_NO, ParaType.Varchar2));
ParameterList.Add(DBPara(V_BUSINESS_ADDR, ParaType.Varchar2));
ParameterList.Add(DBPara(V_NOTES, ParaType.Varchar2));
ParameterList.Add(DBPara(D_UPDATEDATE, ParaType.Date));
ParameterList.Add(DBPara(V_UPDATEUID, ParaType.Varchar2));
ParameterList.Add(DBPara(D_OLD_UPDATEDATE, ParaType.Date));
ParameterList.Add(DBPara(V_OLD_UPDATEUID, ParaType.Varchar2));
ArrayList ParaKind = new ArrayList();
ParaKind.Clear();
if (cblKIND1.Items[0].Selected == true)
ParaKind.Add(cblKIND1.Items[0].Value);
for (int i = 0; i < cblKIND2.Items.Count; i++)
{
if (cblKIND2.Items[i].Selected == true)
ParaKind.Add(cblKIND2.Items[i].Value);
}
ArrayList ParaXYZ = new ArrayList();
ParaXYZ.Clear();
ParaXYZ.Add(BoolToInt(cblXYZ.Items[0].Selected));
ParaXYZ.Add(BoolToInt(cblXYZ.Items[1].Selected));
ParaXYZ.Add(BoolToInt(cblXYZ.Items[2].Selected));
BCO.UpdateOne(ParameterList, DT_Filter(dtEMP, "ENABLE=1 AND EMP_ID<>'' AND EMP_NAME<>''"), ParaKind, ParaXYZ);
//用查詢頁進來的 PageTimeStamp
Response.Redirect("CGD322.aspx?code=CGD32&MSG=EDIT&mode=VIEW&ID=" + N_ID + "&CGD322_PageTimeStamp=" + Request.QueryString["CGD322_PageTimeStamp"] + "&refreshid=" + Guid.NewGuid(), false);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
}
/// <summary>
/// 繫結資料到畫面控制項
/// </summary>
private bool databind(string strID)
{
bool bResult = false; //false:無資料 true:有資料
CGDModel.CGD32_BCO BCO = new CGDModel.CGD32_BCO(ConnectionDB);
ParameterList.Clear();
ParameterList.Add(strID);
for (int i = 1; i <= 40; i++)
ParameterList.Add(DBNull.Value);
DataTable dtData = BCO.DoQueryMain(ParameterList);
if (dtData.Rows.Count == 0)
{
hiddenID.Value = strID;
txtVENDOR.Text = "";
hdfVENDOR.Value = "";
txtVENDOR_NAME.Text = "";
txtBOSS.Text = "";
SLP_VENDOR_OPEN_DATE.Text = "";
SLP_VENDOR_CLOSE_DATE.Text = "";
SLP_VENDOR_SERVICE_TEL.Text = "";
SLP_VENDOR_SERVICE_TEL.Text = "";
txtMAIL_ADDR.Text = "";
SLP_PARA1.Text = "";
SLP_PARA2.Text = "";
ddlSUBSIDY_FLAG.SelectedIndex = 0;
ddlFINE_FLAG.SelectedIndex = 0;
SLP_INV_TEL.Text = "";
SLP_INV_FAX.Text = "";
txtINV_PDZ_NO.Text = "";
txtINV_ADDR.Text = "";
SLP_BUSINESS_TEL.Text = "";
SLP_BUSINESS_FAX.Text = "";
txtBUSINESS_PDZ_NO.Text = "";
txtBUSINESS_ADDR.Text = "";
txtMNOTES.Text = "";
txtCreateDate.Text = "";
SLP_CREATEUID.Text = "";
txtUpdateDate.Text = "";
SLP_UPDATEUID.Text = "";
cblXYZ.Items[0].Selected = false;
cblXYZ.Items[1].Selected = false;
cblXYZ.Items[2].Selected = false;
bindEMP("-1");
bResult = false;
ErrorMsgLabel.Text = "此筆資料已被其他使用者刪除,請點選上一筆/下一筆鈕或回查詢頁重新查詢!";
}
else
{
hiddenID.Value = strID;
txtVENDOR.Text = dtData.Rows[0]["VENDOR"].ToString();
hdfVENDOR.Value = dtData.Rows[0]["VENDOR"].ToString();
txtVENDOR_NAME.Text = dtData.Rows[0]["VENDOR_NAME"].ToString();
txtBOSS.Text = dtData.Rows[0]["BOSS"].ToString();
SLP_VENDOR_OPEN_DATE.Text = dtData.Rows[0]["VENDOR_OPEN_DATE"].ToString();
SLP_VENDOR_CLOSE_DATE.Text = dtData.Rows[0]["VENDOR_CLOSE_DATE"].ToString();
SLP_VENDOR_SERVICE_TEL.TextBox_Fax.Text = dtData.Rows[0]["VENDOR_SERVICE_TEL_AREA"].ToString();
SLP_VENDOR_SERVICE_TEL.TextBox_Tel.Text = dtData.Rows[0]["VENDOR_SERVICE_TEL"].ToString();
txtMAIL_ADDR.Text = dtData.Rows[0]["MAIL_ADDR"].ToString();
SLP_PARA1.Text = dtData.Rows[0]["STORE_FEE_PARAM1"].ToString();
SLP_PARA2.Text = dtData.Rows[0]["STORE_FEE_PARAM2"].ToString();
ddlSUBSIDY_FLAG.Text = dtData.Rows[0]["SUBSIDY_FLAG"].ToString();
ddlFINE_FLAG.Text = dtData.Rows[0]["FINE_FLAG"].ToString();
SLP_INV_TEL.TextBox_Fax.Text = dtData.Rows[0]["INV_TEL_AREA"].ToString();
SLP_INV_TEL.TextBox_Tel.Text = dtData.Rows[0]["INV_TEL"].ToString();
SLP_INV_FAX.TextBox_Fax.Text = dtData.Rows[0]["INV_FAX_AREA"].ToString();
SLP_INV_FAX.TextBox_Tel.Text = dtData.Rows[0]["INV_FAX"].ToString();
txtINV_PDZ_NO.Text = dtData.Rows[0]["INV_PDZ_NO"].ToString();
txtINV_ADDR.Text = dtData.Rows[0]["INV_ADDR"].ToString();
SLP_BUSINESS_TEL.TextBox_Fax.Text = dtData.Rows[0]["BUSINESS_TEL_AREA"].ToString();
SLP_BUSINESS_TEL.TextBox_Tel.Text = dtData.Rows[0]["BUSINESS_TEL"].ToString();
SLP_BUSINESS_FAX.TextBox_Fax.Text = dtData.Rows[0]["BUSINESS_FAX_AREA"].ToString();
SLP_BUSINESS_FAX.TextBox_Tel.Text = dtData.Rows[0]["BUSINESS_FAX"].ToString();
txtBUSINESS_PDZ_NO.Text = dtData.Rows[0]["BUSINESS_PDZ_NO"].ToString();
txtBUSINESS_ADDR.Text = dtData.Rows[0]["BUSINESS_ADDR"].ToString();
txtMNOTES.Text = dtData.Rows[0]["NOTES"].ToString();
txtCreateDate.Text = dtData.Rows[0]["CREATEDATE"].ToString();
SLP_CREATEUID.Text = dtData.Rows[0]["CREATEUID"].ToString();
txtUpdateDate.Text = dtData.Rows[0]["UPDATEDATE"].ToString();
SLP_UPDATEUID.Text = dtData.Rows[0]["UPDATEUID"].ToString();
cblXYZ.Items[0].Selected = StrToBool(dtData.Rows[0]["X_LINE"].ToString());
cblXYZ.Items[1].Selected = StrToBool(dtData.Rows[0]["Y_LINE"].ToString());
cblXYZ.Items[2].Selected = StrToBool(dtData.Rows[0]["Z_LINE"].ToString());
ParameterList.Clear();
ParameterList.Add(strID);
DataTable dtKind = BCO.DoQueryKind_PID(ParameterList);
for (int x = 0; x < dtKind.Rows.Count; x++)
{
if (dtKind.Rows[x]["OUTSOURCE_ID"].ToString() == "1")
{
cblKIND1.Items[0].Selected = true;
}
else
{
for (int i = 0; i < cblKIND2.Items.Count; i++)
{
if (cblKIND2.Items[i].Value == dtKind.Rows[x]["OUTSOURCE_ID"].ToString())
cblKIND2.Items[i].Selected = true;
}
}
}
bindEMP(strID);
bResult = true;
}
Session["CGD322_DT" + PageTimeStamp.Value] = dtData;
return bResult;
}//databind
private bool CheckPK(string strID, string strVENDOR)
{
CGDModel.CGD32_BCO BCO = new CGDModel.CGD32_BCO(ConnectionDB);
ParameterList.Clear();
ParameterList.Add(DBNull.Value);
ParameterList.Add(strVENDOR);
for (int i = 1; i <= 39; i++)
ParameterList.Add(DBNull.Value);
DataTable dtData = BCO.DoQueryMain(ParameterList);
bool bResult = false; //true:有重覆PK false:無重覆PK
foreach (DataRow dr in dtData.Rows)
{
if (dr["ID"].ToString() != strID)
{
bResult = true;
break;
}
}
if (bResult == true)
{
ErrorMsgLabel.Text = "已有相同的委外商代號存在";
}
return bResult; //無重覆PK
}
private bool CheckUseEmp(string strVENDOR, string strEMP_ID)
{
CGDModel.CGD32_BCO BCO = new CGDModel.CGD32_BCO(ConnectionDB);
ArrayList arrPara = new ArrayList();
arrPara.Add(strVENDOR);
arrPara.Add(strEMP_ID);
DataTable dtUseEmp = BCO.DoQueryUseEmp(arrPara);
if (dtUseEmp.Rows.Count > 0)
{
return true; //有使用
}
else
{
return false; //無使用
}
}
protected void Btn_Delete_Click(object sender, EventArgs e)
{
if (this.hid_PageStatus.Value == "VIEW")
{
ErrorMsgLabel.Text = "";
CGDModel.CGD32_BCO BCO = new CGDModel.CGD32_BCO(ConnectionDB);
string N_ID = this.hiddenID.Value;
string D_OLD_UPDATEDATE = txtUpdateDate.Text;
string V_OLD_UPDATEUID = SLP_UPDATEUID.Text;
string D_NEW_UPDATEDATE = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
string V_NEW_UPDATEUID = Session["UID"].ToString();
if (CheckUseEmp(hdfVENDOR.Value.Trim(), "") == true)
{
ErrorMsgLabel.Text = "廠商資料使用中，無法刪除";
return;
}
ParameterList.Clear();
ParameterList.Add(DBPara(N_ID, ParaType.Number));
ParameterList.Add(DBPara(D_OLD_UPDATEDATE, ParaType.Date));
ParameterList.Add(DBPara(V_OLD_UPDATEUID, ParaType.Varchar2));
ParameterList.Add(DBPara(D_NEW_UPDATEDATE, ParaType.Date));
ParameterList.Add(DBPara(V_NEW_UPDATEUID, ParaType.Varchar2));
BCO.DeleteOne(ParameterList);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "MSG", "alert('刪除完成');location.href='CGD321.aspx?code=CGD32';", true);
}
}
/// <summary>
/// Page_Load事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
try
{
ErrorMsgLabel.Text = "";
AuthorityControls(this);
SetAuthCRUD();
SetAuthority();//判斷功能權限
if (!IsPostBack)
{
//寫入首次載入Page TimeStamp
PageTimeStamp.Value = string.Format("{0}{1}{2}{3}{4}{5}",
DateTime.Now.Year.ToString(),
DateTime.Now.Month.ToString().PadLeft(2, '0'),
DateTime.Now.Day.ToString().PadLeft(2, '0'),
DateTime.Now.Hour.ToString().PadLeft(2, '0'),
DateTime.Now.Minute.ToString().PadLeft(2, '0'),
DateTime.Now.Second.ToString().PadLeft(2, '0')
);
#region 設定 Page_Status 狀態
ddlSUBSIDY_FLAG.Items.Clear();
ddlSUBSIDY_FLAG.Items.Add("Y");
ddlSUBSIDY_FLAG.Items.Add("N");
ddlSUBSIDY_FLAG.SelectedIndex = 0;
ddlFINE_FLAG.Items.Clear();
ddlFINE_FLAG.Items.Add("Y");
ddlFINE_FLAG.Items.Add("N");
ddlFINE_FLAG.SelectedIndex = 0;
CGDModel.CGD32_BCO BCO = new CGDModel.CGD32_BCO(ConnectionDB);
DataTable dtKind = BCO.DoQueryKind();
for (int i = 0; i < dtKind.Rows.Count; i++)
{
if (dtKind.Rows[i]["OUTSOURCE_ID"].ToString() == "1")
cblKIND1.Items.Add(new ListItem(dtKind.Rows[i]["KIND_DESC"].ToString(), dtKind.Rows[i]["OUTSOURCE_ID"].ToString()));
else
cblKIND2.Items.Add(new ListItem(dtKind.Rows[i]["KIND_DESC"].ToString(), dtKind.Rows[i]["OUTSOURCE_ID"].ToString()));
}
//模式指定
string mode = "VIEW";
try { mode = Request["mode"].ToString(); }
catch { }
this.hid_PageStatus.Value = mode;
if (mode != "INSERT")
{
this.hiddenID.Value = Request.QueryString["ID"].ToString();
}
if (Request["MSG"] != null)
{
if (Request["MSG"] == "NEW")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "MSG", "window.setTimeout(function(){alert('新增完成');}, 1000);", true);
}
else if (Request["MSG"] == "EDIT")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "MSG", "window.setTimeout(function(){alert('儲存完成');}, 1000);", true);
}
}
#endregion
SetPageStatus();//設定各種模式的值
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
finally { }
}
