public bool UpdateAllot(Doc_Allot info)
{
int result = 0;
if (info != null)
{
result = daInstance.Update(info);
}
return(result > 0 ? true : false);
}
/// <summary>
/// 群组相关人员删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult AllotGroupDelete(string id)
{
Doc_Allot doc = diInstance.GetAllotModel(string.Format("AND DA_Code='{0}'", id));
doc.Stat = 1;
diInstance.UpdateAllot(doc);
BLL.Bll_Comm.OpLog("CListDoc_Info", "AllotDelete", string.Format("删除分发人员:{0}", id));
return(Json(new { result = "success", message = "成功" }, "text/json"));
}
public void Handle(string code)
{
string condition = string.Format("AND DA_DocCode='{0}' And DA_Allot='{1}'", code, SessionConfig.UserId());
Doc_Allot allot = diInstance.GetAllotModel(condition);
if (allot != null && (allot.DA_IsHandle == "NoHandle" || string.IsNullOrEmpty(allot.DA_IsHandle)))
{
allot.DA_IsHandle = "Handle";
allot.DA_IsHandleName = "处理";
var flag = diInstance.UpdateAllot(allot);
}
}
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 = "数据更新成功！" }
});
}
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 = "数据更新失败！" }
});
}
/// <summary>
/// 获取所有的Doc_Allot对象(即:一条记录
/// </summary>
public List <Doc_Allot> GetAll()
{
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) ) 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);
}
/// <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);
}
/// <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));
}
/// <summary>
/// 添加Doc_Allot对象(即:一条记录)
/// </summary>
public object AddWithReturn(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);SELECT @@IDENTITY AS ReturnID;";
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.ReturnValue(sql));
}
