private void 儲值點數()
{
string l_str業代員編 = iv_lblSmid.Text;
string l_str業代姓名 = iv_lbl業代姓名.Text;
CKGPointFactory l_factory點數資料 = _context.CFactoryManager.CKGPointFactory;
CKGPoint l_code點數資料 = l_factory點數資料.get業代點數資料(l_str業代員編);
int l_int總點數 = 0;
int l_int儲值點數 = Convert.ToInt32(iv_txt儲值點數.Text.Trim());
l_int總點數 += l_code點數資料.f_Point現有點數;
l_int總點數 += l_int儲值點數;
l_factory點數資料.update業代點數(l_str業代員編, l_int總點數);//修改現有點數
CKGPointDetailFactory l_factory紀錄 = _context.CFactoryManager.CKGPointDetailFactory;
CKGPointDetail l_code紀錄 = l_factory紀錄.createCKGPointDetail();
l_code紀錄.f_Smid業代員編 = l_str業代員編;
l_code紀錄.f_Name業代姓名 = l_str業代姓名;
l_code紀錄.f_ImportPoint匯入點數 = l_int儲值點數;
l_code紀錄.f_ImportDate匯入日期 = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
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_ImportType匯入方式 = iv_cbo儲值方式.SelectedValue;
l_code紀錄.f_InvoiceNo發票號碼 = iv_txt發票號碼.Text.Trim();
l_code紀錄.f_PayBank刷卡銀行 = iv_cbo刷卡銀行.SelectedValue;
l_code紀錄.f_InMoneyBank入帳銀行 = iv_cbo入帳銀行.SelectedValue;
l_code紀錄.f_Memo = txtMemo.Text;
try
{
if ("刷卡儲值".Equals(iv_cbo儲值方式.SelectedValue))
{
l_code紀錄.f_BankCharge手續費 = Convert.ToInt32(iv_txt手續費.Text.Trim());
}
else
{
l_code紀錄.f_BankCharge手續費 = 0;
}
}
catch
{
l_code紀錄.f_BankCharge手續費 = 0;
}
l_factory紀錄.insertCKGPointDetail(l_code紀錄);
iv_lbl現有點數.Text = l_int總點數.ToString();
iv_txt儲值點數.Text = "";
iv_txt發票號碼.Text = "";
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, typeof(UpdatePanel), "OK", "alert('儲值成功')", true);
}
private void 匯入資料()
{
List <List <string> > l_lists = (List <List <string> >)Session[SealedGlobalPage.SESSIONKEY_KGPOINT_IMPORT_EXCEL];
CKGPointFactory l_factory點數 = iv_context.CFactoryManager.CKGPointFactory;
Hashtable l_ht = set匯入點數資訊並加總(l_lists);
l_factory點數.insert點數與記錄ByHashtable(l_ht);
}
private void 查詢業代資料(string p_strSmid)
{
string l_str業代員編 = iv_txt業代員編.Text.Trim().ToUpper();
CKGPointFactory l_factory點數資料 = _context.CFactoryManager.CKGPointFactory;
CKGPoint l_code點數資料 = l_factory點數資料.get業代點數資料(p_strSmid);
if (l_code點數資料 == null)
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, typeof(UpdatePanel), "OK", "alert('無此員工點數資料，進行新增個人點數資料作業')", true);
return;
}
開啟儲值畫面(l_code點數資料);
}
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 查詢應收帳款(bool p_是否存入session)
{
string l_strSmid = _txt員編.Text.Trim();
string l_strBDate = _txtBDate.Text;
string l_strEDate = _txtEDate.Text;
if ("".Equals(l_strSmid))
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, typeof(UpdatePanel), "OK", "alert('請輸入員編');", true);
return;
}
if ("".Equals(l_strBDate))
{
l_strBDate = "2010/01/01";
}
if ("".Equals(_txtEDate))
{
l_strEDate = DateTime.Today.ToString("yyyy/MM/dd");
}
//查詢點數資訊
CKGPointFactory l_factory點數資料 = _context.CFactoryManager.CKGPointFactory;
CKGPoint l_code點數資料 = l_factory點數資料.get業代點數資料(l_strSmid);
_lbl目前點數.Text = l_code點數資料.f_Point現有點數.ToString();
if (l_code點數資料 == null)
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, typeof(UpdatePanel), "OK", "alert('無此員工點數資料，進行新增個人點數資料作業')", true);
return;
}
//查詢應收帳款資訊
CInMoney[] l_inmoney = _context.CFactoryManager.CInMoneyFactory.
get查詢應收帳款(l_strSmid, l_strBDate, l_strEDate);
display(l_inmoney, p_是否存入session);
}
