/// <summary> /// 增加流程意见表基本信息 /// </summary> /// <param name="wFOpinion">流程意见表基本信息对象实体</param> public static bool Add(WFOpinionEntity entity) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into WF_Opinion ("); strSql.Append(" Guid, WfStateId, WfStateName, InstanceID, UserId, UserName, CreateTime, Opinion, DeptId, DeptName, FormID, Status)"); strSql.Append(" values ( "); strSql.Append("@Guid, @WfStateId, @WfStateName, @InstanceID, @UserId, @UserName, @CreateTime, @Opinion, @DeptId, @DeptName, @FormID, @Status)"); SqlParameter[] parameters = { new SqlParameter("@Guid", SqlDbType.UniqueIdentifier), new SqlParameter("@WfStateId", SqlDbType.UniqueIdentifier), new SqlParameter("@WfStateName", SqlDbType.NVarChar), new SqlParameter("@InstanceID", SqlDbType.UniqueIdentifier), new SqlParameter("@UserId", SqlDbType.UniqueIdentifier), new SqlParameter("@UserName", SqlDbType.NVarChar), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@Opinion", SqlDbType.NVarChar), new SqlParameter("@DeptId", SqlDbType.UniqueIdentifier), new SqlParameter("@DeptName", SqlDbType.NVarChar), new SqlParameter("@FormID", SqlDbType.UniqueIdentifier), new SqlParameter("@Status", SqlDbType.Int) }; int i = 0; parameters[i++].Value = entity.Guid; parameters[i++].Value = entity.WfStateId; parameters[i++].Value = entity.WfStateName; parameters[i++].Value = entity.InstanceID; parameters[i++].Value = entity.UserId; parameters[i++].Value = entity.UserName; if (entity.CreateTime == DateTime.MinValue) entity.CreateTime = (DateTime)SqlDateTime.MinValue; parameters[i++].Value = entity.CreateTime; parameters[i++].Value = entity.Opinion; parameters[i++].Value = entity.DeptId; parameters[i++].Value = entity.DeptName; parameters[i++].Value = entity.FormID; parameters[i++].Value = entity.Status; return DataHelper.ExecuteNoneQuery(strSql.ToString(), parameters) > 0; }
/// <summary> /// 获取实体信息 /// </summary> /// <param name="row">数据行</param> /// <returns></returns> public static WFOpinionEntity GetEntity(DataRow row) { WFOpinionEntity entity = new WFOpinionEntity(); if (row["Guid"] != DBNull.Value) entity.Guid = Guid.Parse(row["Guid"].ToString()); if (row["WfStateId"] != DBNull.Value) entity.WfStateId = Guid.Parse(row["WfStateId"].ToString()); entity.WfStateName = row["WfStateName"].ToString(); if (row["InstanceID"] != DBNull.Value) entity.InstanceID = Guid.Parse(row["InstanceID"].ToString()); if (row["UserId"] != DBNull.Value) entity.UserId = Guid.Parse(row["UserId"].ToString()); entity.UserName = row["UserName"].ToString(); if (row["CreateTime"] != DBNull.Value) entity.CreateTime = Convert.ToDateTime(row["CreateTime"]); entity.Opinion = row["Opinion"].ToString(); if (row["DeptId"] != DBNull.Value) entity.DeptId = Guid.Parse(row["DeptId"].ToString()); entity.DeptName = row["DeptName"].ToString(); if (row["FormID"] != DBNull.Value) entity.FormID = Guid.Parse(row["FormID"].ToString()); if (row["Status"] != DBNull.Value) entity.Status = Convert.ToInt32(row["Status"]); return entity; }
/// <summary> /// 更新流程意见表基本信息 /// </summary> /// <param name="wF_Opinion">流程意见表基本信息</param> /// <returns>bool</returns> public static bool Update(WFOpinionEntity entity) { StringBuilder strSql = new StringBuilder(); strSql.Append("update WF_Opinion set "); strSql.Append("Guid = @Guid, "); strSql.Append("WfStateId = @WfStateId, "); strSql.Append("WfStateName = @WfStateName, "); strSql.Append("InstanceID = @InstanceID, "); strSql.Append("UserId = @UserId, "); strSql.Append("UserName = @UserName, "); strSql.Append("CreateTime = @CreateTime, "); strSql.Append("Opinion = @Opinion, "); strSql.Append("DeptId = @DeptId, "); strSql.Append("DeptName = @DeptName, "); strSql.Append("FormID = @FormID, "); strSql.Append("Status = @Status"); strSql.Append(" where "); strSql.Append(" Guid = @Guid "); SqlParameter[] parameters = { new SqlParameter("@Guid", SqlDbType.UniqueIdentifier), new SqlParameter("@WfStateId", SqlDbType.UniqueIdentifier), new SqlParameter("@WfStateName", SqlDbType.NVarChar), new SqlParameter("@InstanceID", SqlDbType.UniqueIdentifier), new SqlParameter("@UserId", SqlDbType.UniqueIdentifier), new SqlParameter("@UserName", SqlDbType.NVarChar), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@Opinion", SqlDbType.NVarChar), new SqlParameter("@DeptId", SqlDbType.UniqueIdentifier), new SqlParameter("@DeptName", SqlDbType.NVarChar), new SqlParameter("@FormID", SqlDbType.UniqueIdentifier), new SqlParameter("@Status", SqlDbType.Int) }; int i = 0; parameters[i++].Value = entity.Guid; parameters[i++].Value = entity.WfStateId; parameters[i++].Value = entity.WfStateName; parameters[i++].Value = entity.InstanceID; parameters[i++].Value = entity.UserId; parameters[i++].Value = entity.UserName; if (entity.CreateTime == DateTime.MinValue) entity.CreateTime = (DateTime)SqlDateTime.MinValue; parameters[i++].Value = entity.CreateTime; parameters[i++].Value = entity.Opinion; parameters[i++].Value = entity.DeptId; parameters[i++].Value = entity.DeptName; parameters[i++].Value = entity.FormID; parameters[i++].Value = entity.Status; return DataHelper.ExecuteNoneQuery(strSql.ToString(), parameters) > 0; }