//协议单位信息下载，供特定门店下载返回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);
}