// 将Service端VehicleBasicInfo类型转换为Client端类型
public static void BasicInfoW2C(FuelDataService.VehicleBasicInfo src, FuelDataModel.VehicleBasicInfo des)
{
Type typeSrc = src.GetType();
Type typeDes = des.GetType();
PropertyInfo[] properties = typeDes.GetProperties();
foreach (PropertyInfo pf in properties)
{
PropertyInfo ps = typeSrc.GetProperty(pf.Name);
if (ps != null)
{
try
{
pf.SetValue(des, ps.GetValue(src, null), null);
}
catch
{
}
}
}
}
// 将web service端的VehicleBasicInfo List对象转换为client端对象
public static List <FuelDataService.VehicleBasicInfo> FuelInfoC2S(List <VehicleBasicInfo> clientBasicList)
{
List <FuelDataService.VehicleBasicInfo> serviceBasicList = new List <FuelDataService.VehicleBasicInfo>();
foreach (VehicleBasicInfo clientBasic in clientBasicList)
{
List <FuelDataService.RllxParamEntity> serviceEntityList = new List <FuelDataService.RllxParamEntity>();
foreach (RllxParamEntity clientEntity in clientBasic.EntityList)
{
FuelDataService.RllxParamEntity serviceEntity = new FuelDataService.RllxParamEntity();
ConvertObj <RllxParamEntity, FuelDataService.RllxParamEntity>(clientEntity, serviceEntity);
serviceEntityList.Add(serviceEntity);
}
FuelDataService.VehicleBasicInfo serviceBasic = new FuelDataService.VehicleBasicInfo();
Utils.BasicInfoC2W(clientBasic, serviceBasic);
serviceBasic.EntityList = serviceEntityList.ToArray();
serviceBasicList.Add(serviceBasic);
}
return(serviceBasicList);
}
//STEP3：插入到本地数据库
private void InsertData(FuelDataService.VehicleBasicInfo vbInfo)
{
using (OracleConnection con = new OracleConnection(OracleHelper.conn))
{
con.Open();
OracleTransaction tra = con.BeginTransaction();
try
{
OracleHelper.ExecuteNonQuery(tra, String.Format("DELETE FROM FC_CLJBXX_ADC WHERE VIN ='{0}'", vbInfo.Vin), null);
OracleParameter clzzrq = new OracleParameter("CLZZRQ", vbInfo.Clzzrq)
{
DbType = DbType.Date
};
MitsUtils miutils = new MitsUtils();
DateTime uploadDeadlineDate = miutils.QueryUploadDeadLine(vbInfo.Clzzrq);
OracleParameter uploadDeadline = new OracleParameter("UPLOADDEADLINE", uploadDeadlineDate)
{
DbType = DbType.Date
};
OracleParameter creTime = new OracleParameter("CREATETIME", vbInfo.CreateTime)
{
DbType = DbType.Date
};
OracleParameter upTime = new OracleParameter("UPDATETIME", vbInfo.UpdateTime)
{
DbType = DbType.Date
};
OracleParameter[] param =
{
new OracleParameter("VIN", vbInfo.Vin),
new OracleParameter("USER_ID", vbInfo.User_Id),
new OracleParameter("QCSCQY", vbInfo.Qcscqy),
new OracleParameter("JKQCZJXS", vbInfo.Jkqczjxs),
clzzrq,
uploadDeadline,
new OracleParameter("CLXH", vbInfo.Clxh),
new OracleParameter("CLZL", vbInfo.Clzl),
new OracleParameter("RLLX", vbInfo.Rllx),
new OracleParameter("ZCZBZL", vbInfo.Zczbzl),
new OracleParameter("ZGCS", vbInfo.Zgcs),
new OracleParameter("LTGG", vbInfo.Ltgg),
new OracleParameter("ZJ", vbInfo.Zj),
new OracleParameter("TYMC", vbInfo.Tymc),
new OracleParameter("YYC", vbInfo.Yyc),
new OracleParameter("ZWPS", vbInfo.Zwps),
new OracleParameter("ZDSJZZL", vbInfo.Zdsjzzl),
new OracleParameter("EDZK", vbInfo.Edzk),
new OracleParameter("LJ", vbInfo.Lj),
new OracleParameter("QDXS", vbInfo.Qdxs),
new OracleParameter("JYJGMC", vbInfo.Jyjgmc),
new OracleParameter("JYBGBH", vbInfo.Jybgbh),
new OracleParameter("HGSPBM", string.IsNullOrEmpty(vbInfo.Hgspbm)?"":vbInfo.Hgspbm),
new OracleParameter("QTXX", string.IsNullOrEmpty(vbInfo.Qtxx)?"":vbInfo.Qtxx),
new OracleParameter("STATUS", "0"),
creTime,
upTime,
new OracleParameter("V_ID", vbInfo.V_Id)
};
OracleHelper.ExecuteNonQuery(tra, (string)@"INSERT INTO FC_CLJBXX_ADC
( VIN,USER_ID,QCSCQY,JKQCZJXS,CLZZRQ,UPLOADDEADLINE,CLXH,CLZL,
RLLX,ZCZBZL,ZGCS,LTGG,ZJ,
TYMC,YYC,ZWPS,ZDSJZZL,EDZK,LJ,
QDXS,JYJGMC,JYBGBH,HGSPBM,QTXX,STATUS,CREATETIME,UPDATETIME,V_ID
) VALUES
( :VIN,:USER_ID,:QCSCQY,:JKQCZJXS,:CLZZRQ,:UPLOADDEADLINE,:CLXH,:CLZL,
:RLLX,:ZCZBZL,:ZGCS,:LTGG,:ZJ,
:TYMC,:YYC,:ZWPS,:ZDSJZZL,:EDZK,:LJ,
:QDXS,:JYJGMC,:JYBGBH,:HGSPBM,:QTXX,:STATUS,:CREATETIME,:UPDATETIME,:V_ID)", param);
OracleHelper.ExecuteNonQuery(tra, String.Format("DELETE FROM RLLX_PARAM_ENTITY_ADC WHERE VIN ='{0}'", vbInfo.Vin), null);
// 待生成的燃料参数信息存入燃料参数表
int i = 0;
foreach (var drParam in vbInfo.EntityList)
{
OracleParameter[] paramList =
{
new OracleParameter("PARAM_CODE", drParam.Param_Code),
new OracleParameter("VIN", drParam.Vin),
new OracleParameter("PARAM_VALUE", drParam.Param_Value),
new OracleParameter("V_ID", "")
};
OracleHelper.ExecuteNonQuery(tra, (string)@"INSERT INTO RLLX_PARAM_ENTITY_ADC
(PARAM_CODE,VIN,PARAM_VALUE,V_ID)
VALUES
(:PARAM_CODE,:VIN,:PARAM_VALUE,:V_ID)", paramList);
i++;
}
LogManager.Log("Remote", "log", String.Format("{0} {1} {2}", vbInfo.Vin, vbInfo.Rllx, i));
tra.Commit();
}
catch (Exception ex)
{
tra.Rollback();
throw ex;
}
}
}
