/// <summary>
/// 增加一条数据 & 增加一条Solution
/// </summary>
public int Add(MES.Model.Q_Review_ProbDuty model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("declare @dutyid int");
strSql.Append(";insert into Q_Review_ProbDuty(");
strSql.Append("RequestId,ImproveTarget,DutyDept,DutyEmp,ReqFinishDate)");
strSql.Append(" values (");
strSql.Append("@RequestId,@ImproveTarget,@DutyDept,@DutyEmp,@ReqFinishDate)");
strSql.Append(";select @dutyid= @@IDENTITY;");
strSql.Append("insert into Q_Review_Solution(");
strSql.Append("RequestId, DutyId, ActionEmp, DisagreeState , SlnState)");
strSql.Append(" values (");
strSql.Append("@RequestId,@dutyid,@ActionEmp,'未提交','未提交措施')");
strSql.Append(";select @dutyid;");
SqlParameter[] parameters =
{
new SqlParameter("@RequestId", SqlDbType.Int, 8),
new SqlParameter("@ImproveTarget", SqlDbType.VarChar, 100),
new SqlParameter("@DutyDept", SqlDbType.VarChar, 20),
new SqlParameter("@DutyEmp", SqlDbType.VarChar, 20),
new SqlParameter("@ReqFinishDate", SqlDbType.DateTime),
new SqlParameter("@ActionEmp", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.RequestId;
parameters[1].Value = model.ImproveTarget;
parameters[2].Value = model.DutyDept;
parameters[3].Value = model.DutyEmp;
parameters[4].Value = model.ReqFinishDate;
parameters[5].Value = model.DutyEmp;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MES.Model.Q_Review_ProbDuty model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Q_Review_ProbDuty set ");
strSql.Append("ImproveTarget=@ImproveTarget,");
strSql.Append("DutyDept=@DutyDept,");
strSql.Append("DutyEmp=@DutyEmp,");
strSql.Append("ReqFinishDate=@ReqFinishDate");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@ImproveTarget", SqlDbType.VarChar, 100),
new SqlParameter("@DutyDept", SqlDbType.VarChar, 20),
new SqlParameter("@DutyEmp", SqlDbType.VarChar, 20),
new SqlParameter("@ReqFinishDate", SqlDbType.DateTime),
new SqlParameter("@RequestId", SqlDbType.Int, 4),
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = model.ImproveTarget;
parameters[1].Value = model.DutyDept;
parameters[2].Value = model.DutyEmp;
parameters[3].Value = model.ReqFinishDate;
parameters[4].Value = model.RequestId;
parameters[5].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MES.Model.Q_Review_ProbDuty DataRowToModel(DataRow row)
{
MES.Model.Q_Review_ProbDuty model = new MES.Model.Q_Review_ProbDuty();
if (row != null)
{
if (row["RequestId"] != null && row["RequestId"].ToString() != "")
{
model.RequestId = int.Parse(row["RequestId"].ToString());
}
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["ImproveTarget"] != null)
{
model.ImproveTarget = row["ImproveTarget"].ToString();
}
if (row["DutyDept"] != null)
{
model.DutyDept = row["DutyDept"].ToString();
}
if (row["DutyEmp"] != null)
{
model.DutyEmp = row["DutyEmp"].ToString();
}
if (row["ReqFinishDate"] != null && row["ReqFinishDate"].ToString() != "")
{
model.ReqFinishDate = DateTime.Parse(row["ReqFinishDate"].ToString());
}
if (row["Mark"] != null)
{
model.Mark = Convert.ToInt16(row["Mark"]);
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MES.Model.Q_Review_ProbDuty GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 RequestId,Id,ImproveTarget,DutyDept,DutyEmp,ReqFinishDate,(select count(1) from Q_Review_Solution where DutyId=Id and isnull(DisagreeState,'')<>'NG')Mark from Q_Review_ProbDuty ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
MES.Model.Q_Review_ProbDuty model = new MES.Model.Q_Review_ProbDuty();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
