protected void btnGui_ServerClick(object sender, EventArgs e) { //Kiểm tra email if (isEmail(txtEmail.Value) != true) { alert.alert_Error(Page, "Vui Lòng Kiểm tra lại mail của bạn", ""); } else if (txtHoten.Value == "" || txtPhone.Value == "" || txtEmail.Value == "" || txtSubject.Value == "" || txtLoinhan.Value == "") { alert.alert_Error(Page, "Vui lòng nhập đầy đủ thông tin", ""); } else { //Lưu thông tin Lời nhắn khách hàng gửi tbCustomer insert = new tbCustomer(); insert.cus_name = txtHoten.Value; insert.cus_phone = txtPhone.Value; insert.cus_email = txtEmail.Value; insert.cus_title = txtSubject.Value; insert.cus_content = txtLoinhan.Value; insert.cus_date = DateTime.Now; insert.cus_status = false; db.tbCustomers.InsertOnSubmit(insert); db.SubmitChanges(); alert.alert_Success(Page, "Đã Gửi", ""); setNull(); } }
private void btnSave_Click(object sender, EventArgs e) { tbCustomer sp = GetData(); if (sp.Id == Guid.Empty) { sp.Id = Guid.NewGuid(); } db.Customers.Add(sp); db.Complete(); UtilsUI.AlertMessage.Show("Данные успешно сохранены"); }
public tbCustomer GetData() { var d = new tbCustomer(); d.Address = edAdress.Text; d.FIO = edFIO.Text; d.Email = edEmail.Text; d.CreateDate = DateTime.Now; d.CreateUser = Vars.UserId; d.Phone = edPhone.Text; d.Status = 1; return(d); }
//public bool Linq_Them(string image, string link, string slide_title, string slide_title1) //{ // tbSlide insert = new tbSlide(); // insert.slide_title = slide_title; // insert.slide_image = image; // // insert.slide_summary = slide_summary; // insert.slide_date = DateTime.Now; // insert.slide_link = link; // insert.slide_title1 = slide_title1; // insert.hidden = true; // // insert.news_link= // db.tbSlides.InsertOnSubmit(insert); // try // { // db.SubmitChanges(); // return true; // } // catch // { // return false; // } //} //public bool Linq_Sua(int slide_id, string image, string link, string slide_title, string slide_title1) //{ // tbSlide update = db.tbSlides.Where(x => x.slide_id == slide_id).FirstOrDefault(); // update.slide_title = slide_title; // if (image != "x") // update.slide_image = image; // //update.slide_summary = slide_summary; // //update.slide_content = content; // update.slide_link = link; // update.slide_title1 = slide_title1; // try // { // db.SubmitChanges(); // return true; // } // catch // { // return false; // } //} public bool Linq_Xoa(int cus_id) { tbCustomer delete = db.tbCustomers.Where(x => x.cus_id == cus_id).FirstOrDefault(); db.tbCustomers.DeleteOnSubmit(delete); try { db.SubmitChanges(); return(true); } catch { return(false); } }
public ActionResult Delete(int id, tbCustomer customer) { try { // TODO: Add delete logic here using (DatabaseModel db = new DatabaseModel()) { customer = db.tbCustomers.Where(x => x.ID == id).FirstOrDefault(); db.tbCustomers.Remove(customer); db.SaveChanges(); } return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Edit(int id, tbCustomer customer) { try { // TODO: Add update logic here using (DatabaseModel db = new DatabaseModel()) { db.Entry(customer).State = EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(tbCustomer customer) { try { // TODO: Add insert logic here using (DatabaseModel db = new DatabaseModel()) { db.tbCustomers.Add(customer); db.SaveChanges(); } return(RedirectToAction("Index")); } catch (Exception ex) { return(View()); } }
public bool AddOrUpdate(tbCustomer item) { var dao = new CustomerDao(); return(dao.AddOrUpdae(item)); }
public bool AddOrUpdate(tbCustomer item, Guid oldBedId) { var dao = new CustomerDao(); return(dao.AddOrUpdae(item, oldBedId)); }
public bool AddOrUpdate(bool IsAdd, tbCustomer item) { var szServices = new DbHelperEfSql <tbCustomer>(); return(IsAdd ? szServices.Add(item) : szServices.Update(item, c => c.ID == item.ID)); }
public JsonResult AddOrUpdate() { #region 权限控制 int[] iRangePage = { AddPageNodeId, EditPageNodeId, DetailPageNodeId }; int iCurrentPageNodeId = AddPageNodeId; int iCurrentButtonId = (int)EButtonType.Save; var tempNoAuth = Utits.IsOperateAuth(iRangePage, iCurrentPageNodeId, iCurrentButtonId); if (tempNoAuth.ErrorType != 1) { return(Json(tempNoAuth)); } #endregion #region AddOrUpdate Guid ID = RequestParameters.PGuid("ID"); Guid ddlOrgID = RequestParameters.PGuid("ddlOrgID"); string CustomerName = RequestParameters.Pstring("CustomerName"); int Age = RequestParameters.Pint("Age"); int CustomerGender = RequestParameters.Pint("CustomerGender"); string CustomerWedlock = RequestParameters.Pstring("CustomerWedlock"); string CustomerJG = RequestParameters.Pstring("CustomerJG"); string Address = RequestParameters.Pstring("Address"); string Company = RequestParameters.Pstring("Company"); string Phone = RequestParameters.Pstring("Phone"); string CustomerGSR = RequestParameters.Pstring("CustomerGSR"); DateTime?AdmissionDate = RequestParameters.PDateTime("AdmissionDate"); DateTime?DiagnosticDate = RequestParameters.PDateTime("DiagnosticDate"); string CustomerJJYW = RequestParameters.Pstring("CustomerJJYW"); string CustomerJJSW = RequestParameters.Pstring("CustomerJJSW"); int? CustomerYSLX_dic = RequestParameters.PintNull("CustomerYSLX_dic"); string CustomerYYBH = RequestParameters.Pstring("CustomerYYBH"); string CustomerSFWWYY = RequestParameters.Pstring("CustomerSFWWYY"); int? CustomerHLMC_dic = RequestParameters.PintNull("CustomerHLMC_dic"); string CustomerCardID = RequestParameters.Pstring("CustomerCardID"); int? CustomerType_dic = RequestParameters.PintNull("CustomerType_dic"); string CustomerSBKH = RequestParameters.Pstring("CustomerSBKH"); string CustomerMZ = RequestParameters.Pstring("CustomerMZ"); int? CustomerWHCD_dic = RequestParameters.PintNull("CustomerWHCD_dic"); string CustomerZW = RequestParameters.Pstring("CustomerZW"); int CustomerYLJSR = RequestParameters.Pint("CustomerYLJSR"); string CustomerZZDH = RequestParameters.Pstring("CustomerZZDH"); string CustomerYYZT = RequestParameters.Pstring("CustomerYYZT"); string CustomerSFBS = RequestParameters.Pstring("CustomerSFBS"); string CustomerSX = RequestParameters.Pstring("CustomerSX"); string CustomerZYBH = RequestParameters.Pstring("CustomerZYBH"); DateTime?CustomerYYSJ = RequestParameters.PDateTime("CustomerYYSJ"); DateTime?CustomerLYSJ = RequestParameters.PDateTime("CustomerLYSJ"); string CustomerLYYY = RequestParameters.Pstring("CustomerLYYY"); string CustomerYLBZ = RequestParameters.Pstring("CustomerYLBZ"); string CustomerXMPY = GetSpellCode(CustomerName); DateTime?CustomerBrith = RequestParameters.PDateTime("CustomerBrith"); Guid oldBednoID = RequestParameters.PGuid("oldBednoID"); Guid bednoID = RequestParameters.PGuid("bednoID"); string BedNumberName = RequestParameters.Pstring("BedNumberName"); string bednoText = RequestParameters.Pstring("bednoText"); string HeadImg = RequestParameters.Pstring("HeadImg"); string CustomerZZMM = RequestParameters.Pstring("CustomerZZMM"); string CustomerJYCD = RequestParameters.Pstring("CustomerJYCD"); string CustomerDlrXm = RequestParameters.Pstring("CustomerDlrXm"); string CustomerDlrTel = RequestParameters.Pstring("CustomerDlrTel"); string CustomerDlrDz = RequestParameters.Pstring("CustomerDlrDz"); string CustomerDlrGx = RequestParameters.Pstring("CustomerDlrGx"); string CustomerDlrYb = RequestParameters.Pstring("CustomerDlrYb"); string ddlCustomerHJDQ_dic = RequestParameters.Pstring("CustomerHJDQ_dic"); var cBll = new CustomerBll(); #region 判断 if (CustomerName.Length <= 0) { var sRetrunModel = new ResultMessage(); sRetrunModel.ErrorType = 0; sRetrunModel.MessageContent = "姓名不能为空."; return(Json(sRetrunModel)); } //var welfareCentreId = Utits.WelfareCentreID; //if (bednoID != Guid.Empty) //{ // bool isFlagValidation = false; // if (ID == Guid.Empty) // isFlagValidation = cBll.ValidationBedByCustomer(bednoID, welfareCentreId); // else // isFlagValidation = cBll.ValidationBedByCustomer(ID, bednoID, welfareCentreId); // if (!isFlagValidation) // { // var sRetrunModel = new ResultMessage(); // sRetrunModel.ErrorType = 0; // sRetrunModel.MessageContent = "床位已住人."; // return Json(sRetrunModel); // } //} #endregion var item = new tbCustomer(); item.ID = ID; ParamState = "1"; ParamID = item.ID.ToString(); item.Stage = (int)ECustomerType.RuYuan; item.OperateDate = DateTime.Now; item.CustomerName = CustomerName; item.BedNumber = bednoID == Guid.Empty ? "" : bednoText; item.BedID = bednoID; item.CustomerGender = CustomerGender; item.CustomerWedlock = CustomerWedlock; item.CustomerAge = Age; item.CustomerJG = CustomerJG; item.CustomerAddress = Address; item.CustomerCompany = Company; item.CustomerTel = Phone; item.CustomerGSR = CustomerGSR; item.AdmissionDate = AdmissionDate ?? DateTime.Now; item.DiagnosticDate = DiagnosticDate ?? DateTime.Now; item.CustomerCardID = CustomerCardID; item.CustomerType_dic = CustomerType_dic; item.CustomerSBKH = CustomerSBKH; item.CustomerMZ = CustomerMZ; item.CustomerWHCD_dic = CustomerWHCD_dic; item.CustomerZW = CustomerZW; item.CustomerYLJSR = CustomerYLJSR; item.CustomerZZDH = CustomerZZDH; item.CustomerYYZT = CustomerYYZT; item.CustomerSFBS = CustomerSFBS; item.CustomerSX = CustomerSX; item.CustomerXMPY = CustomerXMPY;//姓名拼音 item.CustomerZYBH = CustomerZYBH; item.CustomerYYSJ = CustomerYYSJ; item.CustomerLYSJ = CustomerLYSJ; item.CustomerLYYY = CustomerLYYY; item.CustomerYLBZ = CustomerYLBZ; item.CustomerJJYW = CustomerJJYW; item.CustomerJJSW = CustomerJJSW; item.CustomerYSLX_dic = CustomerYSLX_dic; item.CustomerYYBH = CustomerYYBH; item.CustomerSFWWYY = CustomerSFWWYY; item.CustomerHLMC_dic = CustomerHLMC_dic; item.CustomerBrith = CustomerBrith; item.BedNumberName = BedNumberName; item.CustomerHeadImg = HeadImg; item.CustomerZZMM = CustomerZZMM; item.CustomerJYCD = CustomerJYCD; item.CustomerDlrXm = CustomerDlrXm; item.CustomerDlrTel = CustomerDlrTel; item.CustomerDlrDz = CustomerDlrDz; item.CustomerDlrGx = CustomerDlrGx; item.CustomerDlrYb = CustomerDlrYb; item.CustomerHJDQ_dic = ddlCustomerHJDQ_dic; //item.WelfareCentreID = welfareCentreId; item.WelfareCentreID = ddlOrgID; bool IsFlag = cBll.AddOrUpdate(item, oldBednoID); //if (bednoID != oldBednoID) //{ // //BedStatus 1 有人住,0 没人住 // if (bednoID!=Guid.Empty) // { // var bedBll = new BedBll(); // bool IsBedFlag = bedBll.OperateBedStatus(bednoID,1); // } // if (oldBednoID != Guid.Empty) // { // var bedBll = new BedBll(); // bool IsBedFlag = bedBll.OperateBedStatus(oldBednoID, 0); // } //} if (IsFlag) { var cLog = new LogsBll(); cLog.Log(ParamID, ParamName, ParamState, Utits.CurrentUserID.ToString(), Utits.CurrentRealName.ToString(), Utits.WelfareCentreID.ToString(), Utits.ClientIPAddress.ToString()); var sRetrunModel = new ResultMessage(); sRetrunModel.ErrorType = 1; sRetrunModel.MessageContent = "操作成功."; return(Json(sRetrunModel)); } else { var sRetrunModel = new ResultMessage(); sRetrunModel.ErrorType = 0; sRetrunModel.MessageContent = "操作失败."; return(Json(sRetrunModel)); } #endregion }
public bool AddOrUpdae(tbCustomer item) { try { var isAdd = true; #region var query = _context.Set <tbCustomer>().FirstOrDefault(c => c.ID == item.ID); if (query == null) { isAdd = true; var model = new tbCustomer(); model.ID = Guid.NewGuid(); model.IsValid = 1; model.CreateDate = DateTime.Now; model.Stage = item.Stage; model.OperateDate = item.OperateDate; model.CustomerName = item.CustomerName; model.BedNumber = item.BedNumber; model.BedID = item.BedID; model.CustomerGender = item.CustomerGender; model.CustomerWedlock = item.CustomerWedlock; model.CustomerAge = item.CustomerAge; model.CustomerJG = item.CustomerJG; model.CustomerAddress = item.CustomerAddress; model.CustomerCompany = item.CustomerCompany; model.CustomerTel = item.CustomerTel; model.CustomerGSR = item.CustomerGSR; model.AdmissionDate = item.AdmissionDate ?? DateTime.Now; model.DiagnosticDate = item.DiagnosticDate ?? DateTime.Now; model.CustomerCardID = item.CustomerCardID; model.CustomerType_dic = item.CustomerType_dic; model.CustomerSBKH = item.CustomerSBKH; model.CustomerMZ = item.CustomerMZ; model.CustomerWHCD_dic = item.CustomerWHCD_dic; model.CustomerZW = item.CustomerZW; model.CustomerYLJSR = item.CustomerYLJSR; model.CustomerZZDH = item.CustomerZZDH; model.CustomerYYZT = item.CustomerYYZT; model.CustomerSFBS = item.CustomerSFBS; model.CustomerSX = item.CustomerSX; model.CustomerXMPY = item.CustomerXMPY;//姓名拼音 model.CustomerZYBH = item.CustomerZYBH; model.CustomerYYSJ = item.CustomerYYSJ; model.CustomerLYSJ = item.CustomerLYSJ; model.CustomerLYYY = item.CustomerLYYY; model.CustomerYLBZ = item.CustomerYLBZ; model.CustomerJJYW = item.CustomerJJYW; model.CustomerJJSW = item.CustomerJJSW; model.CustomerYSLX_dic = item.CustomerYSLX_dic; model.CustomerYYBH = item.CustomerYYBH; model.CustomerSFWWYY = item.CustomerSFWWYY; model.CustomerHLMC_dic = item.CustomerHLMC_dic; model.CustomerBrith = item.CustomerBrith; model.BedNumberName = item.BedNumberName; model.CustomerHeadImg = item.CustomerHeadImg; model.CustomerZZMM = item.CustomerZZMM; model.CustomerJYCD = item.CustomerJYCD; model.CustomerDlrXm = item.CustomerDlrXm; model.CustomerDlrTel = item.CustomerDlrTel; model.CustomerDlrDz = item.CustomerDlrDz; model.CustomerDlrGx = item.CustomerDlrGx; model.CustomerDlrYb = item.CustomerDlrYb; model.CustomerHJDQ_dic = item.CustomerHJDQ_dic; model.WelfareCentreID = item.WelfareCentreID; _context.Set <tbCustomer>().Add(model); } else { isAdd = false; query.ID = item.ID; query.Stage = item.Stage; query.OperateDate = item.OperateDate; query.CustomerName = item.CustomerName; query.BedNumber = item.BedNumber; query.BedID = item.BedID; query.CustomerGender = item.CustomerGender; query.CustomerWedlock = item.CustomerWedlock; query.CustomerAge = item.CustomerAge; query.CustomerJG = item.CustomerJG; query.CustomerAddress = item.CustomerAddress; query.CustomerCompany = item.CustomerCompany; query.CustomerTel = item.CustomerTel; query.CustomerGSR = item.CustomerGSR; query.AdmissionDate = item.AdmissionDate ?? DateTime.Now; query.DiagnosticDate = item.DiagnosticDate ?? DateTime.Now; query.CustomerCardID = item.CustomerCardID; query.CustomerType_dic = item.CustomerType_dic; query.CustomerSBKH = item.CustomerSBKH; query.CustomerMZ = item.CustomerMZ; query.CustomerWHCD_dic = item.CustomerWHCD_dic; query.CustomerZW = item.CustomerZW; query.CustomerYLJSR = item.CustomerYLJSR; query.CustomerZZDH = item.CustomerZZDH; query.CustomerYYZT = item.CustomerYYZT; query.CustomerSFBS = item.CustomerSFBS; query.CustomerSX = item.CustomerSX; query.CustomerXMPY = item.CustomerXMPY;//姓名拼音 query.CustomerZYBH = item.CustomerZYBH; query.CustomerYYSJ = item.CustomerYYSJ; query.CustomerLYSJ = item.CustomerLYSJ; query.CustomerLYYY = item.CustomerLYYY; query.CustomerYLBZ = item.CustomerYLBZ; query.CustomerJJYW = item.CustomerJJYW; query.CustomerJJSW = item.CustomerJJSW; query.CustomerYSLX_dic = item.CustomerYSLX_dic; query.CustomerYYBH = item.CustomerYYBH; query.CustomerSFWWYY = item.CustomerSFWWYY; query.CustomerHLMC_dic = item.CustomerHLMC_dic; query.CustomerBrith = item.CustomerBrith; query.BedNumberName = item.BedNumberName; query.CustomerHeadImg = item.CustomerHeadImg; query.CustomerZZMM = item.CustomerZZMM; query.CustomerJYCD = item.CustomerJYCD; query.CustomerDlrXm = item.CustomerDlrXm; query.CustomerDlrTel = item.CustomerDlrTel; query.CustomerDlrDz = item.CustomerDlrDz; query.CustomerDlrGx = item.CustomerDlrGx; query.CustomerDlrYb = item.CustomerDlrYb; query.CustomerHJDQ_dic = item.CustomerHJDQ_dic; query.WelfareCentreID = item.WelfareCentreID; } #endregion _context.SaveChanges(); return(true); } catch (Exception ex) { Console.WriteLine(ex.Message); MessageLog.WriteLog(new LogParameterModel() { ClassName = this.GetType().ToString(), MethodName = "AddOrUpdaeCustomer", MethodParameters = "添加失败", LogLevel = ELogLevel.Warn, Message = ex.Message }); return(false); } }