private void EditCustomer() { var id = ParseInt(Utility.Decrypt(_key)); var obj = CustomerInstance.Find(f => f.id == id); if (null == obj) { ShowNotification("./customers.aspx", "Error: could not find the customer.", false); } else { BuilldCustomer(obj); var chk = CustomerInstance.Find(f => f.Code.Equals(obj.Code) && f.id != id); if (null != chk) { ShowNotification("./customer_new.aspx", "Error: there have a same customer code exists.", false); } else { Update(obj); // 保存历史记录 SaveHistory(new TB_AccountHistory() { ActionId = ActionInstance.Find(f => f.Name.Equals("EditCustomer")).id, ObjectA = CustomerInstance.ToString(obj) }); ShowNotification("./customers.aspx", "You have changed the customer: " + CustomerInstance.ToString(obj) + "."); } } }
/// <summary> /// 处理查询客户信息的请求 /// </summary> private void HandleCustomerQuery() { var ret = "[]"; switch (cmd) { case "query": // 查询Name或Code var query = CustomerInstance.FindList(f => (f.Name.IndexOf(data) >= 0 || f.Code.IndexOf(data) >= 0) && f.Delete == false); ret = JsonConverter.ToJson(query); break; case "customer": var id = ParseInt(Utility.Decrypt(data)); var c = CustomerInstance.FindList(f => f.id == id && f.Delete == false); ret = JsonConverter.ToJson(c); break; case "login": // 客户登陆 ret = HandleCustomerLogin(); break; } ResponseJson(ret); }
/// <summary> /// 关闭已打开的bll instances /// </summary> private void CloseBlls() { TrackerPositionInstance.Close(); StorageInstance.Close(); PositionInstance.Close(); EquipmentInstance.Close(); EposInstance.Close(); DataInstance.Close(); DailyInstance.Close(); CustomerInstance.Close(); AlarmInstance.Close(); }
private void ShowEdit() { var obj = CustomerInstance.Find(f => f.id == ParseInt(Utility.Decrypt(_key))); if (null == obj) { ShowNotification("./customers.aspx", "Error: paramenter error, cannot edit the customer.", false); } else { txtAddress.Value = obj.Address; txtCode.Value = obj.Code; txtIdCard.Value = obj.IdCard; txtName.Value = obj.Name; txtPhone.Value = obj.Phone; } }
private void ShowCustomers() { var totalRecords = 0; var pageIndex = "" == hidPageIndex.Value ? 1 : int.Parse(hidPageIndex.Value); pageIndex = (0 >= pageIndex ? 1 : pageIndex); var list = CustomerInstance.FindPageList <TB_Customer>(pageIndex, PageSize, out totalRecords, f => f.Name.IndexOf(txtName.Value.Trim()) >= 0 && f.Code.IndexOf(txtCode.Value.Trim()) >= 0 && f.Delete == false, "Name"); var totalPages = totalRecords / PageSize + (totalRecords % PageSize > 0 ? 1 : 0); string html = ""; if (totalRecords < 1) { html = "<tr><td colspan=\"7\">No records, You can change the condition and try again " + "or <a href=\"./customer_new.aspx\">ADD</a> some customer's informations.</td></tr>"; } else { var cnt = (pageIndex - 1) * PageSize; foreach (var obj in list) { cnt++; var id = Utility.UrlEncode(Utility.Encrypt(obj.id.ToString())); html += "<tr>" + "<td style=\"text-align: center;\"><input type=\"checkbox\" id=\"cb_" + id + "\" /></td>" + "<td style=\"text-align: center;\">" + cnt + "</td>" + "<td><a href=\"./customer_new.aspx?key=" + id + "\" >" + obj.Name + "</a></td>" + "<td>" + obj.Code + "</td>" + "<td>" + obj.Phone + "</td>" + "<td>" + obj.Fax + "</td>" + "<td>" + obj.Address + "</td>" + "<td></td>" + "</tr>"; } } tbodyBody.InnerHtml = html; divPagging.InnerHtml = ""; if (totalRecords > 0) { ShowPaggings(pageIndex, totalPages, totalRecords, "./customers.aspx", divPagging); } }
private string HandleCustomerLogin() { var ret = "{\"status\":-1,\"desc\":\"error\"}"; var tmp = data.Trim().Split(new char[] { ',' }); var uid = tmp[0].Trim(); if (uid.Length > 20) { uid = uid.Substring(0, 20); } var pwd = tmp[1].ToUpper().Trim(); if (pwd.Length > 32) { pwd = pwd.Substring(0, 32); } var query = CustomerInstance.FindList(f => (f.Code.Equals(uid) || f.Phone.IndexOf(uid) >= 0) && f.Delete == false); var guest = query.Count() > 0 ? query.FirstOrDefault() : null; if (null != guest) { if (guest.Password.Equals(pwd)) { ret = "{\"status\":0,\"desc\":\"success\"}"; CustomerInstance.Update(f => f.id == guest.id, update => { update.SignInTime = DateTime.Now; update.SignInIP = Utility.GetClientIP(ctx); }); ctx.Session[Utility.SessionNameCustomer] = guest; } else { ret = "{\"status\":-1,\"desc\":\"Password error.\"}"; } } else { ret = "{\"status\":-1,\"desc\":\"Not exist phone number.\"}"; } return(ret); }
protected void btDelete_Click(object sender, EventArgs e) { if (!HasSessionLose) { if ("" != hidID.Value) { var ids = GetIdList(hidID.Value.Split(new char[] { ',' })); var list = CustomerInstance.FindList(f => ids.Contains(f.id) && f.Delete == false); foreach (var obj in list) { obj.Delete = true; Update(obj); SaveHistory(new TB_AccountHistory { ActionId = ActionInstance.Find(f => f.Name.Equals("DeleteCustomer")).id, ObjectA = CustomerInstance.ToString(obj) }); } ShowNotification("./customers.aspx", "Success: You have delete " + ids.Count() + " customer(s)."); } } }
private void NewCustomer() { var obj = CustomerInstance.Find(f => f.Code.Equals(txtCode.Value.Trim())); if (null != obj) { ShowNotification("./customer_new.aspx", "Error: same customer number exists.", false); } else { obj = CustomerInstance.GetObject(); BuilldCustomer(obj); CustomerInstance.Add(obj); // 保存历史记录 SaveHistory(new TB_AccountHistory() { ActionId = ActionInstance.Find(f => f.Name.Equals("AddCustomer")).id, ObjectA = CustomerInstance.ToString(obj) }); ShowNotification("./customer_new.aspx", "You added a new customer into system."); } }
/// <summary> /// Save customer record /// </summary> public static void SaveCustomer(bool IsNew, CustomerInstance objParams) { BrightPlatformEntities m_objBrightPlatformEntity = new BrightPlatformEntities(UserSession.EntityConnection); var objCustomer = m_objBrightPlatformEntity.customers.CreateObject(); if (!IsNew) { objCustomer = null; objCustomer = m_objBrightPlatformEntity.customers.Where(objField => objField.id == objParams.id).SingleOrDefault(); } else objCustomer.created_date = DateTime.Now; objCustomer.customer_name = objParams.customer_name; objCustomer.org_no = objParams.org_no; objCustomer.reference_no = objParams.reference_no; objCustomer.disabled = objParams.active == true? "0": "1"; objCustomer.owner = objParams.owner_name; //objCustomer.address = objParams.address; objCustomer.description = objParams.description; objCustomer.modified_by = UserSession.CurrentUser.UserId; objCustomer.modified_date = DateTime.Now; if (IsNew) m_objBrightPlatformEntity.customers.AddObject(objCustomer); m_objBrightPlatformEntity.SaveChanges(); }