/// <summary>
/// 获取实体数据
/// </summary>
/// <param name='strCondition'>条件(AND Code='11')</param>
/// <returns>model</returns>
public WH_Banlance GetModel(string strCondition)
{
List<WH_Banlance> list = instance.GetListByWhere(strCondition);
WH_Banlance model = new WH_Banlance();
if (list != null && list.Count > 0)
{
model = list[0];
}
else
{
model = null;
}
return model;
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <param name='model'>是否完成验证</param>
/// <returns>bool</returns>
public bool Insert(WH_Banlance model,bool IsValid)
{
var e = new ModelExceptions();
bool result = false;
if (e.IsValid && IsValid)
{
//完成了验证，开始更新数据库了
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
return result;
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Update(WH_Banlance model,bool IsValid)
{
bool result = false;
var e = new ModelExceptions();
if(e.IsValid && IsValid){
int _rseult = instance.Update(model);
if (_rseult > 0)
{
result = true;
}
}
return result;
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Insert(WH_Banlance model)
{
bool result = false;
try
{
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return result;
}
/// <summary>
/// 更新结算单 WH_Banlance对象(即:一条记录
/// </summary>
public int Update(WH_Banlance wH_Banlance)
{
StringBuilder sbParameter=new StringBuilder();
StringBuilder sb=new StringBuilder();
sb.Append(@"UPDATE WH_Banlance SET ");
if(wH_Banlance.WHB_Period_IsChanged){sbParameter.Append("WHB_Period=@WHB_Period, ");}
if(wH_Banlance.WHB_iType_IsChanged){sbParameter.Append("WHB_iType=@WHB_iType, ");}
if(wH_Banlance.WHB_Code_IsChanged){sbParameter.Append("WHB_Code=@WHB_Code, ");}
if(wH_Banlance.WHB_UCompany_IsChanged){sbParameter.Append("WHB_UCompany=@WHB_UCompany, ");}
if(wH_Banlance.WHB_UCompanyCode_IsChanged){sbParameter.Append("WHB_UCompanyCode=@WHB_UCompanyCode, ");}
if(wH_Banlance.WHB_SCode_IsChanged){sbParameter.Append("WHB_SCode=@WHB_SCode, ");}
if(wH_Banlance.WHB_SName_IsChanged){sbParameter.Append("WHB_SName=@WHB_SName, ");}
if(wH_Banlance.WHB_LastMonth_IsChanged){sbParameter.Append("WHB_LastMonth=@WHB_LastMonth, ");}
if(wH_Banlance.WHB_CurMonth_IsChanged){sbParameter.Append("WHB_CurMonth=@WHB_CurMonth, ");}
if(wH_Banlance.WHB_CurPay_IsChanged){sbParameter.Append("WHB_CurPay=@WHB_CurPay, ");}
if(wH_Banlance.WHB_CurLeft_IsChanged){sbParameter.Append("WHB_CurLeft=@WHB_CurLeft, ");}
if(wH_Banlance.WHB_Plan_IsChanged){sbParameter.Append("WHB_Plan=@WHB_Plan, ");}
if(wH_Banlance.WHB_NextMonth_IsChanged){sbParameter.Append("WHB_NextMonth=@WHB_NextMonth, ");}
if(wH_Banlance.WHB_broom_IsChanged){sbParameter.Append("WHB_broom=@WHB_broom, ");}
if(wH_Banlance.WHB_Recive_IsChanged){sbParameter.Append("WHB_Recive=@WHB_Recive, ");}
if(wH_Banlance.WHB_Date_IsChanged){sbParameter.Append("WHB_Date=@WHB_Date, ");}
if(wH_Banlance.WHB_Status_IsChanged){sbParameter.Append("WHB_Status=@WHB_Status, ");}
if(wH_Banlance.WHB_UDEF1_IsChanged){sbParameter.Append("WHB_UDEF1=@WHB_UDEF1, ");}
if(wH_Banlance.WHB_UDEF2_IsChanged){sbParameter.Append("WHB_UDEF2=@WHB_UDEF2, ");}
if(wH_Banlance.WHB_UDEF3_IsChanged){sbParameter.Append("WHB_UDEF3=@WHB_UDEF3, ");}
if(wH_Banlance.WHB_UDEF4_IsChanged){sbParameter.Append("WHB_UDEF4=@WHB_UDEF4, ");}
if(wH_Banlance.WHB_UDEF5_IsChanged){sbParameter.Append("WHB_UDEF5=@WHB_UDEF5, ");}
if(wH_Banlance.WHB_UDEF6_IsChanged){sbParameter.Append("WHB_UDEF6=@WHB_UDEF6, ");}
if(wH_Banlance.WHB_UDEF7_IsChanged){sbParameter.Append("WHB_UDEF7=@WHB_UDEF7, ");}
if(wH_Banlance.WHB_UDEF8_IsChanged){sbParameter.Append("WHB_UDEF8=@WHB_UDEF8, ");}
if(wH_Banlance.WHB_UDEF9_IsChanged){sbParameter.Append("WHB_UDEF9=@WHB_UDEF9, ");}
if(wH_Banlance.WHB_UDEF10_IsChanged){sbParameter.Append("WHB_UDEF10=@WHB_UDEF10, ");}
if(wH_Banlance.Stat_IsChanged){sbParameter.Append("Stat=@Stat, ");}
if(wH_Banlance.CreateDate_IsChanged){sbParameter.Append("CreateDate=@CreateDate, ");}
if(wH_Banlance.UpdateDate_IsChanged){sbParameter.Append("UpdateDate=@UpdateDate, ");}
if(wH_Banlance.DeleteDate_IsChanged){sbParameter.Append("DeleteDate=@DeleteDate, ");}
if(wH_Banlance.WHB_Invoice_IsChanged){sbParameter.Append("WHB_Invoice=@WHB_Invoice, ");}
if(wH_Banlance.WHB_Pay_IsChanged){sbParameter.Append("WHB_Pay=@WHB_Pay, ");}
if(wH_Banlance.WHB_RInvoice_IsChanged){sbParameter.Append("WHB_RInvoice=@WHB_RInvoice, ");}
if(wH_Banlance.WHB_RPay_IsChanged){sbParameter.Append("WHB_RPay=@WHB_RPay, ");}
if(wH_Banlance.WHB_NumLast_IsChanged){sbParameter.Append("WHB_NumLast=@WHB_NumLast, ");}
if(wH_Banlance.WHB_NumCur_IsChanged){sbParameter.Append("WHB_NumCur=@WHB_NumCur, ");}
if(wH_Banlance.WHB_NumReturn_IsChanged){sbParameter.Append("WHB_NumReturn=@WHB_NumReturn, ");}
if(wH_Banlance.WHB_NumReal_IsChanged){sbParameter.Append("WHB_NumReal=@WHB_NumReal ");}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append( " WHERE 1=1 AND ((Stat is null) or (Stat=0)) and WHB_ID=@WHB_ID; " );
string sql=sb.ToString();
if(wH_Banlance.WHB_Period_IsChanged)
{
if (string.IsNullOrEmpty(wH_Banlance.WHB_Period))
{
idb.AddParameter("@WHB_Period", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_Period", wH_Banlance.WHB_Period);
}
}
if(wH_Banlance.WHB_iType_IsChanged)
{
if (string.IsNullOrEmpty(wH_Banlance.WHB_iType))
{
idb.AddParameter("@WHB_iType", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_iType", wH_Banlance.WHB_iType);
}
}
if(wH_Banlance.WHB_Code_IsChanged)
{
if (string.IsNullOrEmpty(wH_Banlance.WHB_Code))
{
idb.AddParameter("@WHB_Code", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_Code", wH_Banlance.WHB_Code);
}
}
if(wH_Banlance.WHB_UCompany_IsChanged)
{
if (string.IsNullOrEmpty(wH_Banlance.WHB_UCompany))
{
idb.AddParameter("@WHB_UCompany", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UCompany", wH_Banlance.WHB_UCompany);
}
}
if(wH_Banlance.WHB_UCompanyCode_IsChanged)
{
if (string.IsNullOrEmpty(wH_Banlance.WHB_UCompanyCode))
{
idb.AddParameter("@WHB_UCompanyCode", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UCompanyCode", wH_Banlance.WHB_UCompanyCode);
}
}
if(wH_Banlance.WHB_SCode_IsChanged)
{
if (string.IsNullOrEmpty(wH_Banlance.WHB_SCode))
{
idb.AddParameter("@WHB_SCode", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_SCode", wH_Banlance.WHB_SCode);
}
}
if(wH_Banlance.WHB_SName_IsChanged)
{
if (string.IsNullOrEmpty(wH_Banlance.WHB_SName))
{
idb.AddParameter("@WHB_SName", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_SName", wH_Banlance.WHB_SName);
}
}
if(wH_Banlance.WHB_LastMonth_IsChanged)
{
if (wH_Banlance.WHB_LastMonth == 0)
{
idb.AddParameter("@WHB_LastMonth", 0);
}
else
{
idb.AddParameter("@WHB_LastMonth", wH_Banlance.WHB_LastMonth);
}
}
if(wH_Banlance.WHB_CurMonth_IsChanged)
{
if (wH_Banlance.WHB_CurMonth == 0)
{
idb.AddParameter("@WHB_CurMonth", 0);
}
else
{
idb.AddParameter("@WHB_CurMonth", wH_Banlance.WHB_CurMonth);
}
}
if(wH_Banlance.WHB_CurPay_IsChanged)
{
if (wH_Banlance.WHB_CurPay == 0)
{
idb.AddParameter("@WHB_CurPay", 0);
}
else
{
idb.AddParameter("@WHB_CurPay", wH_Banlance.WHB_CurPay);
}
}
if(wH_Banlance.WHB_CurLeft_IsChanged)
{
if (wH_Banlance.WHB_CurLeft == 0)
{
idb.AddParameter("@WHB_CurLeft", 0);
}
else
{
idb.AddParameter("@WHB_CurLeft", wH_Banlance.WHB_CurLeft);
}
}
if(wH_Banlance.WHB_Plan_IsChanged)
{
if (wH_Banlance.WHB_Plan == 0)
{
idb.AddParameter("@WHB_Plan", 0);
}
else
{
idb.AddParameter("@WHB_Plan", wH_Banlance.WHB_Plan);
}
}
if(wH_Banlance.WHB_NextMonth_IsChanged)
{
if (wH_Banlance.WHB_NextMonth == 0)
{
idb.AddParameter("@WHB_NextMonth", 0);
}
else
{
idb.AddParameter("@WHB_NextMonth", wH_Banlance.WHB_NextMonth);
}
}
if(wH_Banlance.WHB_broom_IsChanged)
{
if (wH_Banlance.WHB_broom == 0)
{
idb.AddParameter("@WHB_broom", 0);
}
else
{
idb.AddParameter("@WHB_broom", wH_Banlance.WHB_broom);
}
}
if(wH_Banlance.WHB_Recive_IsChanged)
{
if (wH_Banlance.WHB_Recive == 0)
{
idb.AddParameter("@WHB_Recive", 0);
}
else
{
idb.AddParameter("@WHB_Recive", wH_Banlance.WHB_Recive);
}
}
if(wH_Banlance.WHB_Date_IsChanged)
{
if (wH_Banlance.WHB_Date == DateTime.MinValue)
{
idb.AddParameter("@WHB_Date", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_Date", wH_Banlance.WHB_Date);
}
}
if(wH_Banlance.WHB_Status_IsChanged)
{
if (string.IsNullOrEmpty(wH_Banlance.WHB_Status))
{
idb.AddParameter("@WHB_Status", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_Status", wH_Banlance.WHB_Status);
}
}
if(wH_Banlance.WHB_UDEF1_IsChanged)
{
if (string.IsNullOrEmpty(wH_Banlance.WHB_UDEF1))
{
idb.AddParameter("@WHB_UDEF1", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UDEF1", wH_Banlance.WHB_UDEF1);
}
}
if(wH_Banlance.WHB_UDEF2_IsChanged)
{
if (string.IsNullOrEmpty(wH_Banlance.WHB_UDEF2))
{
idb.AddParameter("@WHB_UDEF2", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UDEF2", wH_Banlance.WHB_UDEF2);
}
}
if(wH_Banlance.WHB_UDEF3_IsChanged)
{
if (string.IsNullOrEmpty(wH_Banlance.WHB_UDEF3))
{
idb.AddParameter("@WHB_UDEF3", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UDEF3", wH_Banlance.WHB_UDEF3);
}
}
if(wH_Banlance.WHB_UDEF4_IsChanged)
{
if (string.IsNullOrEmpty(wH_Banlance.WHB_UDEF4))
{
idb.AddParameter("@WHB_UDEF4", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UDEF4", wH_Banlance.WHB_UDEF4);
}
}
if(wH_Banlance.WHB_UDEF5_IsChanged)
{
if (string.IsNullOrEmpty(wH_Banlance.WHB_UDEF5))
{
idb.AddParameter("@WHB_UDEF5", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UDEF5", wH_Banlance.WHB_UDEF5);
}
}
if(wH_Banlance.WHB_UDEF6_IsChanged)
{
if (string.IsNullOrEmpty(wH_Banlance.WHB_UDEF6))
{
idb.AddParameter("@WHB_UDEF6", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UDEF6", wH_Banlance.WHB_UDEF6);
}
}
if(wH_Banlance.WHB_UDEF7_IsChanged)
{
if (string.IsNullOrEmpty(wH_Banlance.WHB_UDEF7))
{
idb.AddParameter("@WHB_UDEF7", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UDEF7", wH_Banlance.WHB_UDEF7);
}
}
if(wH_Banlance.WHB_UDEF8_IsChanged)
{
if (string.IsNullOrEmpty(wH_Banlance.WHB_UDEF8))
{
idb.AddParameter("@WHB_UDEF8", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UDEF8", wH_Banlance.WHB_UDEF8);
}
}
if(wH_Banlance.WHB_UDEF9_IsChanged)
{
if (string.IsNullOrEmpty(wH_Banlance.WHB_UDEF9))
{
idb.AddParameter("@WHB_UDEF9", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UDEF9", wH_Banlance.WHB_UDEF9);
}
}
if(wH_Banlance.WHB_UDEF10_IsChanged)
{
if (string.IsNullOrEmpty(wH_Banlance.WHB_UDEF10))
{
idb.AddParameter("@WHB_UDEF10", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UDEF10", wH_Banlance.WHB_UDEF10);
}
}
if(wH_Banlance.Stat_IsChanged)
{
if (wH_Banlance.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", wH_Banlance.Stat);
}
}
if(wH_Banlance.CreateDate_IsChanged)
{
if (wH_Banlance.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", wH_Banlance.CreateDate);
}
}
if(wH_Banlance.UpdateDate_IsChanged)
{
if (wH_Banlance.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", wH_Banlance.UpdateDate);
}
}
if(wH_Banlance.DeleteDate_IsChanged)
{
if (wH_Banlance.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", wH_Banlance.DeleteDate);
}
}
if(wH_Banlance.WHB_Invoice_IsChanged)
{
if (wH_Banlance.WHB_Invoice == 0)
{
idb.AddParameter("@WHB_Invoice", 0);
}
else
{
idb.AddParameter("@WHB_Invoice", wH_Banlance.WHB_Invoice);
}
}
if(wH_Banlance.WHB_Pay_IsChanged)
{
if (wH_Banlance.WHB_Pay == 0)
{
idb.AddParameter("@WHB_Pay", 0);
}
else
{
idb.AddParameter("@WHB_Pay", wH_Banlance.WHB_Pay);
}
}
if(wH_Banlance.WHB_RInvoice_IsChanged)
{
if (wH_Banlance.WHB_RInvoice == 0)
{
idb.AddParameter("@WHB_RInvoice", 0);
}
else
{
idb.AddParameter("@WHB_RInvoice", wH_Banlance.WHB_RInvoice);
}
}
if(wH_Banlance.WHB_RPay_IsChanged)
{
if (wH_Banlance.WHB_RPay == 0)
{
idb.AddParameter("@WHB_RPay", 0);
}
else
{
idb.AddParameter("@WHB_RPay", wH_Banlance.WHB_RPay);
}
}
if(wH_Banlance.WHB_NumLast_IsChanged)
{
if (wH_Banlance.WHB_NumLast == 0)
{
idb.AddParameter("@WHB_NumLast", 0);
}
else
{
idb.AddParameter("@WHB_NumLast", wH_Banlance.WHB_NumLast);
}
}
if(wH_Banlance.WHB_NumCur_IsChanged)
{
if (wH_Banlance.WHB_NumCur == 0)
{
idb.AddParameter("@WHB_NumCur", 0);
}
else
{
idb.AddParameter("@WHB_NumCur", wH_Banlance.WHB_NumCur);
}
}
if(wH_Banlance.WHB_NumReturn_IsChanged)
{
if (wH_Banlance.WHB_NumReturn == 0)
{
idb.AddParameter("@WHB_NumReturn", 0);
}
else
{
idb.AddParameter("@WHB_NumReturn", wH_Banlance.WHB_NumReturn);
}
}
if(wH_Banlance.WHB_NumReal_IsChanged)
{
if (wH_Banlance.WHB_NumReal == 0)
{
idb.AddParameter("@WHB_NumReal", 0);
}
else
{
idb.AddParameter("@WHB_NumReal", wH_Banlance.WHB_NumReal);
}
}
idb.AddParameter("@WHB_ID", wH_Banlance.WHB_ID);
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name,Ex);
return Re;
/// <summary>
/// 获取指定的结算单 WH_Banlance对象集合
/// </summary>
public List<WH_Banlance> GetListByWhere(string strCondition)
{
List<WH_Banlance> ret = new List<WH_Banlance>();
string sql = "SELECT WHB_ID,WHB_Period,WHB_iType,WHB_Code,WHB_UCompany,WHB_UCompanyCode,WHB_SCode,WHB_SName,WHB_LastMonth,WHB_CurMonth,WHB_CurPay,WHB_CurLeft,WHB_Plan,WHB_NextMonth,WHB_broom,WHB_Recive,WHB_Date,WHB_Status,WHB_UDEF1,WHB_UDEF2,WHB_UDEF3,WHB_UDEF4,WHB_UDEF5,WHB_UDEF6,WHB_UDEF7,WHB_UDEF8,WHB_UDEF9,WHB_UDEF10,Stat,CreateDate,UpdateDate,DeleteDate,WHB_Invoice,WHB_Pay,WHB_RInvoice,WHB_RPay,WHB_NumLast,WHB_NumCur,WHB_NumReturn,WHB_NumReal FROM WH_Banlance WHERE 1=1 AND ((Stat is null) or (Stat=0) ) ";
if(!string.IsNullOrEmpty(strCondition))
{
strCondition.Replace('\'','"'); //防sql注入
sql += strCondition ;
}
SqlDataReader dr=null;
try {
dr=(SqlDataReader)idb.ReturnReader(sql);
while(dr.Read())
{
WH_Banlance wH_Banlance = new WH_Banlance();
if (dr["WHB_ID"] != DBNull.Value) wH_Banlance.WHB_ID = Convert.ToDecimal(dr["WHB_ID"]);
if (dr["WHB_Period"] != DBNull.Value) wH_Banlance.WHB_Period = Convert.ToString(dr["WHB_Period"]);
if (dr["WHB_iType"] != DBNull.Value) wH_Banlance.WHB_iType = Convert.ToString(dr["WHB_iType"]);
if (dr["WHB_Code"] != DBNull.Value) wH_Banlance.WHB_Code = Convert.ToString(dr["WHB_Code"]);
if (dr["WHB_UCompany"] != DBNull.Value) wH_Banlance.WHB_UCompany = Convert.ToString(dr["WHB_UCompany"]);
if (dr["WHB_UCompanyCode"] != DBNull.Value) wH_Banlance.WHB_UCompanyCode = Convert.ToString(dr["WHB_UCompanyCode"]);
if (dr["WHB_SCode"] != DBNull.Value) wH_Banlance.WHB_SCode = Convert.ToString(dr["WHB_SCode"]);
if (dr["WHB_SName"] != DBNull.Value) wH_Banlance.WHB_SName = Convert.ToString(dr["WHB_SName"]);
if (dr["WHB_LastMonth"] != DBNull.Value) wH_Banlance.WHB_LastMonth = Convert.ToDecimal(dr["WHB_LastMonth"]);
if (dr["WHB_CurMonth"] != DBNull.Value) wH_Banlance.WHB_CurMonth = Convert.ToDecimal(dr["WHB_CurMonth"]);
if (dr["WHB_CurPay"] != DBNull.Value) wH_Banlance.WHB_CurPay = Convert.ToDecimal(dr["WHB_CurPay"]);
if (dr["WHB_CurLeft"] != DBNull.Value) wH_Banlance.WHB_CurLeft = Convert.ToDecimal(dr["WHB_CurLeft"]);
if (dr["WHB_Plan"] != DBNull.Value) wH_Banlance.WHB_Plan = Convert.ToDecimal(dr["WHB_Plan"]);
if (dr["WHB_NextMonth"] != DBNull.Value) wH_Banlance.WHB_NextMonth = Convert.ToDecimal(dr["WHB_NextMonth"]);
if (dr["WHB_broom"] != DBNull.Value) wH_Banlance.WHB_broom = Convert.ToDecimal(dr["WHB_broom"]);
if (dr["WHB_Recive"] != DBNull.Value) wH_Banlance.WHB_Recive = Convert.ToDecimal(dr["WHB_Recive"]);
if (dr["WHB_Date"] != DBNull.Value) wH_Banlance.WHB_Date = Convert.ToDateTime(dr["WHB_Date"]);
if (dr["WHB_Status"] != DBNull.Value) wH_Banlance.WHB_Status = Convert.ToString(dr["WHB_Status"]);
if (dr["WHB_UDEF1"] != DBNull.Value) wH_Banlance.WHB_UDEF1 = Convert.ToString(dr["WHB_UDEF1"]);
if (dr["WHB_UDEF2"] != DBNull.Value) wH_Banlance.WHB_UDEF2 = Convert.ToString(dr["WHB_UDEF2"]);
if (dr["WHB_UDEF3"] != DBNull.Value) wH_Banlance.WHB_UDEF3 = Convert.ToString(dr["WHB_UDEF3"]);
if (dr["WHB_UDEF4"] != DBNull.Value) wH_Banlance.WHB_UDEF4 = Convert.ToString(dr["WHB_UDEF4"]);
if (dr["WHB_UDEF5"] != DBNull.Value) wH_Banlance.WHB_UDEF5 = Convert.ToString(dr["WHB_UDEF5"]);
if (dr["WHB_UDEF6"] != DBNull.Value) wH_Banlance.WHB_UDEF6 = Convert.ToString(dr["WHB_UDEF6"]);
if (dr["WHB_UDEF7"] != DBNull.Value) wH_Banlance.WHB_UDEF7 = Convert.ToString(dr["WHB_UDEF7"]);
if (dr["WHB_UDEF8"] != DBNull.Value) wH_Banlance.WHB_UDEF8 = Convert.ToString(dr["WHB_UDEF8"]);
if (dr["WHB_UDEF9"] != DBNull.Value) wH_Banlance.WHB_UDEF9 = Convert.ToString(dr["WHB_UDEF9"]);
if (dr["WHB_UDEF10"] != DBNull.Value) wH_Banlance.WHB_UDEF10 = Convert.ToString(dr["WHB_UDEF10"]);
if (dr["Stat"] != DBNull.Value) wH_Banlance.Stat = Convert.ToInt32(dr["Stat"]);
if (dr["CreateDate"] != DBNull.Value) wH_Banlance.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
if (dr["UpdateDate"] != DBNull.Value) wH_Banlance.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]);
if (dr["DeleteDate"] != DBNull.Value) wH_Banlance.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]);
if (dr["WHB_Invoice"] != DBNull.Value) wH_Banlance.WHB_Invoice = Convert.ToDecimal(dr["WHB_Invoice"]);
if (dr["WHB_Pay"] != DBNull.Value) wH_Banlance.WHB_Pay = Convert.ToDecimal(dr["WHB_Pay"]);
if (dr["WHB_RInvoice"] != DBNull.Value) wH_Banlance.WHB_RInvoice = Convert.ToDecimal(dr["WHB_RInvoice"]);
if (dr["WHB_RPay"] != DBNull.Value) wH_Banlance.WHB_RPay = Convert.ToDecimal(dr["WHB_RPay"]);
if (dr["WHB_NumLast"] != DBNull.Value) wH_Banlance.WHB_NumLast = Convert.ToDecimal(dr["WHB_NumLast"]);
if (dr["WHB_NumCur"] != DBNull.Value) wH_Banlance.WHB_NumCur = Convert.ToDecimal(dr["WHB_NumCur"]);
if (dr["WHB_NumReturn"] != DBNull.Value) wH_Banlance.WHB_NumReturn = Convert.ToDecimal(dr["WHB_NumReturn"]);
if (dr["WHB_NumReal"] != DBNull.Value) wH_Banlance.WHB_NumReal = Convert.ToDecimal(dr["WHB_NumReal"]);
ret.Add(wH_Banlance);
}
}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>
/// 获取指定的结算单 WH_Banlance对象(即:一条记录
/// </summary>
public WH_Banlance GetByKey(decimal wHB_ID)
{
WH_Banlance wH_Banlance = new WH_Banlance();
string sql = "SELECT WHB_ID,WHB_Period,WHB_iType,WHB_Code,WHB_UCompany,WHB_UCompanyCode,WHB_SCode,WHB_SName,WHB_LastMonth,WHB_CurMonth,WHB_CurPay,WHB_CurLeft,WHB_Plan,WHB_NextMonth,WHB_broom,WHB_Recive,WHB_Date,WHB_Status,WHB_UDEF1,WHB_UDEF2,WHB_UDEF3,WHB_UDEF4,WHB_UDEF5,WHB_UDEF6,WHB_UDEF7,WHB_UDEF8,WHB_UDEF9,WHB_UDEF10,Stat,CreateDate,UpdateDate,DeleteDate,WHB_Invoice,WHB_Pay,WHB_RInvoice,WHB_RPay,WHB_NumLast,WHB_NumCur,WHB_NumReturn,WHB_NumReal FROM WH_Banlance WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND WHB_ID=@WHB_ID ";
idb.AddParameter("@WHB_ID", wHB_ID);
SqlDataReader dr=null;
try {
dr=(SqlDataReader)idb.ReturnReader(sql);
while(dr.Read())
{
if (dr["WHB_ID"] != DBNull.Value) wH_Banlance.WHB_ID = Convert.ToDecimal(dr["WHB_ID"]);
if (dr["WHB_Period"] != DBNull.Value) wH_Banlance.WHB_Period = Convert.ToString(dr["WHB_Period"]);
if (dr["WHB_iType"] != DBNull.Value) wH_Banlance.WHB_iType = Convert.ToString(dr["WHB_iType"]);
if (dr["WHB_Code"] != DBNull.Value) wH_Banlance.WHB_Code = Convert.ToString(dr["WHB_Code"]);
if (dr["WHB_UCompany"] != DBNull.Value) wH_Banlance.WHB_UCompany = Convert.ToString(dr["WHB_UCompany"]);
if (dr["WHB_UCompanyCode"] != DBNull.Value) wH_Banlance.WHB_UCompanyCode = Convert.ToString(dr["WHB_UCompanyCode"]);
if (dr["WHB_SCode"] != DBNull.Value) wH_Banlance.WHB_SCode = Convert.ToString(dr["WHB_SCode"]);
if (dr["WHB_SName"] != DBNull.Value) wH_Banlance.WHB_SName = Convert.ToString(dr["WHB_SName"]);
if (dr["WHB_LastMonth"] != DBNull.Value) wH_Banlance.WHB_LastMonth = Convert.ToDecimal(dr["WHB_LastMonth"]);
if (dr["WHB_CurMonth"] != DBNull.Value) wH_Banlance.WHB_CurMonth = Convert.ToDecimal(dr["WHB_CurMonth"]);
if (dr["WHB_CurPay"] != DBNull.Value) wH_Banlance.WHB_CurPay = Convert.ToDecimal(dr["WHB_CurPay"]);
if (dr["WHB_CurLeft"] != DBNull.Value) wH_Banlance.WHB_CurLeft = Convert.ToDecimal(dr["WHB_CurLeft"]);
if (dr["WHB_Plan"] != DBNull.Value) wH_Banlance.WHB_Plan = Convert.ToDecimal(dr["WHB_Plan"]);
if (dr["WHB_NextMonth"] != DBNull.Value) wH_Banlance.WHB_NextMonth = Convert.ToDecimal(dr["WHB_NextMonth"]);
if (dr["WHB_broom"] != DBNull.Value) wH_Banlance.WHB_broom = Convert.ToDecimal(dr["WHB_broom"]);
if (dr["WHB_Recive"] != DBNull.Value) wH_Banlance.WHB_Recive = Convert.ToDecimal(dr["WHB_Recive"]);
if (dr["WHB_Date"] != DBNull.Value) wH_Banlance.WHB_Date = Convert.ToDateTime(dr["WHB_Date"]);
if (dr["WHB_Status"] != DBNull.Value) wH_Banlance.WHB_Status = Convert.ToString(dr["WHB_Status"]);
if (dr["WHB_UDEF1"] != DBNull.Value) wH_Banlance.WHB_UDEF1 = Convert.ToString(dr["WHB_UDEF1"]);
if (dr["WHB_UDEF2"] != DBNull.Value) wH_Banlance.WHB_UDEF2 = Convert.ToString(dr["WHB_UDEF2"]);
if (dr["WHB_UDEF3"] != DBNull.Value) wH_Banlance.WHB_UDEF3 = Convert.ToString(dr["WHB_UDEF3"]);
if (dr["WHB_UDEF4"] != DBNull.Value) wH_Banlance.WHB_UDEF4 = Convert.ToString(dr["WHB_UDEF4"]);
if (dr["WHB_UDEF5"] != DBNull.Value) wH_Banlance.WHB_UDEF5 = Convert.ToString(dr["WHB_UDEF5"]);
if (dr["WHB_UDEF6"] != DBNull.Value) wH_Banlance.WHB_UDEF6 = Convert.ToString(dr["WHB_UDEF6"]);
if (dr["WHB_UDEF7"] != DBNull.Value) wH_Banlance.WHB_UDEF7 = Convert.ToString(dr["WHB_UDEF7"]);
if (dr["WHB_UDEF8"] != DBNull.Value) wH_Banlance.WHB_UDEF8 = Convert.ToString(dr["WHB_UDEF8"]);
if (dr["WHB_UDEF9"] != DBNull.Value) wH_Banlance.WHB_UDEF9 = Convert.ToString(dr["WHB_UDEF9"]);
if (dr["WHB_UDEF10"] != DBNull.Value) wH_Banlance.WHB_UDEF10 = Convert.ToString(dr["WHB_UDEF10"]);
if (dr["Stat"] != DBNull.Value) wH_Banlance.Stat = Convert.ToInt32(dr["Stat"]);
if (dr["CreateDate"] != DBNull.Value) wH_Banlance.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
if (dr["UpdateDate"] != DBNull.Value) wH_Banlance.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]);
if (dr["DeleteDate"] != DBNull.Value) wH_Banlance.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]);
if (dr["WHB_Invoice"] != DBNull.Value) wH_Banlance.WHB_Invoice = Convert.ToDecimal(dr["WHB_Invoice"]);
if (dr["WHB_Pay"] != DBNull.Value) wH_Banlance.WHB_Pay = Convert.ToDecimal(dr["WHB_Pay"]);
if (dr["WHB_RInvoice"] != DBNull.Value) wH_Banlance.WHB_RInvoice = Convert.ToDecimal(dr["WHB_RInvoice"]);
if (dr["WHB_RPay"] != DBNull.Value) wH_Banlance.WHB_RPay = Convert.ToDecimal(dr["WHB_RPay"]);
if (dr["WHB_NumLast"] != DBNull.Value) wH_Banlance.WHB_NumLast = Convert.ToDecimal(dr["WHB_NumLast"]);
if (dr["WHB_NumCur"] != DBNull.Value) wH_Banlance.WHB_NumCur = Convert.ToDecimal(dr["WHB_NumCur"]);
if (dr["WHB_NumReturn"] != DBNull.Value) wH_Banlance.WHB_NumReturn = Convert.ToDecimal(dr["WHB_NumReturn"]);
if (dr["WHB_NumReal"] != DBNull.Value) wH_Banlance.WHB_NumReal = Convert.ToDecimal(dr["WHB_NumReal"]);
}
}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 wH_Banlance;
}
/// <summary>
/// 添加结算单 WH_Banlance对象(即:一条记录)
/// </summary>
public object AddWithReturn(WH_Banlance wH_Banlance)
{
string sql = "INSERT INTO WH_Banlance (WHB_Period,WHB_iType,WHB_Code,WHB_UCompany,WHB_UCompanyCode,WHB_SCode,WHB_SName,WHB_LastMonth,WHB_CurMonth,WHB_CurPay,WHB_CurLeft,WHB_Plan,WHB_NextMonth,WHB_broom,WHB_Recive,WHB_Date,WHB_Status,WHB_UDEF1,WHB_UDEF2,WHB_UDEF3,WHB_UDEF4,WHB_UDEF5,WHB_UDEF6,WHB_UDEF7,WHB_UDEF8,WHB_UDEF9,WHB_UDEF10,Stat,CreateDate,UpdateDate,DeleteDate,WHB_Invoice,WHB_Pay,WHB_RInvoice,WHB_RPay,WHB_NumLast,WHB_NumCur,WHB_NumReturn,WHB_NumReal) VALUES (@WHB_Period,@WHB_iType,@WHB_Code,@WHB_UCompany,@WHB_UCompanyCode,@WHB_SCode,@WHB_SName,@WHB_LastMonth,@WHB_CurMonth,@WHB_CurPay,@WHB_CurLeft,@WHB_Plan,@WHB_NextMonth,@WHB_broom,@WHB_Recive,@WHB_Date,@WHB_Status,@WHB_UDEF1,@WHB_UDEF2,@WHB_UDEF3,@WHB_UDEF4,@WHB_UDEF5,@WHB_UDEF6,@WHB_UDEF7,@WHB_UDEF8,@WHB_UDEF9,@WHB_UDEF10,@Stat,@CreateDate,@UpdateDate,@DeleteDate,@WHB_Invoice,@WHB_Pay,@WHB_RInvoice,@WHB_RPay,@WHB_NumLast,@WHB_NumCur,@WHB_NumReturn,@WHB_NumReal);SELECT @@IDENTITY AS ReturnID;";
if (string.IsNullOrEmpty(wH_Banlance.WHB_Period))
{
idb.AddParameter("@WHB_Period", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_Period", wH_Banlance.WHB_Period);
}
if (string.IsNullOrEmpty(wH_Banlance.WHB_iType))
{
idb.AddParameter("@WHB_iType", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_iType", wH_Banlance.WHB_iType);
}
if (string.IsNullOrEmpty(wH_Banlance.WHB_Code))
{
idb.AddParameter("@WHB_Code", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_Code", wH_Banlance.WHB_Code);
}
if (string.IsNullOrEmpty(wH_Banlance.WHB_UCompany))
{
idb.AddParameter("@WHB_UCompany", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UCompany", wH_Banlance.WHB_UCompany);
}
if (string.IsNullOrEmpty(wH_Banlance.WHB_UCompanyCode))
{
idb.AddParameter("@WHB_UCompanyCode", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UCompanyCode", wH_Banlance.WHB_UCompanyCode);
}
if (string.IsNullOrEmpty(wH_Banlance.WHB_SCode))
{
idb.AddParameter("@WHB_SCode", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_SCode", wH_Banlance.WHB_SCode);
}
if (string.IsNullOrEmpty(wH_Banlance.WHB_SName))
{
idb.AddParameter("@WHB_SName", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_SName", wH_Banlance.WHB_SName);
}
if (wH_Banlance.WHB_LastMonth == 0)
{
idb.AddParameter("@WHB_LastMonth", 0);
}
else
{
idb.AddParameter("@WHB_LastMonth", wH_Banlance.WHB_LastMonth);
}
if (wH_Banlance.WHB_CurMonth == 0)
{
idb.AddParameter("@WHB_CurMonth", 0);
}
else
{
idb.AddParameter("@WHB_CurMonth", wH_Banlance.WHB_CurMonth);
}
if (wH_Banlance.WHB_CurPay == 0)
{
idb.AddParameter("@WHB_CurPay", 0);
}
else
{
idb.AddParameter("@WHB_CurPay", wH_Banlance.WHB_CurPay);
}
if (wH_Banlance.WHB_CurLeft == 0)
{
idb.AddParameter("@WHB_CurLeft", 0);
}
else
{
idb.AddParameter("@WHB_CurLeft", wH_Banlance.WHB_CurLeft);
}
if (wH_Banlance.WHB_Plan == 0)
{
idb.AddParameter("@WHB_Plan", 0);
}
else
{
idb.AddParameter("@WHB_Plan", wH_Banlance.WHB_Plan);
}
if (wH_Banlance.WHB_NextMonth == 0)
{
idb.AddParameter("@WHB_NextMonth", 0);
}
else
{
idb.AddParameter("@WHB_NextMonth", wH_Banlance.WHB_NextMonth);
}
if (wH_Banlance.WHB_broom == 0)
{
idb.AddParameter("@WHB_broom", 0);
}
else
{
idb.AddParameter("@WHB_broom", wH_Banlance.WHB_broom);
}
if (wH_Banlance.WHB_Recive == 0)
{
idb.AddParameter("@WHB_Recive", 0);
}
else
{
idb.AddParameter("@WHB_Recive", wH_Banlance.WHB_Recive);
}
if (wH_Banlance.WHB_Date == DateTime.MinValue)
{
idb.AddParameter("@WHB_Date", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_Date", wH_Banlance.WHB_Date);
}
if (string.IsNullOrEmpty(wH_Banlance.WHB_Status))
{
idb.AddParameter("@WHB_Status", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_Status", wH_Banlance.WHB_Status);
}
if (string.IsNullOrEmpty(wH_Banlance.WHB_UDEF1))
{
idb.AddParameter("@WHB_UDEF1", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UDEF1", wH_Banlance.WHB_UDEF1);
}
if (string.IsNullOrEmpty(wH_Banlance.WHB_UDEF2))
{
idb.AddParameter("@WHB_UDEF2", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UDEF2", wH_Banlance.WHB_UDEF2);
}
if (string.IsNullOrEmpty(wH_Banlance.WHB_UDEF3))
{
idb.AddParameter("@WHB_UDEF3", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UDEF3", wH_Banlance.WHB_UDEF3);
}
if (string.IsNullOrEmpty(wH_Banlance.WHB_UDEF4))
{
idb.AddParameter("@WHB_UDEF4", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UDEF4", wH_Banlance.WHB_UDEF4);
}
if (string.IsNullOrEmpty(wH_Banlance.WHB_UDEF5))
{
idb.AddParameter("@WHB_UDEF5", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UDEF5", wH_Banlance.WHB_UDEF5);
}
if (string.IsNullOrEmpty(wH_Banlance.WHB_UDEF6))
{
idb.AddParameter("@WHB_UDEF6", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UDEF6", wH_Banlance.WHB_UDEF6);
}
if (string.IsNullOrEmpty(wH_Banlance.WHB_UDEF7))
{
idb.AddParameter("@WHB_UDEF7", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UDEF7", wH_Banlance.WHB_UDEF7);
}
if (string.IsNullOrEmpty(wH_Banlance.WHB_UDEF8))
{
idb.AddParameter("@WHB_UDEF8", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UDEF8", wH_Banlance.WHB_UDEF8);
}
if (string.IsNullOrEmpty(wH_Banlance.WHB_UDEF9))
{
idb.AddParameter("@WHB_UDEF9", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UDEF9", wH_Banlance.WHB_UDEF9);
}
if (string.IsNullOrEmpty(wH_Banlance.WHB_UDEF10))
{
idb.AddParameter("@WHB_UDEF10", DBNull.Value);
}
else
{
idb.AddParameter("@WHB_UDEF10", wH_Banlance.WHB_UDEF10);
}
if (wH_Banlance.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", wH_Banlance.Stat);
}
if (wH_Banlance.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", wH_Banlance.CreateDate);
}
if (wH_Banlance.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", wH_Banlance.UpdateDate);
}
if (wH_Banlance.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", wH_Banlance.DeleteDate);
}
if (wH_Banlance.WHB_Invoice == 0)
{
idb.AddParameter("@WHB_Invoice", 0);
}
else
{
idb.AddParameter("@WHB_Invoice", wH_Banlance.WHB_Invoice);
}
if (wH_Banlance.WHB_Pay == 0)
{
idb.AddParameter("@WHB_Pay", 0);
}
else
{
idb.AddParameter("@WHB_Pay", wH_Banlance.WHB_Pay);
}
if (wH_Banlance.WHB_RInvoice == 0)
{
idb.AddParameter("@WHB_RInvoice", 0);
}
else
{
idb.AddParameter("@WHB_RInvoice", wH_Banlance.WHB_RInvoice);
}
if (wH_Banlance.WHB_RPay == 0)
{
idb.AddParameter("@WHB_RPay", 0);
}
else
{
idb.AddParameter("@WHB_RPay", wH_Banlance.WHB_RPay);
}
if (wH_Banlance.WHB_NumLast == 0)
{
idb.AddParameter("@WHB_NumLast", 0);
}
else
{
idb.AddParameter("@WHB_NumLast", wH_Banlance.WHB_NumLast);
}
if (wH_Banlance.WHB_NumCur == 0)
{
idb.AddParameter("@WHB_NumCur", 0);
}
else
{
idb.AddParameter("@WHB_NumCur", wH_Banlance.WHB_NumCur);
}
if (wH_Banlance.WHB_NumReturn == 0)
{
idb.AddParameter("@WHB_NumReturn", 0);
}
else
{
idb.AddParameter("@WHB_NumReturn", wH_Banlance.WHB_NumReturn);
}
if (wH_Banlance.WHB_NumReal == 0)
{
idb.AddParameter("@WHB_NumReal", 0);
}
else
{
idb.AddParameter("@WHB_NumReal", wH_Banlance.WHB_NumReal);
}
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
var Return = idb.ReturnValue(sql);
Ex = Return.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name,Ex);
return Re;
}
