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