public ActionResult Edit() { Business.Sys_ContractCustomer Sys_ContractCustomer = new Business.Sys_ContractCustomer(); Model.ContractCustomer ContractCustomer = Sys_ContractCustomer.GetInfo(Request["ID"]); ViewData["GetSexList"] = GetSexList(ContractCustomer.Sex); ViewData["GetTypeList"] = GetTypeList(ContractCustomer.IsSign); ViewData["ID"] = Request["ID"]; return(View(ContractCustomer)); }
public ActionResult EditInfo(Model.ContractCustomer ContractCustomer) { Business.Sys_ContractCustomer Sys_ContractCustomer = new Business.Sys_ContractCustomer(); ViewData["GetSexList"] = GetSexList(); ViewData["GetTypeList"] = GetTypeList(); if (Sys_ContractCustomer.UpdateInfo(ContractCustomer)) { return(Content("1")); } return(Content("0")); }
public bool AddInfo(Model.ContractCustomer ContractCustomer) { const string sql = @"INSERT INTO ContractCustomer(RealName,Sex,phone,Address,CooperationDate,DockingProject,DockingprojectLeader,IsSign) VALUES(@RealName,@Sex,@phone,@Address,@CooperationDate,@DockingProject,@DockingprojectLeader,@IsSign)"; return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new { ContractCustomer.RealName, ContractCustomer.Sex, ContractCustomer.phone, ContractCustomer.Address, ContractCustomer.CooperationDate, ContractCustomer.DockingProject, ContractCustomer.DockingprojectLeader, ContractCustomer.IsSign, }))); }
public bool UpdateInfo(Model.ContractCustomer ContractCustomer) { const string sql = @"UPDATE ContractCustomer SET RealName=@RealName,Sex=@Sex,phone=@phone,Address=@Address,CooperationDate=@CooperationDate,DockingProject=@DockingProject, DockingprojectLeader=@DockingprojectLeader,IsSign=@IsSign WHERE ID=@ID"; return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new { ContractCustomer.RealName, ContractCustomer.Sex, ContractCustomer.phone, ContractCustomer.Address, ContractCustomer.CooperationDate, ContractCustomer.DockingProject, ContractCustomer.DockingprojectLeader, ContractCustomer.IsSign, ContractCustomer.ID, }))); }