public static int SaveAimCheckInfo(AimCheckInfoModel model)
{
//定义返回变量
int isSucc = 0;
//ID存在时，更新
if (ConstUtil.EDIT_FLAG_UPDATE.Equals(model.EditFlag))
{
try
{
//执行更新操作
isSucc = AimCheckInfoDBHelper.UpdateAimCheckInfo(model);
}
catch
{
//输出日志
}
}
//插入
else
{
try
{
//执行插入操作
isSucc = AimCheckInfoDBHelper.InsertAimCheckInfo(model);
}
catch
{
//输出日志
}
}
return isSucc;
}
/// <summary>
/// 得到一个 检查的结果
/// </summary>
public static DataTable GetAimCheckRecord(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select p.Checkor,AimNo,AimTitle ,p.id as Cid ,officedba.getEmployeeNameByID(p.Checkor) as CheckorName,CheckContent , AimID,AimTypeID,AimDate,AimStandard,Status,p.CheckMethod , p.CheckDate,p.CheckResult,p.AddOrCut,p.Remark from ");
strSql.Append(" officedba.PlanAim o join officedba.PlanCheck p on o.ID = p.AimID ");
strSql.Append(" where p.ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = ID;
AimCheckInfoModel model = new AimCheckInfoModel();
SqlCommand comm = new SqlCommand();
comm.Parameters.Add(parameters[0]);
comm.CommandText = strSql.ToString();
return SqlHelper.ExecuteSearch(comm);
}
/// <summary>
/// 更新一条数据
/// </summary>
public static int UpdateAimCheckInfo(AimCheckInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update officedba.PlanCheck set ");
strSql.Append("CheckDate=@CheckDate,");
strSql.Append("Checkor=@Checkor,");
strSql.Append("CheckMethod=@CheckMethod,");
strSql.Append("CheckContent=@CheckContent,");
strSql.Append("CheckResult=@CheckResult,");
strSql.Append("remark=@remark,");
strSql.Append("ModifiedDate=@ModifiedDate,");
strSql.Append("ModifiedUserID=@ModifiedUserID,");
strSql.Append("AddOrCut=@AddOrCut");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4),
new SqlParameter("@CheckDate", SqlDbType.DateTime),
new SqlParameter("@Checkor", SqlDbType.Int,4),
new SqlParameter("@CheckMethod", SqlDbType.VarChar,50),
new SqlParameter("@CheckContent", SqlDbType.VarChar,1024),
new SqlParameter("@CheckResult", SqlDbType.VarChar,1024),
new SqlParameter("@remark", SqlDbType.VarChar,1024),
new SqlParameter("@ModifiedDate", SqlDbType.DateTime),
new SqlParameter("@ModifiedUserID", SqlDbType.VarChar,10),
new SqlParameter("@AddOrCut", SqlDbType.Char,1)};
parameters[0].Value = model.ID;
parameters[1].Value = model.CheckDate;
parameters[2].Value = model.Checkor;
parameters[3].Value = model.CheckMethod;
parameters[4].Value = model.CheckContent;
parameters[5].Value = model.CheckResult;
parameters[6].Value = model.remark;
parameters[7].Value = model.ModifiedDate;
parameters[8].Value = model.ModifiedUserID;
parameters[9].Value = model.AddOrCut;
return SqlHelper.ExecuteTransSql(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public static int InsertAimCheckInfo(AimCheckInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into officedba.PlanCheck(");
strSql.Append("CompanyCD,AimID,CheckDate,Checkor,CheckMethod,CheckContent,CheckResult,remark,ModifiedUserID,AddOrCut)");
strSql.Append(" values (");
strSql.Append("@CompanyCD,@AimID,@CheckDate,@Checkor,@CheckMethod,@CheckContent,@CheckResult,@remark,@ModifiedUserID,@AddOrCut)");
strSql.Append(";select @ID =@@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@CompanyCD", SqlDbType.VarChar,8),
new SqlParameter("@AimID", SqlDbType.Int,4),
new SqlParameter("@CheckDate", SqlDbType.DateTime),
new SqlParameter("@Checkor", SqlDbType.Int,4),
new SqlParameter("@CheckMethod", SqlDbType.VarChar,50),
new SqlParameter("@CheckContent", SqlDbType.VarChar,1024),
new SqlParameter("@CheckResult", SqlDbType.VarChar,1024),
new SqlParameter("@remark", SqlDbType.VarChar,1024),
new SqlParameter("@ModifiedUserID", SqlDbType.VarChar,10),
new SqlParameter("@AddOrCut", SqlDbType.Char,1),
new SqlParameter("@ID", SqlDbType.Int,0) };
parameters[0].Value = model.CompanyCD;
parameters[1].Value = model.AimID;
parameters[2].Value = model.CheckDate;
parameters[3].Value = model.Checkor;
parameters[4].Value = model.CheckMethod;
parameters[5].Value = model.CheckContent;
parameters[6].Value = model.CheckResult;
parameters[7].Value = model.remark;
parameters[8].Value = model.ModifiedUserID;
parameters[9].Value = model.AddOrCut;
parameters[10].Direction = ParameterDirection.Output;
SqlHelper.ExecuteTransSql(strSql.ToString(), parameters);
return Convert.ToInt32((parameters[10].Value.ToString()));
}
