private void get退貨記錄()
{
string l_str業代員編 = iv_txt業代員編.Text.Trim().ToUpper();
string l_str請購單號 = iv_txt請購單號.Text.Trim().ToUpper();
string l_str起始日期 = _txtBDate.Text.Trim();
string l_str結束日期 = _txtEDate.Text.Trim();
CUser l_user = Session[SealedGlobalPage.SESSIONKEY_LOGIN_USER_DATA] as CUser;
if (l_user == null)
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, typeof(UpdatePanel), "OK", "alert('閒置過久，請重新登入')", true);
return;
}
string l_str助理員編 = l_user.f_userid帳號;//"F9446";//
CKGPartOrderDetailOutFactory l_factory = _context.CFactoryManager.
CKGPartOrderDetailOutFactory;
CKGPartOrderDetailOut[] l_codes = l_factory.getAll退貨資料By條件(l_str助理員編, l_str請購單號, "", l_str業代員編, "False", l_str起始日期, l_str結束日期);
if (l_codes == null)
{
iv_pnl查詢結果.Visible = false;
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, typeof(UpdatePanel), "OK", "alert('無退貨記錄')", true);
}
else
{
iv_pnl查詢結果.Visible = true;
display退貨記錄(l_codes);
}
}
private void insertTo退貨記錄(string p_str請購單號, string p_str產品編號, int p_int退貨數量)
{
CKGPartOrderFactory l_factory請購主檔 = _context.CFactoryManager.CKGPartOrderFactory;
CKGPartOrder l_code請購主檔 = l_factory請購主檔.getKGPartOrderBy請購單號(p_str請購單號);
CKGPartOrderDetailFactory l_factory請購明細 = _context.CFactoryManager.CKGPartOrderDetailFactory;
CKGPartOrderDetail l_code請購明細 = l_factory請購明細.get請購單內的單一產品明細(p_str請購單號, p_str產品編號);
CKGPartOrderDetailOutFactory l_factroy退貨記錄 = _context.CFactoryManager.CKGPartOrderDetailOutFactory;
CKGPartOrderDetailOut l_code退貨記錄 = l_factroy退貨記錄.createCKGPartOrderDetailOut();
CUser l_user = Session[SealedGlobalPage.SESSIONKEY_LOGIN_USER_DATA] as CUser;
l_code退貨記錄.f_ExchangeID請購單號 = p_str請購單號;
l_code退貨記錄.f_SalesSmid業代員編 = l_code請購主檔.f_SalesSmid業代員編;
l_code退貨記錄.f_SalesBranch業代單位 = l_user.f_branchid所別;
l_code退貨記錄.f_AssistantSmid退貨助理員編 = l_user.f_userid帳號; //"F9446";//
l_code退貨記錄.f_ProductID產品編號 = l_code請購明細.f_ProductID產品編號;
l_code退貨記錄.f_ProductName產品名稱 = l_code請購明細.f_ProductName產品名稱;
l_code退貨記錄.f_OutAmount退貨數量 = p_int退貨數量;
l_code退貨記錄.f_OutDate退貨日期 = DateTime.Today.ToString("yyyy/MM/dd");
l_code退貨記錄.f_Qty產品單位 = l_code請購明細.f_Qty產品單位;
l_code退貨記錄.f_Cost產品成本 = l_code請購明細.f_Cost產品成本價;
l_code退貨記錄.f_UnitPrice產品單價 = l_code請購明細.f_UnitPrice產品單價;
l_code退貨記錄.f_ListPrice建議售價 = l_code請購明細.f_ListPrice建議售價;
l_code退貨記錄.f_OutTotal總計退貨價格 = l_code請購明細.f_UnitPrice產品單價 * p_int退貨數量;
l_code退貨記錄.f_OutReasons退貨原因 = iv_txt退貨原因.Text.Replace("'", "");
l_code退貨記錄.f_Check管理者確認退貨 = "False";
l_code退貨記錄.f_EditDate編輯日期 = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
l_factroy退貨記錄.insertCKGPartOrderDetailOut(l_code退貨記錄);
}
private string get退貨單Html(string p_strEID)
{
CUser l_user = Session[SealedGlobalPage.SESSIONKEY_LOGIN_USER_DATA] as CUser;
string l_str助理員編 = l_user.f_userid帳號;// "F9446";//
CKGPartOrderDetailOutFactory l_factory退貨 = _context.CFactoryManager.
CKGPartOrderDetailOutFactory;
CKGPartOrderDetailOut[] l_codes退貨 = l_factory退貨.
get退貨資料By請購單號(p_strEID, l_str助理員編);
if (l_codes退貨 == null)
{
return("<font size=\"5\"><b>查無資料!!</b>");
}
CKGPartOrder l_code主檔 = _context.CFactoryManager.CKGPartOrderFactory.createCKGPartOrder();
l_code主檔.f_ExchangeID請購單號 = l_codes退貨[0].f_ExchangeID請購單號;
l_code主檔.f_SalesSmid業代員編 = l_codes退貨[0].f_SalesSmid業代員編;
l_code主檔.f_SalesName業代姓名 = l_codes退貨[0].f_SalesName業代姓名;
l_code主檔.f_SalesBranch業代單位 = l_codes退貨[0].f_SalesBranch業代單位;
l_code主檔.f_InsertDate請購日期 = l_codes退貨[0].f_OutDate退貨日期;
l_code主檔.f_Memo備註說明 = l_codes退貨[0].f_OutReasons退貨原因;
l_code主檔.明細 = new CKGPartOrderDetail[l_codes退貨.Length];
int l_int總計價格 = 0;
for (int i = 0; i < l_codes退貨.Length; i++)
{
l_code主檔.明細[i] = _context.CFactoryManager.CKGPartOrderDetailFactory.createCKGPartOrderDetail();
l_code主檔.明細[i].f_ProductID產品編號 = l_codes退貨[i].f_ProductID產品編號;
l_code主檔.明細[i].f_ProductName產品名稱 = l_codes退貨[i].f_ProductName產品名稱;
l_code主檔.明細[i].f_UnitPrice產品單價 = l_codes退貨[i].f_UnitPrice產品單價;
l_code主檔.明細[i].f_Amount選購數量 = l_codes退貨[i].f_OutAmount退貨數量;
l_code主檔.明細[i].f_Total總計價格 = l_codes退貨[i].f_OutTotal總計退貨價格;
l_int總計價格 += l_codes退貨[i].f_OutTotal總計退貨價格;
}
l_code主檔.f_TotalPrice總計價格 = l_int總計價格;
int l_intcount = (l_code主檔.明細.Length / 10); //一頁10筆，總列印頁整數數
if (l_code主檔.明細.Length % 10 != 0) //最後一頁未滿10筆的，要再加1頁
{
l_intcount++;
}
return(組HTML(l_code主檔, l_intcount));
}
private void 確認退貨記錄(string p_strId)
{
CKGPartOrderDetailOutFactory l_factory退貨記錄 = _context.CFactoryManager.CKGPartOrderDetailOutFactory;
CKGPartOrderDetailOut l_code退貨記錄 = l_factory退貨記錄.get退貨資料ById(p_strId);
CKGPointFactory l_factory點數資料 = _context.CFactoryManager.CKGPointFactory;
CKGPoint l_code點數資料 = l_factory點數資料.get業代點數資料(l_code退貨記錄.f_SalesSmid業代員編);
CUser l_user業代 = _context.CFactoryManager.CUserFactory.get高都員工檔(l_code退貨記錄.f_SalesSmid業代員編);
if (l_code點數資料 == null)
{
l_code點數資料 = l_factory點數資料.createCKGPoint();
l_code點數資料.f_Smid業代員編 = l_code退貨記錄.f_SalesSmid業代員編;
l_code點數資料.f_Name業代姓名 = l_user業代.f_username姓名;
l_code點數資料.f_Point現有點數 = 0;
l_factory點數資料.insertCKGPoint(l_code點數資料);
}
string l_str現在時間 = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
//
l_factory退貨記錄.update確認退貨By管理者(p_strId, l_str現在時間);
//把錢存回業代的點數
l_factory點數資料.update沖帳取消或退貨成功後點數歸回(l_code退貨記錄.f_SalesSmid業代員編, l_code退貨記錄.f_OutTotal總計退貨價格);
CKGPointDetailFactory l_factory點數紀錄 = _context.CFactoryManager.CKGPointDetailFactory;
CKGPointDetail l_code點數紀錄 = l_factory點數紀錄.createCKGPointDetail();
CUser l_user = Session[SealedGlobalPage.SESSIONKEY_LOGIN_USER_DATA] as CUser;
l_code點數紀錄.f_ImportSmid匯入人員員編 = l_user.f_userid帳號; //"F9446";//
l_code點數紀錄.f_ImportName匯入人員姓名 = l_user.f_username姓名; //"黃敏惠";//
l_code點數紀錄.f_Smid業代員編 = l_code退貨記錄.f_SalesSmid業代員編;
l_code點數紀錄.f_Name業代姓名 = l_user業代.f_username姓名;
l_code點數紀錄.f_ImportPoint匯入點數 = l_code退貨記錄.f_OutTotal總計退貨價格;
l_code點數紀錄.f_ImportDate匯入日期 = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
l_code點數紀錄.f_ImportType匯入方式 = "退貨加回";
l_factory點數紀錄.insertCKGPointDetail(l_code點數紀錄);
}
private void get退貨記錄(string p_type)
{
string l_str請購單號 = iv_txt請購單號.Text.Trim().ToUpper();
string l_str退貨所別 = iv_cbo退貨所別.SelectedValue;
string l_str退貨日期起 = _txtBDate.Text.Trim();
string l_str退貨日期止 = _txtEDate.Text.Trim();
CKGPartOrderDetailOutFactory l_factory = _context.CFactoryManager.CKGPartOrderDetailOutFactory;
CKGPartOrderDetailOut[] l_codes = null;
if ("NonCheck".Equals(p_type))
{
l_codes = l_factory.getAll退貨資料By條件("", l_str請購單號, l_str退貨所別, "", "False", l_str退貨日期起, l_str退貨日期止);
if (l_codes == null)
{
iv_pnl查詢結果.Visible = false;
iv_lblErrorMessage.Text = "無退貨記錄!!";
}
else
{
iv_pnl查詢結果.Visible = true;
display退貨記錄(l_codes);
}
}
else
{
l_codes = l_factory.getAll退貨資料By條件("", l_str請購單號, l_str退貨所別, "", "True", l_str退貨日期起, l_str退貨日期止);
if (l_codes == null)
{
iv_lblErrorMessage.Text = "無退貨歷史記錄!!";
}
else
{
display退貨歷史記錄(l_codes);
}
}
}
private void 查詢資料()
{
//iv_lblShow訂購單號.Text = "";
//iv_lblShow請購單號.Text = "";
string l_str所別 = iv_cbo所別.SelectedValue;
string l_str廠商 = iv_cbo廠商.SelectedValue;
string l_str起始日 = _txtBDate.Text.Trim();
string l_str結束日 = _txtEDate.Text.Trim();
CKGPartOrder[] l_codes = _context.CFactoryManager.CKGPartOrderFactory.
get小百貨對帳單資訊(l_str起始日, l_str結束日, l_str所別, l_str廠商);
if (l_codes == null)
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, typeof(UpdatePanel), "OK", "alert('查無訂購資料');", true);
}
else
{
display訂購清單(l_codes);
}
//退貨資料
CKGPartOrderDetailOutFactory l_factory退貨 = _context.CFactoryManager.CKGPartOrderDetailOutFactory;
CKGPartOrderDetailOut[] l_codes退貨 = l_factory退貨.getAll退貨資料By條件("", "", l_str所別, "", "True", l_str起始日, l_str結束日);
if (l_codes退貨 == null)
{
iv_lbl退貨明細.Text = "查詢區間內無退貨記錄";
}
else
{
iv_lbl退貨明細.Text = "退貨明細：";
display退貨歷史記錄(l_codes退貨);
}
}
