//协议单位信息下载,供特定门店下载返回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_yy">传过来的协议单位的DS</param> /// <param name="qymc">企业名称</param> /// <returns></returns> public string Yxydw_add_DS(DataSet DS_Yxydw, string xx_zs) { 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) { DbHelperSQL.ExecuteSql("delete from Web_Yxydw where yydh='" + DS_Yxydw.Tables[0].Rows[0]["yydh"].ToString() + "'"); foreach (DataRow dr in DS_Yxydw.Tables[0].Rows) { SqlParameter[] parameters = { new SqlParameter("@krly", SqlDbType.VarChar, 50), new SqlParameter("@yydh", SqlDbType.VarChar, 50), new SqlParameter("@qymc", SqlDbType.VarChar, 50), new SqlParameter("@xyrx", SqlDbType.VarChar, 50), new SqlParameter("@krgj", SqlDbType.VarChar, 50), new SqlParameter("@pq", SqlDbType.VarChar, 50), new SqlParameter("@xyh", SqlDbType.VarChar, 50), new SqlParameter("@xyh_inner", SqlDbType.VarChar, 50), new SqlParameter("@rx", SqlDbType.VarChar, 50), new SqlParameter("@xydw", SqlDbType.VarChar, 50), new SqlParameter("@zjm", SqlDbType.VarChar, 50), new SqlParameter("@nxr", SqlDbType.VarChar, 50), new SqlParameter("@krdh", SqlDbType.VarChar, 50), new SqlParameter("@krcz", SqlDbType.VarChar, 50), new SqlParameter("@krEmail", SqlDbType.VarChar, 50), new SqlParameter("@krdz", SqlDbType.VarChar, 200), new SqlParameter("@xsy", SqlDbType.VarChar, 50), new SqlParameter("@shsc", SqlDbType.Bit, 1), new SqlParameter("@bz", SqlDbType.VarChar, 300), new SqlParameter("@lzfs", SqlDbType.Decimal, 9), new SqlParameter("@fkje", SqlDbType.Decimal, 9), new SqlParameter("@xfje", SqlDbType.Decimal, 9), new SqlParameter("@clsj", SqlDbType.DateTime), new SqlParameter("@xzxg", SqlDbType.VarChar, 50), new SqlParameter("@is_top", SqlDbType.Bit, 1), new SqlParameter("@is_select", SqlDbType.Bit, 1), new SqlParameter("@shsh", SqlDbType.Bit, 1), new SqlParameter("@sign_image", SqlDbType.Image) }; parameters[0].Value = dr["krly"].ToString(); parameters[1].Value = dr["yydh"].ToString(); parameters[2].Value = dr["qymc"].ToString(); parameters[3].Value = dr["xyrx"].ToString(); parameters[4].Value = dr["krgj"].ToString(); parameters[5].Value = dr["pq"].ToString(); parameters[6].Value = dr["xyh"].ToString(); parameters[7].Value = dr["xyh_inner"].ToString(); parameters[8].Value = dr["rx"].ToString(); parameters[9].Value = dr["xydw"].ToString(); parameters[10].Value = dr["zjm"].ToString(); parameters[11].Value = dr["nxr"].ToString(); parameters[12].Value = dr["krdh"].ToString(); parameters[13].Value = dr["krcz"].ToString(); parameters[14].Value = dr["kremail"].ToString(); parameters[15].Value = dr["krdz"].ToString(); parameters[16].Value = dr["xsy"].ToString(); parameters[17].Value = true; parameters[18].Value = dr["bz"].ToString(); parameters[19].Value = Convert.ToDecimal(dr["lzfs"].ToString()); parameters[20].Value = Convert.ToDecimal(dr["fkje"].ToString()); parameters[21].Value = Convert.ToDecimal(dr["xfje"].ToString()); parameters[22].Value = DateTime.Now; parameters[23].Value = dr["xzxg"].ToString(); parameters[24].Value = Convert.ToBoolean(dr["is_top"].ToString()); parameters[25].Value = Convert.ToBoolean(dr["is_select"].ToString()); parameters[26].Value = Convert.ToBoolean(dr["shsh"].ToString()); parameters[27].Value = (byte[])(dr["sign_image"]); int stryxydwa = SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "Web_Yxydw_ADD", parameters); if (stryxydwa > 0) { s = common_file.common_app.get_suc; } } } return(s); }
/// <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); }