Beispiel #1
0
        public bool AddAllot(Doc_Allot info)
        {
            int result = 0;
            if (info != null)
            {

                result = daInstance.Add(info);

            }
            return result > 0 ? true : false;
        }
Beispiel #2
0
        public JsonResult AllotOperation(FormCollection formCollect)
        {
            Doc_Allot doc = new Doc_Allot();
            string id = formCollect["DA_Code"];
            doc = diInstance.GetAllotModel(string.Format("AND DA_Code='{0}'", id));
            doc.DA_Opinion = formCollect["DA_Opinion"];
            doc.DA_IsHandle = "Handle";
            doc.DA_IsHandleName = "处理";

            diInstance.UpdateAllot(doc);
            return new JsonResult { Data = new { result = "success", Msg = "数据更新成功!" } };
        }
Beispiel #3
0
        public ActionResult DocCC(string code, string name, string doc, string module)
        {
            if (!string.IsNullOrEmpty(code))
            {
                string[] codeArray = code.Split(',');
                string[] nameArray = name.Split(',');
                for (int i = 0; i < codeArray.Length; i++)
                {
                    var c = codeArray[i];
                    var na = nameArray[i];
                    Doc_Allot allot = new Doc_Allot();
                    allot.DA_Code = diInstance.GenerateAllotCode();

                    allot.DA_Module = module;
                    //未处理
                    allot.DA_IsHandle = "NoHandle";
                    allot.DA_IsHandleName = "未处理";
                    //分发人编码
                    allot.DA_Allot = c;
                    //分法人名字
                    allot.DA_Account = na;
                    allot.DA_DocCode = doc;
                    allot.DA_iType = AllotType.CC.ToString();
                    allot.DA_Date = DateTime.Now;
                    diInstance.AddAllot(allot);

                    BLL.Bll_Comm.OpLog("Allot", "Allot", string.Format("抄送:{0}", allot.DA_DocCode));
                }

                return new JsonResult { Data = new { result = "success", Msg = "数据更新成功!" } };
            }
            return new JsonResult { Data = new { result = "fail", Msg = "数据更新失败!" } };
        }
Beispiel #4
0
        /// <summary>
        /// 更新Doc_Allot对象(即:一条记录
        /// </summary>
        public int Update(Doc_Allot doc_Allot)
        {
            StringBuilder sbParameter=new StringBuilder();
              StringBuilder sb=new StringBuilder();
              sb.Append(@"UPDATE       Doc_Allot       SET ");
            if(doc_Allot.DA_Code_IsChanged){sbParameter.Append("DA_Code=@DA_Code, ");}
              if(doc_Allot.DA_DocCode_IsChanged){sbParameter.Append("DA_DocCode=@DA_DocCode, ");}
              if(doc_Allot.DA_Module_IsChanged){sbParameter.Append("DA_Module=@DA_Module, ");}
              if(doc_Allot.DA_IsHandle_IsChanged){sbParameter.Append("DA_IsHandle=@DA_IsHandle, ");}
              if(doc_Allot.DA_IsHandleName_IsChanged){sbParameter.Append("DA_IsHandleName=@DA_IsHandleName, ");}
              if(doc_Allot.DA_Date_IsChanged){sbParameter.Append("DA_Date=@DA_Date, ");}
              if(doc_Allot.DA_Opinion_IsChanged){sbParameter.Append("DA_Opinion=@DA_Opinion, ");}
              if(doc_Allot.DA_Allot_IsChanged){sbParameter.Append("DA_Allot=@DA_Allot, ");}
              if(doc_Allot.DA_Account_IsChanged){sbParameter.Append("DA_Account=@DA_Account, ");}
              if(doc_Allot.DA_Type_IsChanged){sbParameter.Append("DA_Type=@DA_Type, ");}
              if(doc_Allot.DA_TypeName_IsChanged){sbParameter.Append("DA_TypeName=@DA_TypeName, ");}
              if(doc_Allot.DA_iType_IsChanged){sbParameter.Append("DA_iType=@DA_iType, ");}
              if(doc_Allot.DA_RefCode_IsChanged){sbParameter.Append("DA_RefCode=@DA_RefCode, ");}
              if(doc_Allot.Stat_IsChanged){sbParameter.Append("Stat=@Stat, ");}
              if(doc_Allot.CreateTime_IsChanged){sbParameter.Append("CreateTime=@CreateTime, ");}
              if(doc_Allot.UpdateTime_IsChanged){sbParameter.Append("UpdateTime=@UpdateTime, ");}
              if(doc_Allot.DeleteTime_IsChanged){sbParameter.Append("DeleteTime=@DeleteTime, ");}
              if(doc_Allot.DA_Udef1_IsChanged){sbParameter.Append("DA_Udef1=@DA_Udef1, ");}
              if(doc_Allot.DA_Udef2_IsChanged){sbParameter.Append("DA_Udef2=@DA_Udef2, ");}
              if(doc_Allot.DA_Udef3_IsChanged){sbParameter.Append("DA_Udef3=@DA_Udef3 ");}
          sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
              sb.Append(      " WHERE 1=1 AND ((Stat is null) or (Stat=0))   and DA_ID=@DA_ID; " );
              string sql=sb.ToString();
             if(doc_Allot.DA_Code_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Allot.DA_Code))
             {
            idb.AddParameter("@DA_Code", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_Code", doc_Allot.DA_Code);
             }
              }
             if(doc_Allot.DA_DocCode_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Allot.DA_DocCode))
             {
            idb.AddParameter("@DA_DocCode", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_DocCode", doc_Allot.DA_DocCode);
             }
              }
             if(doc_Allot.DA_Module_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Allot.DA_Module))
             {
            idb.AddParameter("@DA_Module", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_Module", doc_Allot.DA_Module);
             }
              }
             if(doc_Allot.DA_IsHandle_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Allot.DA_IsHandle))
             {
            idb.AddParameter("@DA_IsHandle", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_IsHandle", doc_Allot.DA_IsHandle);
             }
              }
             if(doc_Allot.DA_IsHandleName_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Allot.DA_IsHandleName))
             {
            idb.AddParameter("@DA_IsHandleName", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_IsHandleName", doc_Allot.DA_IsHandleName);
             }
              }
             if(doc_Allot.DA_Date_IsChanged)
             {
             if (doc_Allot.DA_Date == DateTime.MinValue)
             {
            idb.AddParameter("@DA_Date", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_Date", doc_Allot.DA_Date);
             }
              }
             if(doc_Allot.DA_Opinion_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Allot.DA_Opinion))
             {
            idb.AddParameter("@DA_Opinion", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_Opinion", doc_Allot.DA_Opinion);
             }
              }
             if(doc_Allot.DA_Allot_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Allot.DA_Allot))
             {
            idb.AddParameter("@DA_Allot", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_Allot", doc_Allot.DA_Allot);
             }
              }
             if(doc_Allot.DA_Account_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Allot.DA_Account))
             {
            idb.AddParameter("@DA_Account", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_Account", doc_Allot.DA_Account);
             }
              }
             if(doc_Allot.DA_Type_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Allot.DA_Type))
             {
            idb.AddParameter("@DA_Type", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_Type", doc_Allot.DA_Type);
             }
              }
             if(doc_Allot.DA_TypeName_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Allot.DA_TypeName))
             {
            idb.AddParameter("@DA_TypeName", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_TypeName", doc_Allot.DA_TypeName);
             }
              }
             if(doc_Allot.DA_iType_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Allot.DA_iType))
             {
            idb.AddParameter("@DA_iType", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_iType", doc_Allot.DA_iType);
             }
              }
             if(doc_Allot.DA_RefCode_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Allot.DA_RefCode))
             {
            idb.AddParameter("@DA_RefCode", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_RefCode", doc_Allot.DA_RefCode);
             }
              }
             if(doc_Allot.Stat_IsChanged)
             {
             if (doc_Allot.Stat == 0)
             {
            idb.AddParameter("@Stat", 0);
             }
             else
             {
            idb.AddParameter("@Stat", doc_Allot.Stat);
             }
              }
             if(doc_Allot.CreateTime_IsChanged)
             {
             if (doc_Allot.CreateTime == DateTime.MinValue)
             {
            idb.AddParameter("@CreateTime", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@CreateTime", doc_Allot.CreateTime);
             }
              }
             if(doc_Allot.UpdateTime_IsChanged)
             {
             if (doc_Allot.UpdateTime == DateTime.MinValue)
             {
            idb.AddParameter("@UpdateTime", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@UpdateTime", doc_Allot.UpdateTime);
             }
              }
             if(doc_Allot.DeleteTime_IsChanged)
             {
             if (doc_Allot.DeleteTime == DateTime.MinValue)
             {
            idb.AddParameter("@DeleteTime", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DeleteTime", doc_Allot.DeleteTime);
             }
              }
             if(doc_Allot.DA_Udef1_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Allot.DA_Udef1))
             {
            idb.AddParameter("@DA_Udef1", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_Udef1", doc_Allot.DA_Udef1);
             }
              }
             if(doc_Allot.DA_Udef2_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Allot.DA_Udef2))
             {
            idb.AddParameter("@DA_Udef2", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_Udef2", doc_Allot.DA_Udef2);
             }
              }
             if(doc_Allot.DA_Udef3_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Allot.DA_Udef3))
             {
            idb.AddParameter("@DA_Udef3", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_Udef3", doc_Allot.DA_Udef3);
             }
              }

             idb.AddParameter("@DA_ID", doc_Allot.DA_ID);

             return idb.ExeCmd(sql);
Beispiel #5
0
 /// <summary>
 /// 获取指定的Doc_Allot对象集合
 /// </summary>
 public List<Doc_Allot> GetListByWhere(string strCondition)
 {
     List<Doc_Allot> ret = new List<Doc_Allot>();
      string sql = "SELECT  DA_ID,DA_Code,DA_DocCode,DA_Module,DA_IsHandle,DA_IsHandleName,DA_Date,DA_Opinion,DA_Allot,DA_Account,DA_Type,DA_TypeName,DA_iType,DA_RefCode,Stat,CreateTime,UpdateTime,DeleteTime,DA_Udef1,DA_Udef2,DA_Udef3 FROM Doc_Allot WHERE 1=1 AND ((Stat is null) or (Stat=0) ) ";
      if(!string.IsNullOrEmpty(strCondition))
      {
     strCondition.Replace('\'','"'); //防sql注入
     sql += strCondition ;
      }
       sql += " ORDER BY DA_ID DESC ";
       SqlDataReader dr=null;
        try {
       dr=(SqlDataReader)idb.ReturnReader(sql);
      while(dr.Read())
      {
     Doc_Allot doc_Allot = new Doc_Allot();
     if (dr["DA_ID"] != DBNull.Value) doc_Allot.DA_ID = Convert.ToDecimal(dr["DA_ID"]);
     if (dr["DA_Code"] != DBNull.Value) doc_Allot.DA_Code = Convert.ToString(dr["DA_Code"]);
     if (dr["DA_DocCode"] != DBNull.Value) doc_Allot.DA_DocCode = Convert.ToString(dr["DA_DocCode"]);
     if (dr["DA_Module"] != DBNull.Value) doc_Allot.DA_Module = Convert.ToString(dr["DA_Module"]);
     if (dr["DA_IsHandle"] != DBNull.Value) doc_Allot.DA_IsHandle = Convert.ToString(dr["DA_IsHandle"]);
     if (dr["DA_IsHandleName"] != DBNull.Value) doc_Allot.DA_IsHandleName = Convert.ToString(dr["DA_IsHandleName"]);
     if (dr["DA_Date"] != DBNull.Value) doc_Allot.DA_Date = Convert.ToDateTime(dr["DA_Date"]);
     if (dr["DA_Opinion"] != DBNull.Value) doc_Allot.DA_Opinion = Convert.ToString(dr["DA_Opinion"]);
     if (dr["DA_Allot"] != DBNull.Value) doc_Allot.DA_Allot = Convert.ToString(dr["DA_Allot"]);
     if (dr["DA_Account"] != DBNull.Value) doc_Allot.DA_Account = Convert.ToString(dr["DA_Account"]);
     if (dr["DA_Type"] != DBNull.Value) doc_Allot.DA_Type = Convert.ToString(dr["DA_Type"]);
     if (dr["DA_TypeName"] != DBNull.Value) doc_Allot.DA_TypeName = Convert.ToString(dr["DA_TypeName"]);
     if (dr["DA_iType"] != DBNull.Value) doc_Allot.DA_iType = Convert.ToString(dr["DA_iType"]);
     if (dr["DA_RefCode"] != DBNull.Value) doc_Allot.DA_RefCode = Convert.ToString(dr["DA_RefCode"]);
     if (dr["Stat"] != DBNull.Value) doc_Allot.Stat = Convert.ToInt32(dr["Stat"]);
     if (dr["CreateTime"] != DBNull.Value) doc_Allot.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
     if (dr["UpdateTime"] != DBNull.Value) doc_Allot.UpdateTime = Convert.ToDateTime(dr["UpdateTime"]);
     if (dr["DeleteTime"] != DBNull.Value) doc_Allot.DeleteTime = Convert.ToDateTime(dr["DeleteTime"]);
     if (dr["DA_Udef1"] != DBNull.Value) doc_Allot.DA_Udef1 = Convert.ToString(dr["DA_Udef1"]);
     if (dr["DA_Udef2"] != DBNull.Value) doc_Allot.DA_Udef2 = Convert.ToString(dr["DA_Udef2"]);
     if (dr["DA_Udef3"] != DBNull.Value) doc_Allot.DA_Udef3 = Convert.ToString(dr["DA_Udef3"]);
     ret.Add(doc_Allot);
      }
       }catch (System.Exception ex){ throw ex; }  finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); }   }
      return ret;
 }
Beispiel #6
0
        /// <summary>
        /// 获取指定的Doc_Allot对象(即:一条记录
        /// </summary>
        public Doc_Allot GetByKey(decimal dA_ID)
        {
            Doc_Allot doc_Allot = new Doc_Allot();
             string sql = "SELECT  DA_ID,DA_Code,DA_DocCode,DA_Module,DA_IsHandle,DA_IsHandleName,DA_Date,DA_Opinion,DA_Allot,DA_Account,DA_Type,DA_TypeName,DA_iType,DA_RefCode,Stat,CreateTime,UpdateTime,DeleteTime,DA_Udef1,DA_Udef2,DA_Udef3 FROM Doc_Allot WHERE 1=1 AND ((Stat is null) or (Stat=0) )  AND DA_ID=@DA_ID ";
             idb.AddParameter("@DA_ID", dA_ID);

              SqlDataReader dr=null;
               try {
              dr=(SqlDataReader)idb.ReturnReader(sql);
             while(dr.Read())
             {
            if (dr["DA_ID"] != DBNull.Value) doc_Allot.DA_ID = Convert.ToDecimal(dr["DA_ID"]);
            if (dr["DA_Code"] != DBNull.Value) doc_Allot.DA_Code = Convert.ToString(dr["DA_Code"]);
            if (dr["DA_DocCode"] != DBNull.Value) doc_Allot.DA_DocCode = Convert.ToString(dr["DA_DocCode"]);
            if (dr["DA_Module"] != DBNull.Value) doc_Allot.DA_Module = Convert.ToString(dr["DA_Module"]);
            if (dr["DA_IsHandle"] != DBNull.Value) doc_Allot.DA_IsHandle = Convert.ToString(dr["DA_IsHandle"]);
            if (dr["DA_IsHandleName"] != DBNull.Value) doc_Allot.DA_IsHandleName = Convert.ToString(dr["DA_IsHandleName"]);
            if (dr["DA_Date"] != DBNull.Value) doc_Allot.DA_Date = Convert.ToDateTime(dr["DA_Date"]);
            if (dr["DA_Opinion"] != DBNull.Value) doc_Allot.DA_Opinion = Convert.ToString(dr["DA_Opinion"]);
            if (dr["DA_Allot"] != DBNull.Value) doc_Allot.DA_Allot = Convert.ToString(dr["DA_Allot"]);
            if (dr["DA_Account"] != DBNull.Value) doc_Allot.DA_Account = Convert.ToString(dr["DA_Account"]);
            if (dr["DA_Type"] != DBNull.Value) doc_Allot.DA_Type = Convert.ToString(dr["DA_Type"]);
            if (dr["DA_TypeName"] != DBNull.Value) doc_Allot.DA_TypeName = Convert.ToString(dr["DA_TypeName"]);
            if (dr["DA_iType"] != DBNull.Value) doc_Allot.DA_iType = Convert.ToString(dr["DA_iType"]);
            if (dr["DA_RefCode"] != DBNull.Value) doc_Allot.DA_RefCode = Convert.ToString(dr["DA_RefCode"]);
            if (dr["Stat"] != DBNull.Value) doc_Allot.Stat = Convert.ToInt32(dr["Stat"]);
            if (dr["CreateTime"] != DBNull.Value) doc_Allot.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
            if (dr["UpdateTime"] != DBNull.Value) doc_Allot.UpdateTime = Convert.ToDateTime(dr["UpdateTime"]);
            if (dr["DeleteTime"] != DBNull.Value) doc_Allot.DeleteTime = Convert.ToDateTime(dr["DeleteTime"]);
            if (dr["DA_Udef1"] != DBNull.Value) doc_Allot.DA_Udef1 = Convert.ToString(dr["DA_Udef1"]);
            if (dr["DA_Udef2"] != DBNull.Value) doc_Allot.DA_Udef2 = Convert.ToString(dr["DA_Udef2"]);
            if (dr["DA_Udef3"] != DBNull.Value) doc_Allot.DA_Udef3 = Convert.ToString(dr["DA_Udef3"]);
             }
              }catch (System.Exception ex){ throw ex; }  finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); }   }
             return doc_Allot;
        }
Beispiel #7
0
        /// <summary>
        /// 添加Doc_Allot对象(即:一条记录)
        /// </summary>
        public int Add(Doc_Allot doc_Allot)
        {
            string sql = "INSERT INTO Doc_Allot (DA_Code,DA_DocCode,DA_Module,DA_IsHandle,DA_IsHandleName,DA_Date,DA_Opinion,DA_Allot,DA_Account,DA_Type,DA_TypeName,DA_iType,DA_RefCode,Stat,CreateTime,UpdateTime,DeleteTime,DA_Udef1,DA_Udef2,DA_Udef3) VALUES (@DA_Code,@DA_DocCode,@DA_Module,@DA_IsHandle,@DA_IsHandleName,@DA_Date,@DA_Opinion,@DA_Allot,@DA_Account,@DA_Type,@DA_TypeName,@DA_iType,@DA_RefCode,@Stat,@CreateTime,@UpdateTime,@DeleteTime,@DA_Udef1,@DA_Udef2,@DA_Udef3)";
             if (string.IsNullOrEmpty(doc_Allot.DA_Code))
             {
            idb.AddParameter("@DA_Code", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_Code", doc_Allot.DA_Code);
             }
             if (string.IsNullOrEmpty(doc_Allot.DA_DocCode))
             {
            idb.AddParameter("@DA_DocCode", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_DocCode", doc_Allot.DA_DocCode);
             }
             if (string.IsNullOrEmpty(doc_Allot.DA_Module))
             {
            idb.AddParameter("@DA_Module", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_Module", doc_Allot.DA_Module);
             }
             if (string.IsNullOrEmpty(doc_Allot.DA_IsHandle))
             {
            idb.AddParameter("@DA_IsHandle", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_IsHandle", doc_Allot.DA_IsHandle);
             }
             if (string.IsNullOrEmpty(doc_Allot.DA_IsHandleName))
             {
            idb.AddParameter("@DA_IsHandleName", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_IsHandleName", doc_Allot.DA_IsHandleName);
             }
             if (doc_Allot.DA_Date == DateTime.MinValue)
             {
            idb.AddParameter("@DA_Date", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_Date", doc_Allot.DA_Date);
             }
             if (string.IsNullOrEmpty(doc_Allot.DA_Opinion))
             {
            idb.AddParameter("@DA_Opinion", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_Opinion", doc_Allot.DA_Opinion);
             }
             if (string.IsNullOrEmpty(doc_Allot.DA_Allot))
             {
            idb.AddParameter("@DA_Allot", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_Allot", doc_Allot.DA_Allot);
             }
             if (string.IsNullOrEmpty(doc_Allot.DA_Account))
             {
            idb.AddParameter("@DA_Account", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_Account", doc_Allot.DA_Account);
             }
             if (string.IsNullOrEmpty(doc_Allot.DA_Type))
             {
            idb.AddParameter("@DA_Type", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_Type", doc_Allot.DA_Type);
             }
             if (string.IsNullOrEmpty(doc_Allot.DA_TypeName))
             {
            idb.AddParameter("@DA_TypeName", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_TypeName", doc_Allot.DA_TypeName);
             }
             if (string.IsNullOrEmpty(doc_Allot.DA_iType))
             {
            idb.AddParameter("@DA_iType", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_iType", doc_Allot.DA_iType);
             }
             if (string.IsNullOrEmpty(doc_Allot.DA_RefCode))
             {
            idb.AddParameter("@DA_RefCode", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_RefCode", doc_Allot.DA_RefCode);
             }
             if (doc_Allot.Stat == 0)
             {
            idb.AddParameter("@Stat", 0);
             }
             else
             {
            idb.AddParameter("@Stat", doc_Allot.Stat);
             }
             if (doc_Allot.CreateTime == DateTime.MinValue)
             {
            idb.AddParameter("@CreateTime", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@CreateTime", doc_Allot.CreateTime);
             }
             if (doc_Allot.UpdateTime == DateTime.MinValue)
             {
            idb.AddParameter("@UpdateTime", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@UpdateTime", doc_Allot.UpdateTime);
             }
             if (doc_Allot.DeleteTime == DateTime.MinValue)
             {
            idb.AddParameter("@DeleteTime", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DeleteTime", doc_Allot.DeleteTime);
             }
             if (string.IsNullOrEmpty(doc_Allot.DA_Udef1))
             {
            idb.AddParameter("@DA_Udef1", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_Udef1", doc_Allot.DA_Udef1);
             }
             if (string.IsNullOrEmpty(doc_Allot.DA_Udef2))
             {
            idb.AddParameter("@DA_Udef2", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_Udef2", doc_Allot.DA_Udef2);
             }
             if (string.IsNullOrEmpty(doc_Allot.DA_Udef3))
             {
            idb.AddParameter("@DA_Udef3", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DA_Udef3", doc_Allot.DA_Udef3);
             }

             return idb.ExeCmd(sql);
        }