/// <summary>
/// 得到一个对象实体
/// </summary>
public OrderDetInfo DataRowToOrderDetModel(DataRow row)
{
OrderDetInfo model = new OrderDetInfo();
if (row != null)
{
if (row["ORDERDETID"] != null)
{
model.ORDERDETID = row["ORDERDETID"].ToString();
}
if (row["ORDERID"] != null)
{
model.ORDERID = row["ORDERID"].ToString();
}
if (row["CONTACTID"] != null)
{
model.CONTACTID = row["CONTACTID"].ToString();
}
if (row["PRODUCTTYPE1"] != null)
{
model.PRODUCTTYPE1 = row["PRODUCTTYPE1"].ToString();
}
if (row["SOLDWITH"] != null)
{
model.SOLDWITH = row["SOLDWITH"].ToString();
}
if (row["STATUS"] != null)
{
model.STATUS = row["STATUS"].ToString();
}
if (row["RECKONING"] != null)
{
model.RECKONING = row["RECKONING"].ToString();
}
if (row["RECKONINGDT"] != null && row["RECKONINGDT"].ToString() != "")
{
model.RECKONINGDT = row["RECKONINGDT"].ToString();
}
if (row["FBDT"] != null && row["FBDT"].ToString() != "")
{
model.FBDT = row["FBDT"].ToString();
}
if (row["UPRICE"] != null && row["UPRICE"].ToString() != "")
{
model.UPRICE = row["UPRICE"].ToString();
}
if (row["PRODNUM"] != null && row["PRODNUM"].ToString() != "")
{
model.PRODNUM = row["PRODNUM"].ToString();
}
if (row["FREIGHT"] != null && row["FREIGHT"].ToString() != "")
{
model.FREIGHT = row["FREIGHT"].ToString();
}
if (row["PAYMENT"] != null && row["PAYMENT"].ToString() != "")
{
model.PAYMENT = row["PAYMENT"].ToString();
}
if (row["POSTFEE"] != null && row["POSTFEE"].ToString() != "")
{
model.POSTFEE = row["POSTFEE"].ToString();
}
if (row["CLEARFEE"] != null && row["CLEARFEE"].ToString() != "")
{
model.CLEARFEE = row["CLEARFEE"].ToString();
}
if (row["CRDT"] != null && row["CRDT"].ToString() != "")
{
model.CRDT = row["CRDT"].ToString();
}
if (row["BREASON"] != null)
{
model.BREASON = row["BREASON"].ToString();
}
if (row["FEEDBACK"] != null)
{
model.FEEDBACK = row["FEEDBACK"].ToString();
}
if (row["GOODSBACK"] != null)
{
model.GOODSBACK = row["GOODSBACK"].ToString();
}
if (row["BACKDT"] != null && row["BACKDT"].ToString() != "")
{
model.BACKDT = row["BACKDT"].ToString();
}
if (row["BACKMONEY"] != null && row["BACKMONEY"].ToString() != "")
{
model.BACKMONEY = row["BACKMONEY"].ToString();
}
if (row["CARDRIGHTNUM"] != null)
{
model.CARDRIGHTNUM = row["CARDRIGHTNUM"].ToString();
}
if (row["ACCOUNTINGCOST"] != null && row["ACCOUNTINGCOST"].ToString() != "")
{
model.ACCOUNTINGCOST = row["ACCOUNTINGCOST"].ToString();
}
if (row["PRODBANKID"] != null)
{
model.PRODBANKID = row["PRODBANKID"].ToString();
}
if (row["ISREFUND"] != null)
{
model.ISREFUND = row["ISREFUND"].ToString();
}
if (row["REFUNDDT"] != null && row["REFUNDDT"].ToString() != "")
{
model.REFUNDDT = row["REFUNDDT"].ToString();
}
if (row["PRODDETID"] != null)
{
model.PRODDETID = row["PRODDETID"].ToString();
}
}
return model;
}
public void deleteAddOrderDetData(SqlLib lib, IDb db, object obj, ref DataTable outOrderDetDt)
{
string sql = "";
bool ret = true;
try
{
OrderDetInfo OrderDetinfo = new OrderDetInfo();
ret = DataHandle.CompareObjectType(obj, OrderDetinfo);
if (ret)
{
OrderDetinfo = (OrderDetInfo)obj;
}
else
{
return;
}
if (outOrderDetDt == null)
{
throw new NullReferenceException("outOrderDetInfo is null");
}
DataTable localdt = new DataTable();
sql = lib.GetSql("SqlOrderDetInfo/OrderDetInfo", "GetOrderDetInfo");
if (!string.IsNullOrEmpty(OrderDetinfo.ORDERDETID))
{
sql += " and ORDERDETID='" + OrderDetinfo.ORDERDETID + " '";
}
else
{
throw new NullReferenceException("保单详细信息不能为空");
}
if (!string.IsNullOrEmpty(sql))
{
localdt = db.GetTable(sql);
}
for (int i = 0; i < localdt.Rows.Count; i++)
{
DataRow dr = localdt.Rows[i];
dr.Delete();
}
}
catch (NullReferenceException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteContractData" + ex.Message);
}
catch (ArrayTypeMismatchException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteContractData" + ex.Message);
}
catch (Exception ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteContractData" + ex.Message);
throw;
}
}
public void addNewOrderDetData(SqlLib lib, IDb db, object obj, ref DataTable outOrderDetDt)
{
string sql = "";
string localID = "";
bool ret = false;
try
{
OrderDetInfo li = new OrderDetInfo();
ret = DataHandle.CompareObjectType(obj, li);
if (ret)
{
li = (OrderDetInfo)obj;
}
else
{
return;
}
if (outOrderDetDt == null)
{
throw new NullReferenceException("outOrderDetDt is null");
}
DataTable localDt = new DataTable();
//只取一条记录，以便得到表结构，如果一条都没有，那么会有什么结果？能够取出表结构。
sql = lib.GetSql("SqlOrderDetInfo/OrderDetInfo", "GetOrderDetStructInfo");
localDt = db.GetTable(sql);
//新增加的记录，在oracle中需要取到sequence编号
sql = lib.GetSql("SqlOrderDetInfo/OrderDetInfo", "GetNewOrderDetId");
DataTable dt = new DataTable();
dt = db.GetTable(sql);
if (dt.Rows.Count > 0)
{
localID = dt.Rows[0][0].ToString();
dt.Reset();
}
if (string.IsNullOrEmpty(localID))
{
return;
}
DataRow dr = localDt.NewRow();
dr["ORDERDETID"] = DataHandle.EmptyString2DBNull(localID);
dr["ACCOUNTINGCOST"] = DataHandle.EmptyString2DBNull(li.ACCOUNTINGCOST);
dr["BACKDT"] = DataHandle.EmptyString2DBNull(li.BACKDT);
dr["BACKMONEY"] = DataHandle.EmptyString2DBNull(li.BACKMONEY);
dr["BREASON"] = DataHandle.EmptyString2DBNull(li.BREASON);
dr["CARDRIGHTNUM"] = DataHandle.EmptyString2DBNull(li.CARDRIGHTNUM);
dr["CLEARFEE"] = DataHandle.EmptyString2DBNull(li.CLEARFEE);
dr["CONTACTID"] = DataHandle.EmptyString2DBNull(li.CONTACTID);
dr["CRDT"] = DataHandle.EmptyString2DBNull(li.CRDT);
dr["FBDT"] = DataHandle.EmptyString2DBNull(li.FBDT);
dr["FEEDBACK"] = DataHandle.EmptyString2DBNull(li.FEEDBACK);
dr["FREIGHT"] = DataHandle.EmptyString2DBNull(li.FREIGHT);
dr["GOODSBACK"] = DataHandle.EmptyString2DBNull(li.GOODSBACK);
dr["ISREFUND"] = DataHandle.EmptyString2DBNull(li.ISREFUND);
dr["ORDERID"] = DataHandle.EmptyString2DBNull(li.ORDERID);
dr["PAYMENT"] = DataHandle.EmptyString2DBNull(li.PAYMENT);
dr["POSTFEE"] = DataHandle.EmptyString2DBNull(li.POSTFEE);
dr["PRODBANKID"] = DataHandle.EmptyString2DBNull(li.PRODBANKID);
dr["PRODDETID"] = DataHandle.EmptyString2DBNull(li.PRODDETID);
dr["PRODNUM"] = DataHandle.EmptyString2DBNull(li.PRODNUM);
dr["PRODUCTTYPE1"] = DataHandle.EmptyString2DBNull(li.PRODUCTTYPE1);
dr["RECKONING"] = DataHandle.EmptyString2DBNull(li.RECKONING);
dr["RECKONINGDT"] = DataHandle.EmptyString2DBNull(li.RECKONINGDT);
dr["REFUNDDT"] = DataHandle.EmptyString2DBNull(li.REFUNDDT);
dr["SOLDWITH"] = DataHandle.EmptyString2DBNull(li.SOLDWITH);
dr["STATUS"] = DataHandle.EmptyString2DBNull(li.STATUS);
dr["UPRICE"] = DataHandle.EmptyString2DBNull(li.UPRICE);
localDt.Rows.Add(dr);
outOrderDetDt.Merge(localDt, true);
}
catch (NullReferenceException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in addNewOrderDetData" + ex.Message);
}
catch (ArrayTypeMismatchException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in addNewOrderDetData" + ex.Message);
}
catch (Exception ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in addNewOrderDetData" + ex.Message);
throw;
}
}
public void updateOrderDetData(SqlLib lib, IDb db, object obj, ref DataTable outOrderDetDt)
{
string sql = "";
bool ret = true;
try
{
OrderDetInfo li = new OrderDetInfo();
ret = DataHandle.CompareObjectType(obj, li);
if (ret)
{
li = (OrderDetInfo)obj;
}
else
{
return;
}
if (outOrderDetDt == null)
{
throw new NullReferenceException("outOrderDerDt is null");
}
DataTable localDt = new DataTable();
//根据Id更新一条数据信息
sql = lib.GetSql("SqlOrderDetInfo/OrderDetInfo", "GetOrderDetInfo");
localDt = db.GetTable(sql);
if (!string.IsNullOrEmpty(li.ORDERID))
{
sql += " and ORDERDETID='" + li.ORDERDETID + "'";
localDt = db.GetTable(sql);
if (localDt.Rows.Count > 0)
{
DataRow dr = localDt.NewRow();
dr["ORDERDETID"] = DataHandle.EmptyString2DBNull(li.ORDERDETID);
dr["ACCOUNTINGCOST"] = DataHandle.EmptyString2DBNull(li.ACCOUNTINGCOST);
dr["BACKDT"] = DataHandle.EmptyString2DBNull(li.BACKDT);
dr["BACKMONEY"] = DataHandle.EmptyString2DBNull(li.BACKMONEY);
dr["BREASON"] = DataHandle.EmptyString2DBNull(li.BREASON);
dr["CARDRIGHTNUM"] = DataHandle.EmptyString2DBNull(li.CARDRIGHTNUM);
dr["CLEARFEE"] = DataHandle.EmptyString2DBNull(li.CLEARFEE);
dr["CONTACTID"] = DataHandle.EmptyString2DBNull(li.CONTACTID);
dr["CRDT"] = DataHandle.EmptyString2DBNull(li.CRDT);
dr["FBDT"] = DataHandle.EmptyString2DBNull(li.FBDT);
dr["FEEDBACK"] = DataHandle.EmptyString2DBNull(li.FEEDBACK);
dr["FREIGHT"] = DataHandle.EmptyString2DBNull(li.FREIGHT);
dr["GOODSBACK"] = DataHandle.EmptyString2DBNull(li.GOODSBACK);
dr["ISREFUND"] = DataHandle.EmptyString2DBNull(li.ISREFUND);
dr["ORDERID"] = DataHandle.EmptyString2DBNull(li.ORDERID);
dr["PAYMENT"] = DataHandle.EmptyString2DBNull(li.PAYMENT);
dr["POSTFEE"] = DataHandle.EmptyString2DBNull(li.POSTFEE);
dr["PRODBANKID"] = DataHandle.EmptyString2DBNull(li.PRODBANKID);
dr["PRODDETID"] = DataHandle.EmptyString2DBNull(li.PRODDETID);
dr["PRODNUM"] = DataHandle.EmptyString2DBNull(li.PRODNUM);
dr["PRODUCTTYPE1"] = DataHandle.EmptyString2DBNull(li.PRODUCTTYPE1);
dr["RECKONING"] = DataHandle.EmptyString2DBNull(li.RECKONING);
dr["RECKONINGDT"] = DataHandle.EmptyString2DBNull(li.RECKONINGDT);
dr["REFUNDDT"] = DataHandle.EmptyString2DBNull(li.REFUNDDT);
dr["SOLDWITH"] = DataHandle.EmptyString2DBNull(li.SOLDWITH);
dr["STATUS"] = DataHandle.EmptyString2DBNull(li.STATUS);
dr["UPRICE"] = DataHandle.EmptyString2DBNull(li.UPRICE);
dr.EndEdit();
outOrderDetDt.Merge(localDt, true);
}
}
}
catch (NullReferenceException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in updateOrderDetData" + ex.Message);
}
catch (ArrayTypeMismatchException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in updateOrderDetData" + ex.Message);
}
catch (Exception ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in updateOrderDetData" + ex.Message);
throw;
}
}
public List<OrderInfo> outOrderInfo(string queryString)
{
List<OrderInfo> localOrderInfo = new List<OrderInfo>();
if (string.IsNullOrEmpty(queryString))
{
return localOrderInfo;
}
try
{
CTrace.WriteLine(CTrace.TraceLevel.Info, "Insurance outProductDetInfoSearch Search.");
SqlLib lib = SpecialSqlLib.CreateLib();
IDb db = DataManager.CreateDb();
if (db != null)
{
string sql = "";
string sqlInsuranceUsrInfo = "";
DataTable localInsuranceUsrInfodt = new DataTable();
/// 投保人 受益人 被保人 的sql
sqlInsuranceUsrInfo = lib.GetSql("SqlInsuranceUsrInfo/InsuranceUsrInfo", "GetInsuranceUsrInfo");
sql = lib.GetSql("SqlOrderInfo/OrderInfo", "GetOrderHistInfo");
sql = sql + queryString;
/// 保险人信息
InsuranceUsrInfo localInsuranceUsrInfo = new InsuranceUsrInfo();
CTrace.WriteLine(CTrace.TraceLevel.Info, "insurance.outOrderInfo sql={0}.", sql);
DataTable dt = db.GetTable(sql);
OrderInfo model = new OrderInfo();
foreach (DataRow row in dt.Rows)
{
if (row != null)
{
model = DataRowToOrderModel(row);
OrderDetInfo localOrderDetInfo = new OrderDetInfo();
DataTable dtOrderDetInfo = new DataTable();
sql = lib.GetSql("SqlOrderDetInfo/OrderDetInfo", "GetOrderDetInfo");
sql = string.Format(sql + " and orderid = '{0}' ", model.ORDERID);
dtOrderDetInfo = db.GetTable(sql);
foreach (DataRow rowDet in dtOrderDetInfo.Rows)
{
localOrderDetInfo = DataRowToOrderDetModel(rowDet);
model.ORDERDETINFO.Add(localOrderDetInfo);
}
/// 增加被保人信息
string sqlLSTINSURANT = string.Format(sqlInsuranceUsrInfo + " and insurance_usrid = '{0}' ", model.INSURANT);
localInsuranceUsrInfodt = db.GetTable(sqlLSTINSURANT);
if (localInsuranceUsrInfodt != null && localInsuranceUsrInfodt.Rows.Count > 0)
{
DataRow rowDet = localInsuranceUsrInfodt.Rows[0];
localInsuranceUsrInfo = DataRowToInsuranceUsrInfoModel(rowDet);
model.Insurant_usr = localInsuranceUsrInfo;
}
/// 收益人信息
InsuranceUsrInfo localBENEFICIARIES = new InsuranceUsrInfo();
string strBENEFICIARIES = "";
if (!string.IsNullOrEmpty(model.BENEFICIARIES))
{
strBENEFICIARIES = "'" + model.BENEFICIARIES + "'";
}
if (!string.IsNullOrEmpty(model.BENEFICIARIES2))
{
strBENEFICIARIES += ",'" + model.BENEFICIARIES2 + "'";
}
if (!string.IsNullOrEmpty(model.BENEFICIARIES3))
{
strBENEFICIARIES += ",'" + model.BENEFICIARIES3 + "'";
}
string sqlLstbeneficiaries = string.Format(sqlInsuranceUsrInfo + " and insurance_usrid in ({0}) ", strBENEFICIARIES);
localInsuranceUsrInfodt = db.GetTable(sqlLstbeneficiaries);
foreach (DataRow rowDet in localInsuranceUsrInfodt.Rows)
{
localInsuranceUsrInfo = DataRowToInsuranceUsrInfoModel(rowDet);
if (localInsuranceUsrInfo != null)
model.Lstbeneficiaries.Add(localInsuranceUsrInfo);
}
/// 投保人信息
InsuranceUsrInfo localPOLICYHOLDER = new InsuranceUsrInfo();
string sqlLstpolicyholder = string.Format(sqlInsuranceUsrInfo + " and insurance_usrid = '{0}' ", model.POLICYHOLDER);
localInsuranceUsrInfodt = db.GetTable(sqlLstpolicyholder);
if (localInsuranceUsrInfodt != null && localInsuranceUsrInfodt.Rows.Count > 0)
{
DataRow rowDet = localInsuranceUsrInfodt.Rows[0];
localInsuranceUsrInfo = DataRowToInsuranceUsrInfoModel(rowDet);
model.Policyholder_usr = localInsuranceUsrInfo;
}
localOrderInfo.Add(model);
}
}
CTrace.WriteLine(CTrace.TraceLevel.Info, "insurance.outProductDetInfoSearch GetTable {0}.", sql);
}
}
catch (FormatException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in outScmProviderInfoSearch Search" + ex.Message);
}
catch (ArgumentNullException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in outProductDetInfoSearch Search" + ex.Message);
}
catch (ArrayTypeMismatchException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in outProductDetInfoSearch Search" + ex.Message);
}
catch (BadImageFormatException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in outProductDetInfoSearch Search" + ex.Message);
}
catch (IndexOutOfRangeException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in outProductDetInfoSearch Search" + ex.Message);
}
catch (NullReferenceException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in outProductDetInfoSearch Search" + ex.Message);
}
catch (TimeoutException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in outProductDetInfoSearch Search" + ex.Message);
}
catch (Exception ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in outProductDetInfoSearch Search" + ex.Message);
throw;
}
return localOrderInfo;
}
