Example #1
0
        /// <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;
        }
Example #2
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;
 }
Example #3
0
 /// <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;
     }
 }
Example #4
0
        /// <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;
        }
Example #5
0
        /// <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;
        }