private DataTable getDataTableBydisplay(CKGPart[] p_codes)
{
string[] l_str = { "ID", "項次", "類別編號", "類別名稱", "種類編號", "種類名稱", "產品編號", "產品名稱", "單位", "成本價", "業代價", "售價", "修改" };
DataTable l_dt = CTools.getFilledColumnsDataTable(l_str);
int l_int項次 = 1;
for (int i = 0; i < p_codes.Length; i++)
{
DataRow l_row = l_dt.NewRow();
l_row["ID"] = p_codes[i].f_id;
l_row["項次"] = l_int項次++;
l_row["類別編號"] = p_codes[i].f_TypeID類別編號;
l_row["類別名稱"] = p_codes[i].f_TypeName類別名稱;
l_row["種類編號"] = p_codes[i].f_CategoryID種類編號;
l_row["種類名稱"] = p_codes[i].f_CategoryName種類名稱;
l_row["產品編號"] = p_codes[i].f_ProductID產品編號;
l_row["產品名稱"] = p_codes[i].f_ProductName產品名稱;
l_row["單位"] = p_codes[i].f_Qty單位;
l_row["成本價"] = p_codes[i].f_Cost成本價;
l_row["業代價"] = p_codes[i].f_SalePrice業代價;
l_row["售價"] = p_codes[i].f_ListPrice售價;
l_row["修改"] = "FrmUpdateKGPart.aspx?id=" + p_codes[i].f_id;
l_dt.Rows.Add(l_row);
}
Session.Add(SealedGlobalPage.SESSIONKEY_PARTS, l_dt);
return(l_dt);
}
/// <summary>
/// 输入检查
/// </summary>
private bool CheckInput()
{
string strErrorlog = null;
if (string.IsNullOrEmpty(this.txtCustomer.Text.Trim()))
{
strErrorlog += "代理店不能为空!\r\n";
}
if (string.IsNullOrEmpty(this.txtReported.Text.Trim()))
{
strErrorlog += "报备客户名称不能为空!\r\n";
}
if (strErrorlog != null)
{
MessageBox.Show(strErrorlog, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
if (CTools.GetTextBoxLength(txtReported.Text) > txtReported.MaxLength)
{
txtReported.Text = CTools.textSpilt(txtReported.Text, txtReported.MaxLength);
}
return(true);
}
private DataTable getDataTableBydisplay請購單(CKGPartOrder[] p_codes)
{
string[] l_str = { "請購名細", "請購所別", "對象廠商", "請購筆數", "請購所別id" };
DataTable l_table = CTools.getFilledColumnsDataTable(l_str);
if (p_codes == null)
{
return(l_table);
}
for (int i = 0; i < p_codes.Length; i++)
{
DataRow l_row = l_table.NewRow();
l_row["請購名細"] = ""; //0
l_row["請購所別"] = CTools.get轉換據點中英文(p_codes[i].f_SalesBranch業代單位); //1
l_row["請購所別id"] = p_codes[i].f_SalesBranch業代單位; //1
l_row["對象廠商"] = p_codes[i].f_Vendor請購廠商; //2
l_row["請購筆數"] = p_codes[i].NonSendCount未發送的請購筆數; //3
l_table.Rows.Add(l_row);
}
return(l_table);
}
protected void iv_btn檢視_Click(object sender, EventArgs e)
{
string l_str檔案名稱 = iv_cbo檔案名稱.SelectedValue;
if (!"".Equals(l_str檔案名稱) && !"無資料".Equals(l_str檔案名稱))
{
try
{
string l_str檔案完整路徑 = (string)Session[SealedGlobalPage.SESSIONKEY_KGPOINT_EXCEL_LOCATION] + "\\" + l_str檔案名稱;
List <List <string> > l_lists = CTools.get高輊業代點數(l_str檔案完整路徑, "Sheet1");
display(l_lists);
Session.Add(SealedGlobalPage.SESSIONKEY_KGPOINT_IMPORT_EXCEL, l_lists);
iv_btnInsert.Visible = true;
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(iv_btn檢視, typeof(Button), "OK", "alert('" + ex.Message + "');", true);
}
}
else
{
string l_str = "alert('請選擇要匯入的檔案');";
ScriptManager.RegisterClientScriptBlock(iv_btn檢視, typeof(Button), "OK", l_str, true);
}
}
private DataTable getDataTableBydisplay請購記錄(CKGPartOrder[] p_codes)
{
string[] l_str = { "退貨", "請購單號", "請購廠商", "請購日期", "引擎號碼", "業代員編", "業代姓名", "業代單位", "總計價格", "備註" };
DataTable l_table = CTools.getFilledColumnsDataTable(l_str);
if (p_codes == null)
{
return(l_table);
}
for (int i = 0; i < p_codes.Length; i++)
{
DataRow l_row = l_table.NewRow();
l_row["退貨"] = ""; //0
l_row["請購單號"] = p_codes[i].f_ExchangeID請購單號; //1
l_row["請購廠商"] = set廠商名稱(p_codes[i].f_Vendor請購廠商); //2
l_row["請購日期"] = p_codes[i].f_InsertDate請購日期; //3
l_row["引擎號碼"] = p_codes[i].f_EngineNo引擎號碼; //4
l_row["業代員編"] = p_codes[i].f_SalesSmid業代員編; //5
l_row["業代姓名"] = p_codes[i].f_SalesName業代姓名; //6
l_row["業代單位"] = p_codes[i].f_SalesBranch業代單位; //7
l_row["總計價格"] = p_codes[i].f_TotalPrice總計價格; //8
l_row["備註"] = p_codes[i].f_Memo備註說明; //9
l_table.Rows.Add(l_row);
}
return(l_table);
}
private void display(CUser[] p_User)
{
string[] l_Msg = new string[] { "項次", "所別", "帳號", "密碼", "姓名", "等級" };
DataTable l_dt = CTools.getFilledColumnsDataTable(l_Msg);
if (p_User.Length <= 0)
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, typeof(UpdatePanel), "Error", "alert('查無資料!請重新確認');", true);
GridView1.DataSource = l_dt;
GridView1.DataBind();
return;
}
for (int i = 0; i < p_User.Length; i++)
{
DataRow l_row = l_dt.NewRow();
l_row["項次"] = (i + 1).ToString();
l_row["所別"] = p_User[i].f_branchid所別;
l_row["姓名"] = p_User[i].f_username姓名;
l_row["帳號"] = p_User[i].f_userid帳號;
l_row["密碼"] = p_User[i].f_password密碼;
l_row["等級"] = CTools.get使用者等級中文顯示(p_User[i].f_lvl等級);
l_dt.Rows.Add(l_row);
}
GridView1.DataSource = l_dt;
GridView1.DataBind();
}
/// <summary>
/// 计算距离现在时间长度
/// </summary>
/// <param name="longtime"></param>
/// <returns></returns>
public static string TimeDiff(long longtime)
{
var datetime = CTools.GetUNIXTime(longtime / 1000.0);
DateTime datetime2 = DateTime.Now;
int days = datetime2.Subtract(datetime).Days;
int hours = datetime2.Subtract(datetime).Hours;
int minutes = datetime2.Subtract(datetime).Minutes;
int seconds = datetime2.Subtract(datetime).Seconds;
if (days > 0)
{
return(days + "天前");
}
if (hours > 0)
{
return(hours + "小时前");
}
if (minutes > 0)
{
return(minutes + "分钟前");
}
if (seconds > 0)
{
return(seconds + "秒前");
}
return("1秒前");
}
protected void Page_Load(object sender, EventArgs e)
{
_context = SealedGlobalPage.getContext(this);
string l_strBranchid = (Session[SealedGlobalPage.SESSIONKEY_LOGIN_USER_DATA] as CUser).f_branchid所別;
string l_strType = Request["type"];
if (!Page.IsPostBack)
{
//保險介紹只有幾間特定公司 20130411 way
if (l_strType.Equals("24"))
{
CTools.get保險公司介紹(_rdo保險公司, _context);
}
else
{
CTools.get保險公司(_rdo保險公司, _context);
}
_txt工單號碼.Text = CTools.get工單號碼(l_strBranchid);
//把前端FrmWorkType.aspx?type= ??? 數字表示變成中文顯示
顯示工單種類中文名稱(l_strType);
初始化();
}
}
private DataTable getDataTableByDisplay小百貨明細(CKGPartOrderDetail[] p_detail)
{
string[] l_Msg = new string[] { "項次", "單號", "產品編號", "產品名稱", "數量", "金額", "販賣價", "開單人員" };
DataTable l_dt = CTools.getFilledColumnsDataTable(l_Msg);
for (int i = 0; i < p_detail.Length; i++)
{
DataRow l_row = l_dt.NewRow();
l_row["項次"] = "1";
l_row["單號"] = p_detail[i].f_ExchangeID請購單號;
l_row["產品編號"] = p_detail[i].f_ProductID產品編號;
l_row["產品名稱"] = p_detail[i].f_ProductName產品名稱;
l_row["數量"] = p_detail[i].f_Amount選購數量;
l_row["金額"] = p_detail[i].f_Cost產品成本價;
l_row["販賣價"] = p_detail[i].f_SalePrice販賣價;
CKGPartOrder l_order = _context.CFactoryManager.CKGPartOrderFactory.
getKGPartOrderBy請購單號(p_detail[i].f_ExchangeID請購單號);
try
{
l_row["開單人員"] = _context.CFactoryManager.CUserFactory.get高都員工檔(
l_order.f_AssistantSmid助理員編).f_username姓名;
}
catch { l_row["開單人員"] = "無此員編(" + l_order.f_AssistantSmid助理員編 + ")"; }
l_dt.Rows.Add(l_row);
}
return(l_dt);
}
private DataTable getDataTableBydisplay退貨歷史記錄(CKGPartOrderDetailOut[] p_codes)
{
string[] l_str = { "請購單號", "退貨日期", "員編", "姓名", "單位", "成本", "總計" };
DataTable l_table = CTools.getFilledColumnsDataTable(l_str);
if (p_codes == null)
{
return(l_table);
}
for (int i = 0; i < p_codes.Length; i++)
{
DataRow l_row = l_table.NewRow();
l_row["請購單號"] = p_codes[i].f_ExchangeID請購單號; //1
l_row["退貨日期"] = p_codes[i].f_OutDate退貨日期; //2
l_row["員編"] = p_codes[i].f_SalesSmid業代員編; //3
CUser l_user = _context.CFactoryManager.CUserFactory.get高都員工檔(p_codes[i].f_SalesSmid業代員編);
l_row["姓名"] = l_user.f_username姓名; //4
l_row["單位"] = p_codes[i].f_SalesBranch業代單位; //5
l_row["成本"] = p_codes[i].f_Cost產品成本 * p_codes[i].f_OutAmount退貨數量; //8
//l_row["單價"] = p_codes[i].f_UnitPrice產品單價;//8
l_row["總計"] = p_codes[i].f_OutTotal總計退貨價格; //10
//l_row["退貨原因"] = p_codes[i].f_OutReasons退貨原因;//1
l_table.Rows.Add(l_row);
}
return(l_table);
}
private DataTable getDataTableBydisplay退貨歷史記錄(CKGPartOrderDetailOut[] p_codes)
{
string[] l_str = { "請購單號", "退貨日期", "員編", "姓名", "單位", "產品編號", "產品名稱", "成本價", "單價", "數量", "總計", "退貨原因" };
DataTable l_table = CTools.getFilledColumnsDataTable(l_str);
if (p_codes == null)
{
return(l_table);
}
for (int i = 0; i < p_codes.Length; i++)
{
DataRow l_row = l_table.NewRow();
l_row["請購單號"] = p_codes[i].f_ExchangeID請購單號; //1
l_row["退貨日期"] = p_codes[i].f_OutDate退貨日期; //2
l_row["員編"] = p_codes[i].f_SalesSmid業代員編; //3
l_row["姓名"] = p_codes[i].f_SalesName業代姓名; //4
l_row["單位"] = CTools.get轉換據點中英文(p_codes[i].f_SalesBranch業代單位); //5
l_row["產品編號"] = p_codes[i].f_ProductID產品編號; //6
l_row["產品名稱"] = p_codes[i].f_ProductName產品名稱; //7
l_row["成本價"] = p_codes[i].f_Cost產品成本; //8
l_row["單價"] = p_codes[i].f_UnitPrice產品單價; //8
l_row["數量"] = p_codes[i].f_OutAmount退貨數量; //9
l_row["總計"] = p_codes[i].f_OutTotal總計退貨價格; //10
l_row["退貨原因"] = p_codes[i].f_OutReasons退貨原因; //11
l_table.Rows.Add(l_row);
}
return(l_table);
}
private void display(CInMoney[] p_CInMoney, bool p_是否存入session)
{
string[] l_Msg = new string[] { "項次", "工單號碼", "員工編號", "名稱", "應收帳款", "帳款日期" };
DataTable l_dt = CTools.getFilledColumnsDataTable(l_Msg);
int l_int應收 = 0;
for (int i = 0; i < p_CInMoney.Length; i++)
{
DataRow l_row = l_dt.NewRow();
l_row["項次"] = (i + 1).ToString();
l_row["工單號碼"] = p_CInMoney[i].f_workid工單單號;
l_row["員工編號"] = p_CInMoney[i].f_smid帳款人;
l_row["名稱"] = p_CInMoney[i].f_smid員工名稱;
l_row["應收帳款"] = p_CInMoney[i].f_money應收金額;
l_row["帳款日期"] = p_CInMoney[i].f_editdate帳款日期;
l_int應收 += p_CInMoney[i].f_money應收金額;
l_dt.Rows.Add(l_row);
}
//2011-01-04 拿掉此功能
//if (p_是否存入session)//沖帳後的重新查詢不濟session
//{
// // 存入 session 中 方便列印
// Session.Add(SealedGlobalPage.VIEWSTATE_INMONEY, l_dt);
//}
_lbl應收金額.Text = l_int應收.ToString();
_lbl已收金額.Text = "0";
_gvAmt.DataSource = l_dt;
_gvAmt.DataBind();
}
/// <summary>
/// 输入检查
/// </summary>
private bool CheckInput()
{
string strErrorlog = null;
//判断编号不能为空
if (string.IsNullOrEmpty(this.txtCode.Text.Trim()))
{
strErrorlog += "编号不能为空!\r\n";
}
//判断名称不能为空
if (string.IsNullOrEmpty(this.txtName.Text.Trim()))
{
strErrorlog += "名称不能为空!\r\n";
}
if (strErrorlog != null)
{
MessageBox.Show(strErrorlog, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
if (CTools.GetTextBoxLength(txtName.Text) > txtName.MaxLength)
{
txtName.Text = CTools.textSpilt(txtName.Text, txtName.MaxLength);
}
return(true);
}
private DataTable getDataTableByGridView(CKGPartOrder[] p_codes)
{
string[] l_str = { "EID", "廠商", "日期", "員編", "姓名", "單位", "總計金額", "備註" };
DataTable l_table = CTools.getFilledColumnsDataTable(l_str);
int l_intTotal = 0;
int l_intTotalBy販賣 = 0;
for (int i = 0; i < p_codes.Length; i++)
{
DataRow l_row = l_table.NewRow();
l_row["EID"] = p_codes[i].f_ExchangeID請購單號; //1
l_row["廠商"] = set轉換廠商代碼(p_codes[i].f_Vendor請購廠商);
l_row["日期"] = p_codes[i].f_InsertDate請購日期; //6
l_row["員編"] = p_codes[i].f_SalesSmid業代員編; //3
l_row["姓名"] = p_codes[i].f_SalesName業代姓名; //4
l_row["單位"] = p_codes[i].f_SalesBranch業代單位; //4
CUser l_user = Session[SealedGlobalPage.SESSIONKEY_LOGIN_USER_DATA] as CUser;
if (l_user == null)
{
Session.Remove(SealedGlobalPage.SESSIONKEY_LOGIN_USER_DATA);
Response.Redirect("../FrmLogin.aspx");
}
l_row["總計金額"] = p_codes[i].f_TotalPrice總計價格 + "(" + p_codes[i].f_TotalSale總販賣價 + ")";//4
l_intTotal += p_codes[i].f_TotalPrice總計價格;
l_intTotalBy販賣 += p_codes[i].f_TotalSale總販賣價;
//l_intTotal += p_codes[i].f_TotalPrice總計價格;
l_row["備註"] = p_codes[i].f_Memo備註說明;//4
l_table.Rows.Add(l_row);
}
_lblTotal.Text = l_intTotal.ToString() + "(" + l_intTotalBy販賣 + ")";
return(l_table);
}
private void display(CWork[] p_CWork)
{
string[] l_Msg = new string[] { "項次", "工單號碼", "引擎號碼", "顧客名稱", "洗車種類", "金額", "開單日期", "開單人員" };
DataTable l_dt = CTools.getFilledColumnsDataTable(l_Msg);
if (p_CWork.Length <= 0)
{
return;
}
for (int i = 0; i < p_CWork.Length; i++)
{
DataRow l_row = l_dt.NewRow();
l_row["項次"] = (i + 1).ToString();
l_row["工單號碼"] = p_CWork[i].f_workid工單單號;
l_row["引擎號碼"] = p_CWork[i].f_engo引擎號碼;
l_row["顧客名稱"] = p_CWork[i].f_customerid顧客名稱;
l_row["洗車種類"] = p_CWork[i].f_workType洗車種類;
l_row["金額"] = p_CWork[i].f_money金額;
l_row["開單日期"] = p_CWork[i].f_editdate開單日期;
l_row["開單人員"] = p_CWork[i].f_edituser開單人員;
l_dt.Rows.Add(l_row);
Session.Add(p_CWork[i].f_workid工單單號, p_CWork[i]);
}
_gvWork.DataSource = l_dt;
_gvWork.DataBind();
}
public override void OnAuthorization(HttpActionContext actionContext)
{
//如果用户方位的Action带有AllowAnonymousAttribute，则不进行授权验证
if (actionContext.ActionDescriptor.GetCustomAttributes <AllowAnonymousAttribute>().Any())
{
return;
}
string userid = CRequest.GetString("userid");
string token = CRequest.GetString("token");
string openid = CRequest.GetString("openid");
if (userid == "" || token == "" || openid == "")
{
actionContext.Response = ResponseStr.ToJsonError("9", "未登陆");
}
else
{
Log.WriterLog(userid + "--" + token + "--" + openid);
openid = CTools.GetOpenId(openid);
if (!token.Equals(CTools.GetMD5FromString(userid + openid + "SSXXCJYXGS")))
{
actionContext.Response = ResponseStr.ToJsonError("9", "非法请求");
}
}
}
private DataTable getDataTableBydisplay(CKGPartOrderDetail[] p_codes)
{
string[] l_str = { "產品編號", "產品名稱", "數量", "單價", "成本總計", "總計" };
DataTable l_table = CTools.getFilledColumnsDataTable(l_str);
if (p_codes == null)
{
return(l_table);
}
for (int i = 0; i < p_codes.Length; i++)
{
DataRow l_row = l_table.NewRow();
l_row["產品編號"] = p_codes[i].f_ProductID產品編號; //0
l_row["產品名稱"] = p_codes[i].f_ProductName產品名稱; //1
l_row["數量"] = p_codes[i].f_Amount選購數量; //2
l_row["單價"] = p_codes[i].f_UnitPrice產品單價; //3
l_row["成本總計"] = p_codes[i].f_Amount選購數量 * p_codes[i].f_UnitPrice產品單價; //3
l_row["總計"] = p_codes[i].f_Total總計價格; //3
l_table.Rows.Add(l_row);
}
return(l_table);
}
/// <summary>
/// 输入检查
/// </summary>
private bool CheckInput()
{
string strErrorlog = null;
//判断编号不能为空
if (string.IsNullOrEmpty(this.txtCustomerCode.Text.Trim()))
{
strErrorlog += "客户编号不能为空!\r\n";
}
//判断地址编号不能为空
if (string.IsNullOrEmpty(this.txtDeliveryCode.Text.Trim()))
{
strErrorlog += "地址编号不能为空!\r\n";
}
//判断地址名称不能为空
if (string.IsNullOrEmpty(this.txtAddressFirst.Text.Trim()))
{
strErrorlog += "地址1不能为空!\r\n";
}
if (strErrorlog != null || "".Equals(strErrorlog))
{
MessageBox.Show(strErrorlog, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
if (CTools.GetTextBoxLength(txtContactName.Text) > txtContactName.MaxLength)
{
txtContactName.Text = CTools.textSpilt(txtContactName.Text, txtContactName.MaxLength);
}
return(true);
}
private void display(C保險實績統計[] p_保險實績統計)
{
string[] l_Msg = new string[] { "所別", "保險公司", "實績" };
DataTable l_dt = CTools.getFilledColumnsDataTable(l_Msg);
//if (p_薪資計算.Length <= 0)
//{
// ScriptManager.RegisterClientScriptBlock(UpdatePanel1, typeof(UpdatePanel), "Error", "alert('無符合資料!請重新確認');", true);
// _gvAmt.DataSource = l_dt;
// _gvAmt.DataBind();
// return;
//}
for (int i = 0; i < p_保險實績統計.Length; i++)
{
DataRow l_row = l_dt.NewRow();
l_row["所別"] = CTools.get轉換據點中英文(p_保險實績統計[i].所別);
//所別一樣只秀一次,第一次不判斷
if (i > 0)
{
if (p_保險實績統計[i - 1].所別.Equals(p_保險實績統計[i].所別))
{
l_row["所別"] = "";
}
}
l_row["保險公司"] = p_保險實績統計[i].代碼名稱;
l_row["實績"] = p_保險實績統計[i].實績;
l_dt.Rows.Add(l_row);
}
_gvAmt.DataSource = l_dt;
_gvAmt.DataBind();
}
private DataTable getDataTableByDisplay(C欠款紀錄[] p_欠款紀錄)
{
string[] l_Msg = new string[] { "項次", "據點", "員編", "姓名", "應收金額", "洗車款項", "小百貨款項", "剩餘點數", "實收金額", "明細" };
DataTable l_dt = CTools.getFilledColumnsDataTable(l_Msg);
for (int i = 0; i < p_欠款紀錄.Length; i++)
{
DataRow l_row = l_dt.NewRow();
l_row["項次"] = (i + 1).ToString();
l_row["據點"] = p_欠款紀錄[i].據點;
l_row["員編"] = p_欠款紀錄[i].業編;
l_row["姓名"] = p_欠款紀錄[i].稱;
l_row["應收金額"] = p_欠款紀錄[i].金額;
l_row["剩餘點數"] = p_欠款紀錄[i].剩餘點數;
l_row["洗車款項"] = p_欠款紀錄[i].洗車款項;
l_row["小百貨款項"] = p_欠款紀錄[i].小百貨款項;
if (String.IsNullOrEmpty(p_欠款紀錄[i].剩餘點數))
{
p_欠款紀錄[i].剩餘點數 = "0";
}
try
{
l_row["實收金額"] = Convert.ToDouble(p_欠款紀錄[i].金額) - Convert.ToDouble(p_欠款紀錄[i].剩餘點數);
}
catch { l_row["實收金額"] = 0; }
l_row["明細"] = "./FrmArrearsMoneyDetail.aspx?smid=" + p_欠款紀錄[i].業編;
l_dt.Rows.Add(l_row);
}
Session.Add("FrmArrearsMoney", l_dt);
return(l_dt);
}
private void setCircleEnable(GameObject obj, bool bEnabled)
{
if (bEnabled == true)
{
if (SyncLockTarget != null && SyncLockTarget.realObject != null)
{
obj.transform.parent = SyncLockTarget.realObject.transform;
obj.transform.position = SyncLockTarget.realObject.transform.position + new Vector3(0.0f, 0.2f, 0.0f);
obj.transform.localRotation = Quaternion.Euler(new Vector3(0.0f, 0.0f, 0.0f));
obj.gameObject.SetActive(true);
float radius = 1.0f;
if (CTools.IfTypeHero((JT.FWW.GameData.EObjectType)SyncLockTarget.NpcGUIDType))
{
radius = ConfigReader.HeroXmlInfoDict[SyncLockTarget.NpcGUIDType].n32LockRadious;
obj.transform.localScale = new Vector3(radius, 1.0f, radius);
}
else
{
radius = ConfigReader.NpcXmlInfoDict[SyncLockTarget.NpcGUIDType].n32LockRadius;
obj.transform.localScale = new Vector3(radius, 1.0f, radius);
}
}
}
else
{
obj.transform.parent = null;
obj.gameObject.SetActive(false);
}
}
private DataTable getDataTableBydisplay訂購清單(CKGPartOrder[] p_codes)
{
string[] l_str = { "訂購單號", "廠商代號", "廠商", "訂購日期", "請購單位", "成本總計", "訂購總計", "販賣總計" };
DataTable l_table = CTools.getFilledColumnsDataTable(l_str);
if (p_codes == null)
{
return(l_table);
}
for (int i = 0; i < p_codes.Length; i++)
{
DataRow l_row = l_table.NewRow();
l_row["訂購單號"] = p_codes[i].f_ExchangeID請購單號; //1
l_row["廠商代號"] = p_codes[i].f_Vendor請購廠商; //2
l_row["廠商"] = set廠商名稱(p_codes[i].f_Vendor請購廠商); //2
l_row["訂購日期"] = p_codes[i].f_InsertDate請購日期; //2
l_row["請購單位"] = CTools.get轉換據點中英文(p_codes[i].f_Branchid請購單位); //2
l_row["成本總計"] = p_codes[i].f_TotalCost總成本價; //3
l_row["訂購總計"] = p_codes[i].f_TotalPrice總計價格; //4
l_row["販賣總計"] = p_codes[i].f_TotalSale總販賣價; //4
l_table.Rows.Add(l_row);
}
return(l_table);
}
private void display(C小百貨產品銷售排行[] p_小百貨產品銷售排行)
{
string[] l_Msg = new string[] { "項次", "產品編號", "產品名稱", "銷售次數", "總銷售金額" };
DataTable l_dt = CTools.getFilledColumnsDataTable(l_Msg);
if (p_小百貨產品銷售排行.Length <= 0)
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, typeof(UpdatePanel), "Error", "alert('無符合資料!請重新確認');", true);
_gvAmt.DataSource = l_dt;
_gvAmt.DataBind();
return;
}
for (int i = 0; i < p_小百貨產品銷售排行.Length; i++)
{
DataRow l_row = l_dt.NewRow();
l_row["項次"] = (i + 1).ToString();
l_row["產品編號"] = p_小百貨產品銷售排行[i].編號;
l_row["產品名稱"] = p_小百貨產品銷售排行[i].稱;
l_row["銷售次數"] = p_小百貨產品銷售排行[i].銷售次數;
l_row["總銷售金額"] = p_小百貨產品銷售排行[i].總銷售金額;
l_dt.Rows.Add(l_row);
}
_gvAmt.DataSource = l_dt;
_gvAmt.DataBind();
}
private DataTable getTableByDisplay(C小百貨銷售明細[] p_codes)
{
string[] l_str = { "單號", "所別", "日期", "員編", "姓名", "產品編號", "產品名稱", "數量", "單價", "販賣單價", "總計", "訂貨總計" };
DataTable l_table = CTools.getFilledColumnsDataTable(l_str);
if (p_codes == null)
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, typeof(UpdatePanel), "Error", "alert('無符合資料!請重新確認');", true);
return(l_table);
}
string l_str營業所 = "";
for (int i = 0; i < p_codes.Length; i++)
{
DataRow l_row = l_table.NewRow();
if (!l_str營業所.Equals(p_codes[i].單號))
{
l_row["單號"] = p_codes[i].單號;//
}
else
{
l_row["單號"] = "";
}
string l_str所別 = CTools.get轉換據點中英文(p_codes[i].所別);//6
l_row["所別"] = l_str所別;
if (_rdoType.SelectedValue.Equals("服務廠"))
{
if (l_str所別.IndexOf("廠") <= 0)
{
continue;
}
}
else if (_rdoType.SelectedValue.Equals("營業所"))
{
if (l_str所別.IndexOf("廠") > 0)
{
continue;
}
}
l_row["日期"] = p_codes[i].日期; //6
l_row["員編"] = p_codes[i].員編; //6
l_row["姓名"] = p_codes[i].姓名; //6
l_row["產品編號"] = p_codes[i].產品編號; //6
l_row["產品名稱"] = p_codes[i].產品名稱; //6
l_row["數量"] = p_codes[i].數量; //6
l_row["單價"] = p_codes[i].單價; //6
l_row["販賣單價"] = p_codes[i].販賣單價; //6
l_row["總計"] = p_codes[i].總計; //6
l_row["訂貨總計"] = p_codes[i].數量 * p_codes[i].單價; //6
l_str營業所 = p_codes[i].單號;
l_table.Rows.Add(l_row);
}
return(l_table);
}
protected void Page_Load(object sender, EventArgs e)
{
_context = SealedGlobalPage.getContext(this);
if (!Page.IsPostBack)
{
CTools.get所別(iv_cbo退貨所別, _context);
}
}
/// <summary>
/// 输入检查
/// </summary>
private bool CheckInput()
{
string strErrorlog = null;
//判断编号不能为空
if (string.IsNullOrEmpty(this.txtCode.Text.Trim()))
{
strErrorlog += "商品编号不能为空!\r\n";
}
//判断名称不能为空
if (string.IsNullOrEmpty(this.txtName.Text.Trim()))
{
strErrorlog += "商品名称不能为空!\r\n";
}
if (string.IsNullOrEmpty(this.txtBasic.Text.Trim()))
{
strErrorlog += "基本单位不能为空!\r\n";
}
//判断类别不能为空
if (string.IsNullOrEmpty(this.txtGroupCode.Text.Trim()))
{
strErrorlog += "类别编号不能为空!\r\n";
}
//判断安全在库数不能为空
if (string.IsNullOrEmpty(this.txtSafetyStock.Text.Trim()))
{
strErrorlog += "安全在库数不能为空!\r\n";
}
if (strErrorlog != null)
{
MessageBox.Show(strErrorlog, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
if (txtPrice.Text == null || "".Equals(txtPrice.Text))
{
txtPrice.Text = "0";
}
if (CTools.GetTextBoxLength(txtName.Text) > txtName.MaxLength)
{
txtName.Text = CTools.textSpilt(txtName.Text, txtName.MaxLength);
}
if (CTools.GetTextBoxLength(txtModelNumber.Text) > txtModelNumber.MaxLength)
{
txtModelNumber.Text = CTools.textSpilt(txtModelNumber.Text, txtModelNumber.MaxLength);
}
return(true);
}
/// <summary>
/// 输入检查
/// </summary>
private bool CheckInput()
{
string strErrorlog = null;
//判断编号不能为空
if (string.IsNullOrEmpty(this.txtCode.Text.Trim()))
{
strErrorlog += "原料编号不能为空!\r\n";
}
//判断编号是否已存在
else if (_mode != CConstant.MODE_MODIFY && bProduct.Exists(txtCode.Text.Trim()))
{
strErrorlog += "原料编号已存在。\r\n";
}
//判断名称不能为空
if (string.IsNullOrEmpty(this.txtName.Text.Trim()))
{
strErrorlog += "原料名称不能为空!\r\n";
}
if (string.IsNullOrEmpty(this.txtUnitCode.Text.Trim()))
{
strErrorlog += "基本单位不能为空!\r\n";
}
//判断类别不能为空
if (string.IsNullOrEmpty(this.txtGroupCode.Text.Trim()))
{
strErrorlog += "种类编号不能为空!\r\n";
}
//判断安全在库数不能为空
if (string.IsNullOrEmpty(this.txtSafetyStock.Text.Trim()))
{
strErrorlog += "安全在库数不能为空!\r\n";
}
if (strErrorlog != null)
{
MessageBox.Show(strErrorlog, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
if (txtPrice.Text == null || "".Equals(txtPrice.Text))
{
txtPrice.Text = "0";
}
if (CTools.GetTextBoxLength(txtName.Text) > txtName.MaxLength)
{
txtName.Text = CTools.textSpilt(txtName.Text, txtName.MaxLength);
}
return(true);
}
private void display()
{
CUser l_user = _context.CFactoryManager.CUserFactory.get高都員工檔(Request["smid"]);
_lbl員編.Text = l_user.f_branchid所別 + "/" + l_user.f_userid帳號 + "/" + l_user.f_username姓名;
_lbl員編1.Text = _lbl員編.Text;
_lbl付款日期.Text = DateTime.Today.ToString("yyyy/MM/dd");
_lbl付款日期1.Text = DateTime.Today.ToString("yyyy/MM/dd");
_lbl尚餘點數.Text = Request["point"];
_lbl尚餘點數1.Text = Request["point"];
_lbl總計.Text = Request["count"];
_lbl總計1.Text = Request["count"];
ArrayList l_al工單號碼 = Session[SealedGlobalPage.SESSIONKEY_INMONEY_WORKID] as ArrayList;
DataTable l_dt = Session[SealedGlobalPage.VIEWSTATE_INMONEY] as DataTable;
string[] l_Msg = new string[] { "項次", "工單號碼", "員工編號", "名稱", "應收帳款", "帳款日期" };
DataTable l_dt沖帳列印 = CTools.getFilledColumnsDataTable(l_Msg);
for (int i = 0; i < l_dt.Rows.Count; i++)
{
bool l_bool是否沖帳 = false;
for (int j = 0; j < l_al工單號碼.Count; j++)
{
string l_workid = l_al工單號碼[j].ToString();
if (l_workid.Equals(l_dt.Rows[i]["工單號碼"]))
{
l_bool是否沖帳 = true;
DataRow l_row = l_dt沖帳列印.NewRow();
l_row["項次"] = l_dt.Rows[i]["項次"];
l_row["工單號碼"] = l_dt.Rows[i]["工單號碼"];
l_row["員工編號"] = l_dt.Rows[i]["員工編號"];
l_row["名稱"] = l_dt.Rows[i]["名稱"];
l_row["應收帳款"] = l_dt.Rows[i]["應收帳款"];
l_row["帳款日期"] = l_dt.Rows[i]["帳款日期"];
l_dt沖帳列印.Rows.Add(l_row);
}
}
if (!l_bool是否沖帳)
{
l_dt.Rows[i].Delete();
}
}
GridView1.DataSource = l_dt沖帳列印;
GridView2.DataSource = l_dt沖帳列印;
GridView1.DataBind();
GridView2.DataBind();
//清空session紀錄
Session.Remove(SealedGlobalPage.SESSIONKEY_INMONEY_WORKID);
}
protected void Page_Load(object sender, EventArgs e)
{
_context = SealedGlobalPage.getContext(this);
if (!Page.IsPostBack)
{
CTools.get所別(iv_cbo所別, _context);
_txtBDate.Text = DateTime.Today.AddMonths(-1).ToString("yyyy/MM/01");
_txtEDate.Text = DateTime.Today.ToString("yyyy/MM/dd");
}
}
/// <summary>
/// 空间动态内线
/// </summary>
/// <returns></returns>
public static string GetZoonActionStr()
{
var roomidArr = new int[] { 90, 95, 99, 100, 101, 110 };
int roomid = roomidArr[CTools.GetRandom(0, roomidArr.Length)];
var baseWord = new List <string>()
{
"在" + "(url=" + HostName + roomid + ")" + "虫虫农场" + "(/url)，玩投资种菜领取了收益",
};
return(baseWord[CTools.GetRandom(0, baseWord.Count)]);
}
