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