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)]); }