/// <remarks/>
public void prodImprovementQueryAsync(string RequestUser, string RequestTime, string RequestType, string update_time, clientInfo clientInfo)
{
this.prodImprovementQueryAsync(RequestUser, RequestTime, RequestType, update_time, clientInfo, null);
}
/// <remarks/>
public void prodImprovementQueryAsync(string RequestUser, string RequestTime, string RequestType, string update_time, clientInfo clientInfo, object userState)
{
if ((this.prodImprovementQueryOperationCompleted == null))
{
this.prodImprovementQueryOperationCompleted = new System.Threading.SendOrPostCallback(this.OnprodImprovementQueryOperationCompleted);
}
this.InvokeAsync("prodImprovementQuery", new object[] {
RequestUser,
RequestTime,
RequestType,
update_time,
clientInfo
}, this.prodImprovementQueryOperationCompleted, userState);
}
public Result prodImprovementQuery([System.Xml.Serialization.XmlElementAttribute(Form = System.Xml.Schema.XmlSchemaForm.Unqualified)] string RequestUser, [System.Xml.Serialization.XmlElementAttribute(Form = System.Xml.Schema.XmlSchemaForm.Unqualified)] string RequestTime, [System.Xml.Serialization.XmlElementAttribute(Form = System.Xml.Schema.XmlSchemaForm.Unqualified)] string RequestType, [System.Xml.Serialization.XmlElementAttribute(Form = System.Xml.Schema.XmlSchemaForm.Unqualified)] string update_time, [System.Xml.Serialization.XmlElementAttribute(Form = System.Xml.Schema.XmlSchemaForm.Unqualified)] clientInfo clientInfo)
{
object[] results = this.Invoke("prodImprovementQuery", new object[] {
RequestUser,
RequestTime,
RequestType,
update_time,
clientInfo
});
return((Result)(results[0]));
}
/// <summary> 产品改进号信息同步
/// </summary>
/// <param name="updateTime">最后更新时间</param>
/// <returns>返回产品改进号条数，如为-1，同步失败</returns>
public static int LoadProdImprovement(string updateTime)
{
ServicePointManager.ServerCertificateValidationCallback = ValidateServerCertificate;
QueryProdImprovement.clientInfo clientInfo = new QueryProdImprovement.clientInfo();
clientInfo.clientID = GlobalStaticObj_Servier.Instance.ClientID;
clientInfo.serviceID = "prodImprovementQuery";
QueryProdImprovement.prodImprovementQueryService serv = new QueryProdImprovement.prodImprovementQueryService();
QueryProdImprovement.Result result = serv.prodImprovementQuery(GlobalStaticObj_Servier.Instance.ClientID, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "QUERY", updateTime, clientInfo);
if (result.state == "F")
{
return(-1);
}
QueryProdImprovement.prodImprovement[] ProdArr = result.Details;
if (ProdArr.Length == 0)
{
return(0);
}
string nowTicks = Common.LocalDateTimeToUtcLong(DateTime.Now).ToString();
List <SysSQLString> list = new List <SysSQLString>();
foreach (QueryProdImprovement.prodImprovement item in ProdArr)
{
SysSQLString sysSQLString = new SysSQLString();
sysSQLString.cmdType = CommandType.Text;
sysSQLString.Param = new Dictionary <string, string>();
StringBuilder strSql = new StringBuilder();
bool isContactExist = DBHelper.IsExist("判断产品改进号是否存在", "tb_product_no", "service_code='" + item.service_code + "'");
if (isContactExist)
{
#region 更新语句
strSql.Append(" update tb_product_no set ");
strSql.Append(" activities = @activities , ");
strSql.Append(" service_type = @service_type , ");
strSql.Append(" sart_date = @sart_date , ");
strSql.Append(" begin_date = @begin_date , ");
strSql.Append(" end_date = @end_date , ");
strSql.Append(" service_memo = @service_memo , ");
strSql.Append(" update_time = @update_time ");
strSql.Append(" where service_code=@service_code; ");
#endregion
}
else
{
#region 插入语句
strSql.Append(" insert into tb_product_no(");
strSql.Append("p_no_id,activities,service_type,sart_date,begin_date,end_date,service_memo,service_code,create_by,create_time,update_by,update_time");
strSql.Append(") values (");
strSql.Append("@p_no_id,@activities,@service_type,@sart_date,@begin_date,@end_date,@service_memo,@service_code,@create_by,@create_time,@update_by,@update_time");
strSql.Append("); ");
#endregion
sysSQLString.Param.Add("p_no_id", Guid.NewGuid().ToString());
sysSQLString.Param.Add("create_by", GlobalStaticObj_Servier.Instance.ClientID);
sysSQLString.Param.Add("create_time", nowTicks);
}
#region 参数项 9
sysSQLString.sqlString = strSql.ToString();
sysSQLString.Param.Add("activities", item.activities);
sysSQLString.Param.Add("service_code", item.service_code);
sysSQLString.Param.Add("service_type", item.service_type);
sysSQLString.Param.Add("sart_date", Common.LocalDateTimeToUtcLong(DateTime.Parse(string.IsNullOrEmpty(item.sart_date) ? DateTime.MinValue.ToString() : item.sart_date.ToString())).ToString());
sysSQLString.Param.Add("begin_date", Common.LocalDateTimeToUtcLong(DateTime.Parse(item.begin_date)).ToString());
sysSQLString.Param.Add("end_date", Common.LocalDateTimeToUtcLong(DateTime.Parse(item.end_date)).ToString());
sysSQLString.Param.Add("service_memo", item.service_memo);
sysSQLString.Param.Add("update_by", GlobalStaticObj_Servier.Instance.ClientID);
sysSQLString.Param.Add("update_time", nowTicks);
#endregion
list.Add(sysSQLString);
foreach (QueryProdImprovement.BusDetail item0 in item.BusDetails)
{
SysSQLString sysSQLString0 = new SysSQLString();
sysSQLString0.cmdType = CommandType.Text;
sysSQLString0.Param = new Dictionary <string, string>();
StringBuilder strSql0 = new StringBuilder();
bool isContactExist0 = DBHelper.IsExist("判断产品改进号车辆信息是否存在", "tb_product_no_vehicle", "vehicle_code='" + item0.vehicle_code + "'");
if (isContactExist0)
{
#region 更新语句
strSql0.Append(" update tb_product_no_vehicle set ");
strSql0.Append(" account_code = @account_code , ");
strSql0.Append(" server_station = @server_station , ");
strSql0.Append(" update_time = @update_time ");
strSql0.Append(" where vehicle_code=@vehicle_code; ");
#endregion
}
else
{
#region 插入语句
strSql0.Append(" insert into tb_product_no_vehicle(");
strSql0.Append("p_no_v_id,account_code,server_station,create_by,create_time,update_by,update_time");
strSql0.Append(") values (");
strSql0.Append("@p_no_v_id,@account_code,@server_station,@create_by,@create_time,@update_by,@update_time");
strSql0.Append("); ");
#endregion
sysSQLString0.Param.Add("p_no_v_id", Guid.NewGuid().ToString());
sysSQLString0.Param.Add("create_by", GlobalStaticObj_Servier.Instance.ClientID);
sysSQLString0.Param.Add("create_time", nowTicks);
}
#region
sysSQLString0.sqlString = strSql0.ToString();
sysSQLString0.Param.Add("account_code", item0.account_code);
sysSQLString0.Param.Add("server_station", item0.server_station);
sysSQLString0.Param.Add("update_by", GlobalStaticObj_Servier.Instance.ClientID);
sysSQLString0.Param.Add("update_time", nowTicks);
#endregion
list.Add(sysSQLString0);
}
foreach (QueryProdImprovement.PartDetail item1 in item.PartDetails)
{
SysSQLString sysSQLString1 = new SysSQLString();
sysSQLString1.cmdType = CommandType.Text;
sysSQLString1.Param = new Dictionary <string, string>();
StringBuilder strSql1 = new StringBuilder();
bool isContactExist1 = DBHelper.IsExist("判断产品改进号配件信息是否存在", "tb_product_no_part", "part_code='" + item1.part_code + "'");
if (isContactExist1)
{
#region 更新语句
strSql1.Append(" update tb_product_no_part set ");
strSql1.Append(" quantity = @quantity , ");
strSql1.Append(" uint = @uint , ");
strSql1.Append(" update_time = @update_time ");
strSql1.Append(" where part_code=@part_code; ");
#endregion
}
else
{
#region 插入语句
strSql1.Append(" insert into tb_product_no_part(");
strSql1.Append("p_no_part_id,part_code,quantity,uint,create_by,create_time,update_by,update_time");
strSql1.Append(") values (");
strSql1.Append("@p_no_part_id,@part_code,@quantity,@uint,@create_by,@create_time,@update_by,@update_time");
strSql1.Append("); ");
#endregion
sysSQLString1.Param.Add("p_no_part_id", Guid.NewGuid().ToString());
sysSQLString1.Param.Add("create_by", GlobalStaticObj_Servier.Instance.ClientID);
sysSQLString1.Param.Add("create_time", nowTicks);
}
#region
sysSQLString1.sqlString = strSql1.ToString();
sysSQLString1.Param.Add("part_code", item1.part_code);
sysSQLString1.Param.Add("quantity", item1.quantity);
sysSQLString1.Param.Add("uint", item1.@uint);
sysSQLString1.Param.Add("update_by", GlobalStaticObj_Servier.Instance.ClientID);
sysSQLString1.Param.Add("update_time", nowTicks);
#endregion
list.Add(sysSQLString1);
}
}
bool flag = DBHelper.BatchExeSQLStringMultiByTrans("宇通：同步车型", list);
if (!flag)
{
return(-1);
}
return(ProdArr.Length);
}