/// <summary>
/// 得到一个对象实体
/// </summary>
public DigiPower.Onlinecol.Standard.Model.T_WorkFlowDoResult_MDL GetModel(int WorkFlowDoResultID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 WorkFlowDoResultID,WorkFlowDefineID,DoUserID,DoDateTime,DoResult,DoRemark,DoCellPath,WorkFlowID,ArchiveID,SingleProjectID,FileListID from T_WorkFlowDoResult ");
strSql.Append(" where WorkFlowDoResultID=@WorkFlowDoResultID ");
SqlParameter[] parameters =
{
new SqlParameter("@WorkFlowDoResultID", SqlDbType.Int, 8)
};
parameters[0].Value = WorkFlowDoResultID;
DigiPower.Onlinecol.Standard.Model.T_WorkFlowDoResult_MDL model = new DigiPower.Onlinecol.Standard.Model.T_WorkFlowDoResult_MDL();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["WorkFlowDoResultID"].ToString() != "")
{
model.WorkFlowDoResultID = int.Parse(ds.Tables[0].Rows[0]["WorkFlowDoResultID"].ToString());
}
if (ds.Tables[0].Rows[0]["WorkFlowDefineID"].ToString() != "")
{
model.WorkFlowDefineID = int.Parse(ds.Tables[0].Rows[0]["WorkFlowDefineID"].ToString());
}
if (ds.Tables[0].Rows[0]["DoUserID"].ToString() != "")
{
model.DoUserID = int.Parse(ds.Tables[0].Rows[0]["DoUserID"].ToString());
}
if (ds.Tables[0].Rows[0]["DoDateTime"].ToString() != "")
{
model.DoDateTime = DateTime.Parse(ds.Tables[0].Rows[0]["DoDateTime"].ToString());
}
model.DoResult = ds.Tables[0].Rows[0]["DoResult"].ToString();
model.DoRemark = ds.Tables[0].Rows[0]["DoRemark"].ToString();
model.DoCellPath = ds.Tables[0].Rows[0]["DoCellPath"].ToString();
if (ds.Tables[0].Rows[0]["WorkFlowID"].ToString() != "")
{
model.WorkFlowID = int.Parse(ds.Tables[0].Rows[0]["WorkFlowID"].ToString());
}
if (ds.Tables[0].Rows[0]["ArchiveID"].ToString() != "")
{
model.ArchiveID = int.Parse(ds.Tables[0].Rows[0]["ArchiveID"].ToString());
}
if (ds.Tables[0].Rows[0]["SingleProjectID"].ToString() != "")
{
model.SingleProjectID = int.Parse(ds.Tables[0].Rows[0]["SingleProjectID"].ToString());
}
if (ds.Tables[0].Rows[0]["FileListID"].ToString() != "")
{
model.FileListID = int.Parse(ds.Tables[0].Rows[0]["FileListID"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(DigiPower.Onlinecol.Standard.Model.T_WorkFlowDoResult_MDL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_WorkFlowDoResult set ");
strSql.Append("WorkFlowDefineID=@WorkFlowDefineID,");
strSql.Append("DoUserID=@DoUserID,");
strSql.Append("DoDateTime=@DoDateTime,");
strSql.Append("DoResult=@DoResult,");
strSql.Append("DoRemark=@DoRemark,");
strSql.Append("DoCellPath=@DoCellPath,");
strSql.Append("WorkFlowID=@WorkFlowID,");
strSql.Append("ArchiveID=@ArchiveID,");
strSql.Append("SingleProjectID=@SingleProjectID,");
strSql.Append("FileListID=@FileListID");
strSql.Append(" where WorkFlowDoResultID=@WorkFlowDoResultID ");
SqlParameter[] parameters =
{
new SqlParameter("@WorkFlowDoResultID", SqlDbType.Int, 8),
new SqlParameter("@WorkFlowDefineID", SqlDbType.Int, 8),
new SqlParameter("@DoUserID", SqlDbType.Int, 8),
new SqlParameter("@DoDateTime", SqlDbType.DateTime),
new SqlParameter("@DoResult", SqlDbType.NVarChar, 50),
new SqlParameter("@DoRemark", SqlDbType.NVarChar, 500),
new SqlParameter("@DoCellPath", SqlDbType.NVarChar, 250),
new SqlParameter("@WorkFlowID", SqlDbType.Int, 8),
new SqlParameter("@ArchiveID", SqlDbType.Int, 8),
new SqlParameter("@SingleProjectID", SqlDbType.Int, 8),
new SqlParameter("@FileListID", SqlDbType.Int, 8)
};
parameters[0].Value = model.WorkFlowDoResultID;
parameters[1].Value = model.WorkFlowDefineID;
parameters[2].Value = model.DoUserID;
parameters[3].Value = model.DoDateTime;
parameters[4].Value = model.DoResult;
parameters[5].Value = model.DoRemark;
parameters[6].Value = model.DoCellPath;
parameters[7].Value = model.WorkFlowID;
parameters[8].Value = model.ArchiveID;
parameters[9].Value = model.SingleProjectID;
parameters[10].Value = model.FileListID;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(DigiPower.Onlinecol.Standard.Model.T_WorkFlowDoResult_MDL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_WorkFlowDoResult(");
strSql.Append("WorkFlowDefineID,DoUserID,DoDateTime,DoResult,DoRemark,DoCellPath, WorkFlowID,ArchiveID,SingleProjectID,FileListID)");
strSql.Append(" values (");
strSql.Append("@WorkFlowDefineID,@DoUserID,@DoDateTime,@DoResult,@DoRemark,@DoCellPath,@WorkFlowID,@ArchiveID,@SingleProjectID,@FileListID)");
SqlParameter[] parameters =
{
new SqlParameter("@WorkFlowDefineID", SqlDbType.Int, 8),
new SqlParameter("@DoUserID", SqlDbType.Int, 8),
new SqlParameter("@DoDateTime", SqlDbType.DateTime),
new SqlParameter("@DoResult", SqlDbType.NVarChar, 50),
new SqlParameter("@DoRemark", SqlDbType.NVarChar, 500),
new SqlParameter("@DoCellPath", SqlDbType.NVarChar, 250),
new SqlParameter("@WorkFlowID", SqlDbType.Int, 8),
new SqlParameter("@ArchiveID", SqlDbType.Int, 8),
new SqlParameter("@SingleProjectID", SqlDbType.Int, 8),
new SqlParameter("@FileListID", SqlDbType.Int, 8)
};
parameters[0].Value = model.WorkFlowDefineID;
parameters[1].Value = model.DoUserID;
parameters[2].Value = model.DoDateTime;
parameters[3].Value = model.DoResult;
parameters[4].Value = model.DoRemark;
parameters[5].Value = model.DoCellPath;
parameters[6].Value = model.WorkFlowID;
parameters[7].Value = model.ArchiveID;
parameters[8].Value = model.SingleProjectID;
parameters[9].Value = model.FileListID;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
