public void deleteOrderHistAllDetData(SqlLib lib, IDb db, object obj, ref DataTable outOrderDetDt)
{
string sql = "";
bool ret = true;
try
{
OrderInfo localOrderinfo = new OrderInfo();
ret = DataHandle.CompareObjectType(obj, localOrderinfo);
if (ret)
{
localOrderinfo = (OrderInfo)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(localOrderinfo.ORDERID))
{
sql += " and ORDERID='" + localOrderinfo.ORDERID + "'";
}
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();
}
outOrderDetDt.Merge(localdt, true);
}
catch (NullReferenceException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteOrderHistAllDetData" + ex.Message);
}
catch (ArrayTypeMismatchException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteOrderHistAllDetData" + ex.Message);
}
catch (Exception ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteOrderHistAllDetData" + ex.Message);
throw;
}
}
public void deleteOrderHistAllInsurantData(SqlLib lib, IDb db, object obj, ref DataTable outInsuranceUsrDt)
{
string sql = "";
bool ret = true;
try
{
OrderInfo localOrderInfo = new OrderInfo();
ret = DataHandle.CompareObjectType(obj, localOrderInfo);
if (ret)
{
localOrderInfo = (OrderInfo)obj;
}
else
{
return;
}
if (outInsuranceUsrDt == null)
{
throw new NullReferenceException("outInsuranceUsrDt is null");
}
string InsuranceUsrID = "";
sql = lib.GetSql("SqlOrderInfo/OrderInfo", "GetOrderHistInfo");
sql = sql + string.Format(" and orderid = '{0}'", localOrderInfo.ORDERID);
/// 保险人信息
InsuranceUsrInfo localInsuranceUsrInfo = new InsuranceUsrInfo();
CTrace.WriteLine(CTrace.TraceLevel.Info, "insurance.outOrderInfo sql={0}.", sql);
DataTable dt = db.GetTable(sql);
if (dt != null && dt.Rows.Count > 0)
{
DataRow locaorderDr = dt.Rows[0];
localOrderInfo = DataRowToOrderModel(locaorderDr);
if (localOrderInfo.BENEFICIARIES != null && !string.IsNullOrEmpty(localOrderInfo.BENEFICIARIES))
{
InsuranceUsrID = "'" + localOrderInfo.BENEFICIARIES.ToString() + "',";
}
if (localOrderInfo.BENEFICIARIES2 !=null && !string.IsNullOrEmpty(localOrderInfo.BENEFICIARIES2))
{
InsuranceUsrID = InsuranceUsrID +"'" + localOrderInfo.BENEFICIARIES2.ToString() + "',";
}
if (localOrderInfo.BENEFICIARIES3 != null && !string.IsNullOrEmpty(localOrderInfo.BENEFICIARIES3))
{
InsuranceUsrID = InsuranceUsrID + "'" + localOrderInfo.BENEFICIARIES3.ToString() + "',";
}
if (localOrderInfo.INSURANT != null && !string.IsNullOrEmpty(localOrderInfo.INSURANT))
{
InsuranceUsrID = InsuranceUsrID + "'" + localOrderInfo.INSURANT.ToString() + "',";
}
if (localOrderInfo.POLICYHOLDER !=null && !string.IsNullOrEmpty(localOrderInfo.POLICYHOLDER))
{
InsuranceUsrID = InsuranceUsrID + "'" + localOrderInfo.POLICYHOLDER.ToString() + "',";
}
}
if (string.IsNullOrEmpty(InsuranceUsrID))
{
return;
}
DataTable localdt = new DataTable();
sql = lib.GetSql("SqlInsuranceUsrInfo/InsuranceUsrInfo", "GetInsuranceUsrInfo");
if (!string.IsNullOrEmpty(InsuranceUsrID))
{
InsuranceUsrID = InsuranceUsrID.Substring(0, InsuranceUsrID.Length - 1);
sql += " and INSURANCE_USRID in (" + InsuranceUsrID + " )";
}
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();
}
outInsuranceUsrDt.Merge(localdt, true);
}
catch (NullReferenceException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteInsuranceUsrData" + ex.Message);
}
catch (ArrayTypeMismatchException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteInsuranceUsrData" + ex.Message);
}
catch (Exception ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteInsuranceUsrData" + ex.Message);
throw;
}
}
public void updateOrderHistData(SqlLib lib, IDb db, object obj, ref DataTable outOrderHistDt)
{
string sql = "";
bool ret = true;
try
{
OrderInfo li = new OrderInfo();
ret = DataHandle.CompareObjectType(obj, li);
if (ret)
{
//get the correct list.
li = (OrderInfo)obj;
}
else
{
return;
}
if (outOrderHistDt == null)
{
throw new NullReferenceException("outOrderHistDt is null");
}
DataTable localDt = new DataTable();
//每次更新一条数据
sql = lib.GetSql("SqlOrderInfo/OrderInfo", "GetOrderInfo");
if (!string.IsNullOrEmpty(li.ORDERID))
{
sql = sql + " and orderid= '" + li.ORDERID + "'";
localDt = db.GetTable(sql);
if (localDt.Rows.Count == 1)
{
DataRow dr = localDt.Rows[0];
dr.BeginEdit();
dr["orderid"] = DataHandle.EmptyString2DBNull(li.ORDERID);
dr["contactid"] = DataHandle.EmptyString2DBNull(li.CONTACTID);
dr["addressid"] = DataHandle.EmptyString2DBNull(li.ADDRESSID);
dr["ACCDT"] = DataHandle.EmptyString2DBNull(li.ACCDT);
dr["AMORTISATION"] = DataHandle.EmptyString2DBNull(li.AMORTISATION);
dr["BENEFICIARIES"] = DataHandle.EmptyString2DBNull(li.BENEFICIARIES);
dr["BILL"] = DataHandle.EmptyString2DBNull(li.BILL);
dr["BILLDEMONDDSC"] = DataHandle.EmptyString2DBNull(li.BILLDEMONDDSC);
dr["BILLDEMONDED"] = DataHandle.EmptyString2DBNull(li.BILLDEMONDED);
dr["BILLTITLE"] = DataHandle.EmptyString2DBNull(li.BILLTITLE);
dr["CARDID"] = DataHandle.EmptyString2DBNull(li.CARDID);
dr["CARDRIGHTNUM"] = DataHandle.EmptyString2DBNull(li.CARDRIGHTNUM);
dr["CLEARFEE"] = DataHandle.EmptyString2DBNull(li.CLEARFEE);
dr["CONFIRM"] = DataHandle.EmptyString2DBNull(li.CONFIRM);
dr["CONSIGNEE"] = DataHandle.EmptyString2DBNull(li.CONSIGNEE);
dr["CONSIGNPHN"] = DataHandle.EmptyString2DBNull(li.CONSIGNPHN);
dr["CRUSR"] = DataHandle.EmptyString2DBNull(li.CRUSR);
dr["DEMONDDT"] = DataHandle.EmptyString2DBNull(li.DEMONDDT);
dr["DISCOUNT"] = DataHandle.EmptyString2DBNull(li.DISCOUNT);
dr["FBDT"] = DataHandle.EmptyString2DBNull(li.FBDT);
dr["GRPID"] = DataHandle.EmptyString2DBNull(li.GRPID);
dr["HEALTHINTRO"] = DataHandle.EmptyString2DBNull(li.HEALTHINTRO);
dr["INSURANCEID"] = DataHandle.EmptyString2DBNull(li.INSURANCEID);
dr["INSURANT"] = DataHandle.EmptyString2DBNull(li.INSURANT);
dr["MAILPRICE"] = DataHandle.EmptyString2DBNull(li.MAILPRICE);
dr["MDDT"] = DataHandle.EmptyString2DBNull(li.MDDT);
dr["MDUSR"] = DataHandle.EmptyString2DBNull(li.MDUSR);
dr["MONITORRECORDER"] = DataHandle.EmptyString2DBNull(li.MONITORRECORDER);
dr["NOTE"] = DataHandle.EmptyString2DBNull(li.NOTE);
dr["NOWMONEY"] = DataHandle.EmptyString2DBNull(li.NOWMONEY);
dr["POLICYHOLDER"] = DataHandle.EmptyString2DBNull(li.POLICYHOLDER);
dr["POSTFEE"] = DataHandle.EmptyString2DBNull(li.POSTFEE);
dr["PRODPRICE"] = DataHandle.EmptyString2DBNull(li.PRODPRICE);
dr["PRODUCTINTRO"] = DataHandle.EmptyString2DBNull(li.PRODUCTINTRO);
dr["RESULT"] = DataHandle.EmptyString2DBNull(li.RESULT);
dr["SENDDT"] = DataHandle.EmptyString2DBNull(li.SENDDT);
dr["SPECIALDSC"] = DataHandle.EmptyString2DBNull(li.SPECIALDSC);
dr["STATUS"] = DataHandle.EmptyString2DBNull(li.STATUS);
dr["TOTALPRICE"] = DataHandle.EmptyString2DBNull(li.TOTALPRICE);
dr["URGENT"] = DataHandle.EmptyString2DBNull(li.URGENT);
dr["ordertype"] = DataHandle.EmptyString2DBNull(li.ordertype);
dr["paytype"] = DataHandle.EmptyString2DBNull(li.paytype);
dr["mailtype"] = DataHandle.EmptyString2DBNull(li.mailtype);
dr["CRDT"] = DataHandle.EmptyString2DBNull(li.crdt);
dr.EndEdit();
outOrderHistDt.Merge(localDt, true);
}
else
{
//do nothing
}
}
else
{
//do nothing
}
//ScmProviderData li = new ScmProviderData();
//ret = DataHandle.CompareObjectType(obj, li);
//if (ret)
//{
// //get the correct list.
// li = (ScmProviderData)obj;
//}
//else
//{
// return;
//}
//if (outDtPlace == null)
//{
// throw new NullReferenceException("outDtPlace is null");
//}
//DataTable localDt = new DataTable();
////每次更新一条。
//sql = lib.GetSql("SqlPlace/PlaceProdInfo", "GetPlaceProdRelationInfo");
//if (!string.IsNullOrEmpty(li.PROVIDERID))
//{
// sql = sql + " and PROVIDERID= '" + li.PROVIDERID + "'";
// localDt = db.GetTable(sql);
// //have one record
// if (localDt.Rows.Count == 1)
// {
// // only one record.
// DataRow dr = localDt.Rows[0];
// dr.BeginEdit();
// dr["PROVIDERID"] = DataHandle.EmptyString2DBNull(li.PROVIDERID);
// dr["CRDT"] = DataHandle.EmptyString2DBNull(li.CRDT);
// dr["CRUSR"] = DataHandle.EmptyString2DBNull(li.CRUSR);
// dr["DSC"] = DataHandle.EmptyString2DBNull(li.DSC.ToString());
// dr["MDDT"] = DataHandle.EmptyString2DBNull(li.MDDT);
// dr["MDUSR"] = DataHandle.EmptyString2DBNull(li.MDUSR);
// dr["NAME"] = DataHandle.EmptyString2DBNull(li.NAME.ToString());
// dr.EndEdit();
// outDtPlace.Merge(localDt, true);
// }
// else
// {
// //do nothing.
// }
//}
//else
//{
// // do nothing
//}
}
catch (NullReferenceException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in updateOrderHistData" + ex.Message);
}
catch (ArrayTypeMismatchException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in updateOrderHistData" + ex.Message);
}
catch (Exception ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in updateOrderHistData" + ex.Message);
throw;
}
}
public void deleteOrderHistData(SqlLib lib, IDb db, object obj, ref DataTable outDt)
{
string sql = "";
bool ret = true;
try
{
OrderInfo orderInfo = new OrderInfo();
ret = DataHandle.CompareObjectType(obj, orderInfo);
if (ret)
{
//get the correct list.
orderInfo = (OrderInfo)obj;
}
else
{
return;
}
if (outDt == null)
{
throw new NullReferenceException("outDt is null");
}
DataTable localDt = new DataTable();
//每次删除一条或者多条.
sql = lib.GetSql("SqlOrderInfo/OrderInfo", "GetOrderInfo");
if (!string.IsNullOrEmpty(orderInfo.ORDERID))
{
sql = sql + " and ORDERID= '" + orderInfo.ORDERID + "'";
}
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();
}
//ScmProviderData li = new ScmProviderData();
//ret = DataHandle.CompareObjectType(obj, li);
//if (ret)
//{
// //get the correct list.
// li = (ScmProviderData)obj;
//}
//else
//{
// return;
//}
//if (outDtPlace == null)
//{
// throw new NullReferenceException("outDtPlace is null");
//}
//DataTable localDt = new DataTable();
////每次删除一条或者多条.
//sql = lib.GetSql("SqlPlace/PlaceProdInfo", "GetPlaceProdRelationInfo");
//if (!string.IsNullOrEmpty(li.PROVIDERID))
//{
// sql = sql + " and PROVIDERID= '" + li.PROVIDERID + "'";
//}
//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();
//}
//outDtPlace.Merge(localDt, true);
outDt.Merge(localDt, true);
}
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 bool updataInsuranceUsrDataTable(SqlLib lib, IDb db, DataTable indt)
{
bool ret = false;
try
{
if (indt.Rows.Count == 0)
{
//没有记录，相当于这方法没有执行。
return ret;
}
//更新OrderHist表
//循环更新所有的。
for (int i = 0; i < indt.Rows.Count; i++)
{
DataRow dr = indt.Rows[i];
string localOrderid = "";
if (dr.RowState == DataRowState.Unchanged)
{
//do nothing.jump out the loop.
continue;
}
else
if (dr.RowState == DataRowState.Deleted)
{
//do nothing.
}
else
{
localOrderid = dr["INSURANCE_USRID"].ToString();
}
string sql = lib.GetSql("SqlInsuranceUsrInfo/InsuranceUsrInfo", "GetInsuranceUsrStructInfo");
CTrace.WriteLine(CTrace.TraceLevel.Info, "updateOrderDetDataTable sql={0}.", sql);
ret = db.Save(indt, sql);
CTrace.WriteLine(CTrace.TraceLevel.Info, "updataInsuranceUsrDataTable result={0}.", ret.ToString());
if (ret)
{
//return true.
}
else
{
db.Rollback();
localOrderid = "";
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in updataInsuranceUsrDataTable" + db.Error.Message);
}
}
}
catch (NullReferenceException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in updataInsuranceUsrDataTable" + ex.Message);
}
catch (ArrayTypeMismatchException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in updataInsuranceUsrDataTable" + ex.Message);
}
catch (Exception ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in updataInsuranceUsrDataTable" + ex.Message);
throw;
}
return ret;
}
public void addNewOrderHistData(SqlLib lib, IDb db, object obj, ref DataTable outDt)
{
string sql = "";
string localID = "";
bool ret = false;
try
{
OrderInfo li = new OrderInfo();
ret = DataHandle.CompareObjectType(obj, li);
if (ret)
{
//get the correct list.
li = (OrderInfo)obj;
}
else
{
return;
}
if (outDt == null)
{
throw new NullReferenceException("outDt is null");
}
DataTable localDt = new DataTable();
//只取一条记录，以便得到表结构，如果一条都没有，那么会有什么结果？能够取出表结构。
sql = lib.GetSql("SqlOrderInfo/OrderInfo", "GetOrderHistStructInfo");
localDt = db.GetTable(sql);
//新增加的记录，在oracle中需要取到sequence编号
sql = lib.GetSql("SqlOrderInfo/OrderInfo", "GetNewOrderHistId");
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["orderid"] = DataHandle.EmptyString2DBNull(localID);
dr["contactid"] = DataHandle.EmptyString2DBNull(li.CONTACTID);
dr["addressid"] = DataHandle.EmptyString2DBNull(li.ADDRESSID);
dr["ACCDT"] = DataHandle.EmptyString2DBNull(li.ACCDT);
dr["AMORTISATION"] = DataHandle.EmptyString2DBNull(li.AMORTISATION);
dr["BENEFICIARIES"] = DataHandle.EmptyString2DBNull(li.BENEFICIARIES);
dr["BILL"] = DataHandle.EmptyString2DBNull(li.BILL);
dr["BILLDEMONDDSC"] = DataHandle.EmptyString2DBNull(li.BILLDEMONDDSC);
dr["BILLDEMONDED"] = DataHandle.EmptyString2DBNull(li.BILLDEMONDED);
dr["BILLTITLE"] = DataHandle.EmptyString2DBNull(li.BILLTITLE);
dr["CARDID"] = DataHandle.EmptyString2DBNull(li.CARDID);
dr["CARDRIGHTNUM"] = DataHandle.EmptyString2DBNull(li.CARDRIGHTNUM);
dr["CLEARFEE"] = DataHandle.EmptyString2DBNull(li.CLEARFEE);
dr["CONFIRM"] = DataHandle.EmptyString2DBNull(li.CONFIRM);
dr["CONSIGNEE"] = DataHandle.EmptyString2DBNull(li.CONSIGNEE);
dr["CONSIGNPHN"] = DataHandle.EmptyString2DBNull(li.CONSIGNPHN);
dr["CRUSR"] = DataHandle.EmptyString2DBNull(li.CRUSR);
dr["DEMONDDT"] = DataHandle.EmptyString2DBNull(li.DEMONDDT);
dr["DISCOUNT"] = DataHandle.EmptyString2DBNull(li.DISCOUNT);
dr["FBDT"] = DataHandle.EmptyString2DBNull(li.FBDT);
dr["GRPID"] = DataHandle.EmptyString2DBNull(li.GRPID);
dr["HEALTHINTRO"] = DataHandle.EmptyString2DBNull(li.HEALTHINTRO);
dr["INSURANCEID"] = DataHandle.EmptyString2DBNull(li.INSURANCEID);
dr["INSURANT"] = DataHandle.EmptyString2DBNull(li.INSURANT);
dr["MAILPRICE"] = DataHandle.EmptyString2DBNull(li.MAILPRICE);
dr["MDDT"] = DataHandle.EmptyString2DBNull(li.MDDT);
dr["MDUSR"] = DataHandle.EmptyString2DBNull(li.MDUSR);
dr["MONITORRECORDER"] = DataHandle.EmptyString2DBNull(li.MONITORRECORDER);
dr["NOTE"] = DataHandle.EmptyString2DBNull(li.NOTE);
dr["NOWMONEY"] = DataHandle.EmptyString2DBNull(li.NOWMONEY);
dr["POLICYHOLDER"] = DataHandle.EmptyString2DBNull(li.POLICYHOLDER);
dr["POSTFEE"] = DataHandle.EmptyString2DBNull(li.POSTFEE);
dr["PRODPRICE"] = DataHandle.EmptyString2DBNull(li.PRODPRICE);
dr["PRODUCTINTRO"] = DataHandle.EmptyString2DBNull(li.PRODUCTINTRO);
dr["RESULT"] = DataHandle.EmptyString2DBNull(li.RESULT);
dr["SENDDT"] = DataHandle.EmptyString2DBNull(li.SENDDT);
dr["SPECIALDSC"] = DataHandle.EmptyString2DBNull(li.SPECIALDSC);
dr["STATUS"] = DataHandle.EmptyString2DBNull(li.STATUS);
dr["TOTALPRICE"] = DataHandle.EmptyString2DBNull(li.TOTALPRICE);
dr["URGENT"] = DataHandle.EmptyString2DBNull(li.URGENT);
dr["ordertype"] = DataHandle.EmptyString2DBNull(li.ordertype);
dr["paytype"] = DataHandle.EmptyString2DBNull(li.paytype);
dr["mailtype"] = DataHandle.EmptyString2DBNull(li.mailtype);
dr["CRDT"] = DataHandle.EmptyString2DBNull(li.crdt);
localDt.Rows.Add(dr);
outDt.Merge(localDt, true);
}
catch (NullReferenceException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in addNewOrderHistData" + ex.Message);
}
catch (ArrayTypeMismatchException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in addNewOrderHistData" + ex.Message);
}
catch (Exception ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in addNewOrderHistData" + ex.Message);
throw;
}
}
public void deleteInsuranceUsrData(SqlLib lib, IDb db, object obj, ref DataTable outInsuranceUsrDt)
{
string sql = "";
bool ret = true;
try
{
InsuranceUsrInfo InsuranceUsr = new InsuranceUsrInfo();
ret = DataHandle.CompareObjectType(obj, InsuranceUsr);
if (ret)
{
InsuranceUsr = (InsuranceUsrInfo)obj;
}
else
{
return;
}
if (outInsuranceUsrDt == null)
{
throw new NullReferenceException("outInsuranceUsrDt is null");
}
DataTable localdt = new DataTable();
sql = lib.GetSql("SqlInsuranceUsrInfo/InsuranceUsrInfo", "GetInsuranceUsrInfo");
if (!string.IsNullOrEmpty(InsuranceUsr.INSURANCE_USRID))
{
sql += " and INSURANCE_USRID='" + InsuranceUsr.INSURANCE_USRID + " '";
}
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();
}
outInsuranceUsrDt.Merge(localdt);
}
catch (NullReferenceException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteInsuranceUsrData" + ex.Message);
}
catch (ArrayTypeMismatchException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteInsuranceUsrData" + ex.Message);
}
catch (Exception ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteInsuranceUsrData" + ex.Message);
throw;
}
}
public void updateInsuranceUsrData(SqlLib lib, IDb db, object obj, ref DataTable outInsuranceUsrDt)
{
string sql = "";
bool ret = true;
try
{
InsuranceUsrInfo li = new InsuranceUsrInfo();
ret = DataHandle.CompareObjectType(obj, li);
if (ret)
{
li = (InsuranceUsrInfo)obj;
}
else
{
return;
}
if (outInsuranceUsrDt == null)
{
throw new NullReferenceException("outInsuranceUsrDt is null");
}
DataTable localDt = new DataTable();
//根据Id更新一条数据信息
sql = lib.GetSql("SqlInsuranceUsrInfo/InsuranceUsrInfo", "GetInsuranceUsrInfo");
localDt = db.GetTable(sql);
if (!string.IsNullOrEmpty(li.INSURANCE_USRID))
{
sql += " and INSURANCE_USRID='" + li.INSURANCE_USRID + "'";
localDt = db.GetTable(sql);
if (localDt.Rows.Count > 0)
{
DataRow dr = localDt.NewRow();
dr["INSURANCE_USRID"] = DataHandle.EmptyString2DBNull(li.INSURANCE_USRID);
dr["Proportion"] = DataHandle.EmptyString2DBNull(li.Proportion);
dr["CRDT"] = DataHandle.EmptyString2DBNull(li.CRDT);
dr["CRUSR"] = DataHandle.EmptyString2DBNull(li.CRUSR);
dr["DSC"] = DataHandle.EmptyString2DBNull(li.DSC);
dr["IDCARDNO"] = DataHandle.EmptyString2DBNull(li.IDCARDNO);
dr["IDCARDTYPE"] = DataHandle.EmptyString2DBNull(li.IDCARDTYPE);
dr["IDPERIOD"] = DataHandle.EmptyString2DBNull(li.IDPERIOD);
dr["MDDT"] = DataHandle.EmptyString2DBNull(li.MDDT);
dr["MDUSR"] = DataHandle.EmptyString2DBNull(li.MDUSR);
dr["NAME"] = DataHandle.EmptyString2DBNull(li.NAME);
dr["POST"] = DataHandle.EmptyString2DBNull(li.POST);
dr["PROFESSION"] = DataHandle.EmptyString2DBNull(li.PROFESSION);
dr["SEX"] = DataHandle.EmptyString2DBNull(li.SEX);
outInsuranceUsrDt.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 void addNewInsuranceUsrData(SqlLib lib, IDb db, object obj, ref DataTable outInsuranceUsrDt)
{
string sql = "";
string localID = "";
bool ret = false;
try
{
InsuranceUsrInfo li = new InsuranceUsrInfo();
ret = DataHandle.CompareObjectType(obj, li);
if (ret)
{
li = (InsuranceUsrInfo)obj;
}
else
{
return;
}
if (outInsuranceUsrDt == null)
{
throw new NullReferenceException("outInsuranceUsrDt is null");
}
DataTable localdt = new DataTable();
sql = lib.GetSql("SqlInsuranceUsrInfo/InsuranceUsrInfo", "GetInsuranceUsrStructInfo");
localdt = db.GetTable(sql);
sql = lib.GetSql("SqlInsuranceUsrInfo/InsuranceUsrInfo", "GetNewInsuranceUsrId");
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["INSURANCE_USRID"] = DataHandle.EmptyString2DBNull(localID);
dr["Proportion"] = DataHandle.EmptyString2DBNull(li.Proportion);
dr["CRDT"] = DataHandle.EmptyString2DBNull(li.CRDT);
dr["CRUSR"] = DataHandle.EmptyString2DBNull(li.CRUSR);
dr["DSC"] = DataHandle.EmptyString2DBNull(li.DSC);
dr["IDCARDNO"] = DataHandle.EmptyString2DBNull(li.IDCARDNO);
dr["IDCARDTYPE"] = DataHandle.EmptyString2DBNull(li.IDCARDTYPE);
dr["IDPERIOD"] = DataHandle.EmptyString2DBNull(li.IDPERIOD);
dr["MDDT"] = DataHandle.EmptyString2DBNull(li.MDDT);
dr["MDUSR"] = DataHandle.EmptyString2DBNull(li.MDUSR);
dr["NAME"] = DataHandle.EmptyString2DBNull(li.NAME);
dr["POST"] = DataHandle.EmptyString2DBNull(li.POST);
dr["PROFESSION"] = DataHandle.EmptyString2DBNull(li.PROFESSION);
dr["SEX"] = DataHandle.EmptyString2DBNull(li.SEX);
localdt.Rows.Add(dr);
outInsuranceUsrDt.Merge(localdt, true);
}
catch (NullReferenceException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in addNewInsuranceUsrData" + ex.Message);
}
catch (ArrayTypeMismatchException ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in addNewInsuranceUsrData" + ex.Message);
}
catch (Exception ex)
{
CTrace.WriteLine(CTrace.TraceLevel.Fail, "in addNewInsuranceUsrData" + 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 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;
}
}