//供特定门店下载预定中心的信息
public string yddj_Update(string orderlsbh, string state)
{
int rows = 0;
BLL.MT_Order B_Web_skyd = new BLL.MT_Order();
rows = B_Web_skyd.UpdateField(orderlsbh, " state='" + state + "'");
return(common_file.common_app.get_suc);
}
public string SetAcceptOrderStatus(string bdlsbh, string yydh, int OrderStatus)
{
string RetVal = common_file.common_app.get_failure;
object Ovalue = DbHelperSQL.GetSingle(string.Format(@"select yclsbh from Qyddjlsbhbg_yy where bdlsbh='{0}' ", bdlsbh));
if (Ovalue != null)
{
BLL.MT_Order bll = new BLL.MT_Order();
int i = DbHelperSQL.ExecuteSql(string.Format(@" Update MT_Order set state={0} where order_lsbh='{1}' ", OrderStatus, Ovalue.ToString()));
return(RetVal = i > 0 ? common_file.common_app.get_suc : common_file.common_app.get_failure);
}
return(RetVal);
}
//供特定门店下载预定中心的信息
public DataSet yddj_download_DS_Test(string qymc, out int rows, out bool status)
{
DataSet DS_skyd = new DataSet();
rows = 0;
status = false;
BLL.MT_Order B_Web_skyd = new BLL.MT_Order();
DS_skyd = B_Web_skyd.GetList(" state=2");
if (DS_skyd != null)
{
rows = DS_skyd.Tables[0].Rows.Count;
status = true;
}
return(DS_skyd);
}
//下载网上预订的方法
public static int Download_orderFrom400_test()
{
Model.MT_Order M_Order = new Model.MT_Order();
BLL.MT_Order B_Order = new BLL.MT_Order();
string lsbh = ""; string ddbh = "";
int dlsum = 0;
string ss = "failure";
url = common_file.Common.ReadXML("add", "url") + "/Qyddj/Qyddj_app.asmx";
DataSet DS_downloadData = new DataSet();
qymc = common_file.Common.Getqyxx(2);
int rows = 0;
bool status = false;
object[] obj = new object[4];
obj[0] = qymc;
obj[1] = rows;
obj[2] = status;
obj[3] = DS_downloadData;
object result = jdgl_res_head_app.DynamicWebServiceCall.InvokeWebService(url, "yddj_download_DS_test", obj);
ss = result.ToString();
if (ss == common_app.get_suc)
{
try
{
DS_downloadData = (DataSet)obj[3];
foreach (DataRow dr in DS_downloadData.Tables[0].Rows)
{
M_Order.add_time = DateTime.Now;
M_Order.category_id = int.Parse(dr[10].ToString());
M_Order.channel_id = int.Parse(dr[10].ToString());
M_Order.content = dr["content"].ToString();
M_Order.crs = int.Parse(dr["crs"].ToString());
M_Order.fjrx_id = int.Parse(dr["fjrx_id"].ToString());
M_Order.is_rz = int.Parse(dr["is_rz"].ToString());
M_Order.order_lsbh = dr["order_lsbh"].ToString();
M_Order.state = int.Parse(dr["state"].ToString());
M_Order.user_id = int.Parse(dr["user_id"].ToString());
M_Order.xhrs = int.Parse(dr["xhrs"].ToString());
M_Order.yd_ddsj = dr["yd_ddsj"].ToString();
M_Order.yd_endtime = Convert.ToDateTime(dr["yd_endtime"].ToString());
M_Order.yd_jg = Convert.ToDecimal(dr["yd_jg"].ToString());
M_Order.yd_js = int.Parse(dr["yd_js"].ToString());
M_Order.yd_name = dr["yd_name"].ToString();
M_Order.yd_ts = Convert.ToDecimal(dr["yd_ts"].ToString());
M_Order.yd_statetime = DateTime.Now;
B_Order.Add(M_Order);
}
dlsum = int.Parse(DS_downloadData.Tables[0].Rows.Count.ToString());//返回行数
return(dlsum);
}
catch (Exception ee)
{
errorInfo = ee.Message.ToString();
postion = "向本地Qskyd_mainrecord插入数据之后到修改远程服务器下载数据的过程之中";
Common.WriteLog(errorInfo, postion);
}
}
return(dlsum);
}