//供特定门店下载预定中心的信息 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); }