/// <summary>
        /// 修改自定义表单
        /// </summary>
        /// <param name="model"></param>
        /// <param name="sonModel"></param>
        /// <param name="strMsg"></param>
        /// <returns></returns>
        public static bool EditTable(CustomTableModel model, List<StructTable> sonModel, out string strMsg)
        {
            bool isSucc = false;//是否添加成功
            strMsg = "";
            string strSql = "delete from defdba.StructTable where  TableID=@TableID ";
            SqlParameter[] paras = { new SqlParameter("@TableID", model.ID) };
            TransactionManager tran = new TransactionManager();
            tran.BeginTransaction();
            try
            {

                EidtCustomTable(model, tran);
                SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, strSql.ToString(), paras);
                AddStructTable(sonModel, Convert.ToInt32(model.ID), tran);
                tran.Commit();
                isSucc = true;
                strMsg = "保存成功!";
            }
            catch (Exception ex)
            {
                tran.Rollback();
                strMsg = "保存失败,请联系系统管理员!";
                throw ex;
            }
            return isSucc;
        }
 /// <summary>
 /// 添加自定义表单
 /// </summary>
 /// <returns></returns>
 public static int AddTable(CustomTableModel model, List<StructTable> sonModel, out string strMsg)
 {
     int TableID = 0;
     strMsg = "";
     //判断单据编号是否存在
     if (!Exists(model.CompanyCD, model.CustomTableName))
     {
         TransactionManager tran = new TransactionManager();
         tran.BeginTransaction();
         try
         {
             TableID = AddCustomTable(model, tran);
             AddStructTable(sonModel, TableID, tran);
             tran.Commit();
             strMsg = "保存成功!";
         }
         catch (Exception ex)
         {
             tran.Rollback();
             strMsg = "保存失败,请联系系统管理员!";
             throw ex;
         }
     }
     else
     {
         strMsg = "该表名已被使用,请输入未使用的表名!";
     }
     return TableID;
 }
        /// <summary>
        /// 修改表信息
        /// </summary>
        /// <param name="model"></param>
        /// <param name="tran"></param>
        public static void EidtCustomTable(CustomTableModel model, TransactionManager tran)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update defdba.CustomTable set ");
            strSql.Append("CompanyCD=@CompanyCD,");
            strSql.Append("CustomTableName=@CustomTableName,");
            strSql.Append("ParentID=@ParentID,");
            strSql.Append("ColumnNumber=@ColumnNumber,");
            strSql.Append("AliasTableName=@AliasTableName,");
            strSql.Append("totalFlag=@totalFlag,");
            strSql.Append("IsDic=@IsDic");
            strSql.Append(" where ID=@ID ");
            SqlParameter[] parameters = {
					new SqlParameter("@ID", SqlDbType.Int,4),
					new SqlParameter("@CompanyCD", SqlDbType.VarChar,50),
					new SqlParameter("@CustomTableName", SqlDbType.VarChar,100),
                    new SqlParameter("@ParentID", SqlDbType.Int,4),
                    new SqlParameter("@ColumnNumber", SqlDbType.Int,4),
					new SqlParameter("@AliasTableName", SqlDbType.VarChar,300),
					new SqlParameter("@totalFlag", SqlDbType.Int),
					new SqlParameter("@IsDic", SqlDbType.Int)};
            parameters[0].Value = model.ID;
            parameters[1].Value = model.CompanyCD;
            parameters[2].Value = model.CustomTableName;
            parameters[3].Value = model.ParentId;
            parameters[4].Value = model.ColumnNumber;
            parameters[5].Value = model.AliasTableName;
            parameters[6].Value = model.totalFlag;
            parameters[7].Value = model.IsDic;
            SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, strSql.ToString(), parameters);
        }
        /// <summary>
        /// 添加表信息
        /// </summary>
        /// <param name="model"></param>
        /// <param name="tran"></param>
        /// <returns></returns>
        public static int AddCustomTable(CustomTableModel model, TransactionManager tran)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into defdba.CustomTable(");
            strSql.Append("CompanyCD,CustomTableName,AliasTableName,ParentId,ColumnNumber,IsDic,totalFlag)");
            strSql.Append(" values (");
            strSql.Append("@CompanyCD,@CustomTableName,@AliasTableName,@ParentId,@ColumnNumber,@IsDic,@totalFlag)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
					new SqlParameter("@CompanyCD", SqlDbType.VarChar,50),
					new SqlParameter("@CustomTableName", SqlDbType.VarChar,100),
					new SqlParameter("@AliasTableName", SqlDbType.VarChar,300),
                    new SqlParameter("@ParentId", SqlDbType.Int,4),
                    new SqlParameter("@ColumnNumber", SqlDbType.Int,4),
                    new SqlParameter("@IsDic", SqlDbType.Int,4),
                    new SqlParameter("@totalFlag", SqlDbType.Int,4)};
            parameters[0].Value = model.CompanyCD;
            parameters[1].Value = model.CustomTableName;
            parameters[2].Value = model.AliasTableName;
            parameters[3].Value = model.ParentId;
            parameters[4].Value = model.ColumnNumber;
            parameters[5].Value = model.IsDic;
            parameters[6].Value = model.totalFlag;
            return Convert.ToInt32(SqlHelper.ExecuteScalar(strSql.ToString(), parameters));

        }
示例#5
0
 /// <summary>
 /// 修改自定义表单
 /// </summary>
 /// <param name="model"></param>
 /// <param name="sonModel"></param>
 /// <param name="strMsg"></param>
 /// <returns></returns>
 public static bool EditTable(CustomTableModel model, List<StructTable> sonModel, out string strMsg)
 {
     return DefFormDBHelper.EditTable(model, sonModel, out strMsg);
 }