public ActionResult Create(Company company) { if (ModelState.IsValid) { company.CreateDate = DateTime.Now; if(Biz.CompanieSave(company)) return RedirectToAction("Index"); } return View(company); }
/// <summary> /// 详情 /// </summary> /// <param name="Id"></param> /// <returns></returns> public Company CompanieDetail(int Id) { IList<SqlParameter> arrParameter=new List<SqlParameter>(); arrParameter.Add(new SqlParameter{ParameterName="Id",SqlValue=Id,SqlDbType=SqlDbType.Int}); string sql = "SELECT * FROM Companies WHERE Id=@Id"; DataTable dtCompanie = SqlHelper.GetTable(CommandType.Text, sql, arrParameter.ToArray())[0]; Company company = new Company(); foreach (DataRow dr in dtCompanie.Rows) { company.Id = Functions.ToConvert<int>(dr["Id"]); company.Name = Functions.ToConvert<string>(dr["Name"]); company.Address = Functions.ToConvert<string>(dr["Address"]); company.UserToState = (UserToState)Enum.Parse(typeof(UserToState), Functions.ToConvert<string>(dr["UserToState"])); company.WorkToDate = Functions.ToConvert<string>(dr["WorkToDate"]); company.WorkToDateString = Functions.ToConvert<string>(dr["WorkToDateString"]); company.CreateDate = Functions.ToConvert<DateTime>(dr["CreateDate"]); } return company; }
/// <summary> /// 更新 /// </summary> /// <param name="company"></param> /// <returns></returns> public bool CompanieUpdate(Company company) { return dal.CompanieUpdate(company); }
/// <summary> /// 保存 /// </summary> /// <param name="comany"></param> /// <returns></returns> public bool CompanieSave(Company comany) { return dal.CompanieSave(comany); }
public bool CompanieUpdate(Company company) { throw new NotImplementedException(); }
/// <summary> /// 保存 /// </summary> /// <param name="comany"></param> /// <returns></returns> public bool CompanieSave(Company company) { IList<SqlParameter> arrParameter = new List<SqlParameter>(); arrParameter.Add(new SqlParameter{ ParameterName="Name", SqlValue = company.Name }); arrParameter.Add(new SqlParameter{ ParameterName="Address", SqlValue = company.Address }); arrParameter.Add(new SqlParameter{ SqlValue = company.UserToState, ParameterName="UserToState" }); arrParameter.Add(new SqlParameter{ SqlValue = company.WorkToDate, ParameterName="WorkToDate" }); arrParameter.Add(new SqlParameter{ SqlValue = company.WorkToDateString, ParameterName="WorkToDateString" }); arrParameter.Add(new SqlParameter{ SqlValue = company.CreateDate, ParameterName="CreateDate" }); string sql = "INSERT INTO Companies VALUES(@Name,@Address,@UserToState,@WorkToDate,@WorkToDateString,@CreateDate)"; if (SqlHelper.ExecteNonQueryText(sql, arrParameter.ToArray()) > 0) return true; else return false; }
/// <summary> /// 更新 /// </summary> /// <param name="company"></param> /// <returns></returns> public bool CompanieUpdate(Company company) { IList<SqlParameter> arrParameter = new List<SqlParameter>(); arrParameter.Add(new SqlParameter { ParameterName = "Id", SqlValue = company.Id }); arrParameter.Add(new SqlParameter { ParameterName = "Name", SqlValue = company.Name }); arrParameter.Add(new SqlParameter { ParameterName = "Address", SqlValue = company.Address }); arrParameter.Add(new SqlParameter { SqlValue = company.UserToState, ParameterName = "UserToState" }); arrParameter.Add(new SqlParameter { SqlValue = company.WorkToDate, ParameterName = "WorkToDate" }); arrParameter.Add(new SqlParameter { SqlValue = company.WorkToDateString, ParameterName = "WorkToDateString" }); string sql = "Update Companies SET Name=@Name,Address=@Address,UserToState=@UserToState,WorkToDate=@WorkToDate,WorkToDateString=@WorkToDateString WHERE Id=@Id"; if (SqlHelper.ExecteNonQueryText(sql, arrParameter.ToArray()) > 0) return true; else return false; }