/// <summary> /// 增加处理表单实体 /// </summary> /// <param name="wfDealForms">处理表单实体对象实体</param> public static bool Add(WfDealFormsEntity entity) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into WF_DealForms ("); strSql.Append(" FormID, FormIdOuter, FormName, BusinessType, IsDelete)"); strSql.Append(" values ( "); strSql.Append("@FormID, @FormIdOuter, @FormName, @BusinessType, @IsDelete)"); SqlParameter[] parameters = { new SqlParameter("@FormID", SqlDbType.UniqueIdentifier), new SqlParameter("@FormIdOuter", SqlDbType.VarChar), new SqlParameter("@FormName", SqlDbType.NVarChar), new SqlParameter("@BusinessType", SqlDbType.VarChar), new SqlParameter("@IsDelete", SqlDbType.Bit) }; int i = 0; parameters[i++].Value = entity.FormID; parameters[i++].Value = entity.FormIdOuter; parameters[i++].Value = entity.FormName; parameters[i++].Value = entity.BusinessType; parameters[i++].Value = entity.IsDelete; return DataHelper.ExecuteNoneQuery(strSql.ToString(), parameters) > 0; }
/// <summary> /// 插入表单信息 /// </summary> /// <param name="formId">表单id</param> /// <param name="businessType">业务类别</param> /// <param name="formName">表单名称</param> /// <returns></returns> public static bool InsertWfFormInfo(string formId, string businessType, string formName) { var result = false; try { var entity = new WfDealFormsEntity(); entity.FormID = Guid.NewGuid(); entity.FormIdOuter = formId; entity.BusinessType = businessType; entity.FormName = formName; entity.IsDelete = false; result = WfDealFormsBusiness.Add(entity); } catch (Exception ex) { LogWritter.WriteSystemExceptionLog(ex); } return result; }
/// <summary> /// 保存表单信息 /// </summary> /// <param name="formId"></param> /// <param name="formName"></param> /// <param name="businessType"></param> /// <returns></returns> public static bool SaveFormInfo(string formId, string formName, int businessType) { try { var wfDealforms = new WfDealFormsEntity(); // wfDealforms.BusinessType = businessType; wfDealforms.FormID = Guid.NewGuid(); wfDealforms.FormIdOuter = formId; wfDealforms.FormName = formName; wfDealforms.IsDelete = false; return WfDealFormsBusiness.Add(wfDealforms); } catch (Exception ex) { LogWritter.WriteSystemExceptionLog(ex); throw ex; } }
/// <summary> /// 获取实体信息 /// </summary> /// <param name="row">数据行</param> /// <returns></returns> private static WfDealFormsEntity GetEntity(DataRow row) { WfDealFormsEntity entity = new WfDealFormsEntity(); entity.FormID = Guid.Parse(row["FormID"].ToString()); entity.FormIdOuter = row["FormIdOuter"].ToString(); entity.FormName = row["FormName"].ToString(); entity.BusinessType = row["BusinessType"].ToString(); entity.IsDelete = Convert.ToBoolean(row["IsDelete"]); return entity; }
/// <summary> /// 更新处理表单实体 /// </summary> /// <param name="wF_DealForm">处理表单实体</param> /// <returns>bool</returns> public static bool UpdateWfDealForms(WfDealFormsEntity entity) { StringBuilder strSql = new StringBuilder(); strSql.Append("update WF_DealForms set "); strSql.Append("FormID = @FormID, "); strSql.Append("FormIdOuter = @FormIdOuter, "); strSql.Append("FormName = @FormName, "); strSql.Append("BusinessType = @BusinessType, "); strSql.Append("IsDelete = @IsDelete"); strSql.Append(" where "); strSql.Append(" FormID = @FormID "); SqlParameter[] parameters = { new SqlParameter("@FormID", SqlDbType.UniqueIdentifier), new SqlParameter("@FormIdOuter", SqlDbType.VarChar), new SqlParameter("@FormName", SqlDbType.NVarChar), new SqlParameter("@BusinessType", SqlDbType.Int), new SqlParameter("@IsDelete", SqlDbType.Bit) }; int i = 0; parameters[i++].Value = entity.FormID; parameters[i++].Value = entity.FormIdOuter; parameters[i++].Value = entity.FormName; parameters[i++].Value = entity.BusinessType; parameters[i++].Value = entity.IsDelete; return DataHelper.ExecuteNoneQuery(strSql.ToString(), parameters) > 0; }