//协议单位信息下载,供特定门店下载返回dataset public DataSet DSYxydw_download(string yydh, out string csdatatime, out string jsdatatime) { BLL.Web_Yxydw B_Yxydw = new BLL.Web_Yxydw(); Model.Web_Yxydw M_Yxydw = new Model.Web_Yxydw(); Model.Yxy_sc_xz_sj M_scsj = new Model.Yxy_sc_xz_sj(); BLL.Yxy_sc_xz_sj B_scsj = new BLL.Yxy_sc_xz_sj(); //查询出上次上传时间 DateTime cstime = Convert.ToDateTime("1800-01-01"); if (yydh != "" && yydh != null) { M_scsj = B_scsj.GetModelList("yydh='" + yydh + "'")[0]; cstime = M_scsj.scsj; } string jstime = DateTime.Now.ToString(); DataSet DS_Yxydw = new DataSet(); jsdatatime = jstime; csdatatime = cstime.ToString(); DS_Yxydw = B_Yxydw.GetList(2000, "yydh<>'" + yydh + "' and (clsj>='" + cstime + "' and clsj<'" + jstime + "' and rx='协议单位') or xzxg='xg'", "id"); if (DS_Yxydw != null) { jsdatatime = jstime; csdatatime = cstime.ToString(); } return(DS_Yxydw); }
//协议单位信息下载,供特定门店下载返回dataset public DataSet DSYxydw_download(string yydh, out string csdatatime, out string jsdatatime) { BLL.Web_Yxydw B_Yxydw = new BLL.Web_Yxydw(); Model.Web_Yxydw M_Yxydw = new Model.Web_Yxydw(); Model.Yxy_sc_xz_sj M_scsj = new Model.Yxy_sc_xz_sj(); BLL.Yxy_sc_xz_sj B_scsj = new BLL.Yxy_sc_xz_sj(); //查询出上次上传时间 DateTime cstime = DateTime.Parse(common_app.cssj); if (yydh != "" && yydh != null) { List <Model.Yxy_sc_xz_sj> listModels = B_scsj.GetModelList("yydh='" + yydh + "'"); if (listModels.Count > 0) { M_scsj = listModels[0]; cstime = M_scsj.scsj; } else { log.LogHelper.WriteLog("出错,中心服务器找不到yydh为:" + yydh + "配置的初始下载时间记录,"); csdatatime = ""; jsdatatime = ""; return(null); } } string jstime = DateTime.Now.ToString(); DataSet DS_Yxydw = new DataSet(); jsdatatime = jstime; csdatatime = cstime.ToString(); DS_Yxydw = B_Yxydw.GetList(2000, "yydh<>'" + yydh + "' and (clsj>='" + cstime + "' and clsj<'" + jstime + "' and rx='协议单位') or xzxg='xg'", "id"); if (DS_Yxydw != null) { jsdatatime = jstime; csdatatime = cstime.ToString(); } return(DS_Yxydw); }
/// <summary> /// 用于门店向中心服务器数据上传 /// </summary> /// <param name="DS_Yxydw"></param> /// <returns></returns> public string Yxydw_add_DS_01(DataSet DS_Yxydw) { string s = common_file.common_app.get_failure; BLL.Web_Yxydw B_Yxydw = new BLL.Web_Yxydw(); Model.Web_Yxydw M_Yxydw = new Model.Web_Yxydw(); if (DS_Yxydw != null && DS_Yxydw.Tables[0].Rows.Count > 0) { foreach (DataRow dr in DS_Yxydw.Tables[0].Rows) { string strXyh = dr["xyh"].ToString(); M_Yxydw.qymc = dr["qymc"].ToString(); M_Yxydw.yydh = dr["yydh"].ToString(); M_Yxydw.zjm = dr["zjm"].ToString(); M_Yxydw.xzxg = dr["xzxg"].ToString(); M_Yxydw.xyrx = dr["xyrx"].ToString(); M_Yxydw.xyh_inner = dr["xyh_inner"].ToString(); M_Yxydw.xyh = dr["xyh"].ToString(); M_Yxydw.xydw = dr["xydw"].ToString(); M_Yxydw.xsy = dr["xsy"].ToString(); M_Yxydw.xfje = Convert.ToDecimal(dr["xfje"].ToString()); M_Yxydw.sign_image = (byte[])(dr["sign_image"]); M_Yxydw.shsh = Convert.ToBoolean(dr["shsh"].ToString()); M_Yxydw.shsc = true; M_Yxydw.rx = dr["rx"].ToString(); M_Yxydw.pq = dr["pq"].ToString(); M_Yxydw.nxr = dr["nxr"].ToString(); M_Yxydw.lzfs = Convert.ToDecimal(dr["lzfs"].ToString()); M_Yxydw.krly = dr["krly"].ToString(); M_Yxydw.krgj = dr["krgj"].ToString(); M_Yxydw.krEmail = dr["kremail"].ToString(); M_Yxydw.krdz = dr["krdz"].ToString(); M_Yxydw.krdh = dr["krdh"].ToString(); M_Yxydw.krcz = dr["krcz"].ToString(); M_Yxydw.is_top = Convert.ToBoolean(dr["is_top"].ToString()); M_Yxydw.is_select = Convert.ToBoolean(dr["is_select"].ToString()); M_Yxydw.bz = dr["bz"].ToString(); M_Yxydw.clsj = DateTime.Now; M_Yxydw.fkje = Convert.ToDecimal(dr["fkje"].ToString()); M_Yxydw.xzxg = "xz"; DataSet DS_Xydwservice = new DataSet(); DS_Xydwservice = B_Yxydw.GetList("xyh='" + strXyh + "'"); if (DS_Xydwservice != null && DS_Xydwservice.Tables[0].Rows.Count > 0) { M_Yxydw.id = Convert.ToInt32(DS_Xydwservice.Tables[0].Rows[0]["id"].ToString()); if (B_Yxydw.Update(M_Yxydw)) { s = common_file.common_app.get_suc; } } else { if (B_Yxydw.Add(M_Yxydw) > 0) { s = common_file.common_app.get_suc; } } } } return(s); }