//根据hykh_bz读取hykh
public static string GetHygl(string hykh_bz)
{
string get_value = "";
BLL.Hhygl B_Hhygl = new BLL.Hhygl();
Model.Hhygl M_Hhygl = new Model.Hhygl();
DataSet ds = B_Hhygl.GetList("hykh_bz='" + hykh_bz + "'");
if (ds.Tables[0].Rows.Count > 0)
{
get_value = ds.Tables[0].Rows[0]["parent_hykh"].ToString();
}
return(get_value);
}
public string Hhygl_add_edit_delete_app(string id, string yydh, string qymc, string hykh, string hyrx, string hykh_bz, string krxm, string krgj, string krmz, string yxzj, string zjhm, string krsr, string krxb, string krdh, string krsj, string krEmail, string krdz, string krzy, string krdw, string qzrx, string qzhm, string zjyxq, string tlyxq, string tjrq, string lzka, string bz, string hyjf, string shxg, string xgsj, string parent_hykh, string hymm, string xsy, string czy, string add_edit_delete, string xxzs)
{
string s = common_file.common_app.get_failure;
BLL.Hhygl B_Hhygl = new BLL.Hhygl();
Model.Hhygl M_Hhygl = new Model.Hhygl();
if (add_edit_delete == common_file.common_app.get_add)
{
M_Hhygl.yydh = yydh;
M_Hhygl.zjhm = zjhm;
M_Hhygl.zjyxq = Convert.ToDateTime(zjyxq);
M_Hhygl.bz = bz;
M_Hhygl.hyjf = Convert.ToDecimal(hyjf);
M_Hhygl.hykh = hykh;
M_Hhygl.hyrx = hyrx;
M_Hhygl.krdh = krdh;
M_Hhygl.krdw = krdw;
M_Hhygl.krdz = krdz;
M_Hhygl.krEmail = krEmail;
M_Hhygl.krgj = krgj;
M_Hhygl.krmz = krmz;
M_Hhygl.krsj = krsj;
M_Hhygl.krsr = Convert.ToDateTime(krsr);
M_Hhygl.krxb = krxb;
M_Hhygl.krxm = krxm;
M_Hhygl.krzy = krzy;
M_Hhygl.hykh_bz = hykh_bz;
M_Hhygl.lzka = lzka;
M_Hhygl.qymc = qymc;
M_Hhygl.qzhm = qzhm;
M_Hhygl.qzrx = qzrx;
M_Hhygl.shxg = Convert.ToBoolean(shxg);
M_Hhygl.tjrq = Convert.ToDateTime(tjrq);
M_Hhygl.tlyxq = Convert.ToDateTime(tlyxq);
M_Hhygl.xgsj = Convert.ToDateTime(xgsj);
M_Hhygl.yxzj = yxzj;
M_Hhygl.parent_hykh = parent_hykh;
M_Hhygl.hymm = hymm;
M_Hhygl.shqr = true;
M_Hhygl.xsy = xsy;
M_Hhygl.czy = czy;
M_Hhygl.djsj = DateTime.Now;
M_Hhygl.scsj = DateTime.Parse(common_file.common_app.cssj);
if (hhygl_shqr.hygl_shqr_add(yydh))
{
M_Hhygl.shqr = false;
}
else
{
M_Hhygl.shqr = true;
}
if (B_Hhygl.Add(M_Hhygl) > 0)
{
s = common_file.common_app.get_suc;
if (hhygl_shqr.hygl_shqr_add(yydh))
{
string dx_bz = "";
Hhygl_verifyCode Hhygl_verifyCode_new = new Hhygl_verifyCode();
if (Hhygl_verifyCode_new.Hhygl_SendMsm(hykh_bz, "", yydh, qymc, common_file.common_hyAction.hy_Action_HyNew, "", "", "", "", hykh_bz, "", xxzs).Equals(common_file.common_app.get_suc))
{
dx_bz = "发送成功";
}
else
{
dx_bz = "发送失败";
}
common_file.common_czjl.add_czjl(yydh, qymc, czy, "新增会员", "短信提醒", dx_bz, DateTime.Parse(xgsj.ToString()));
}
}
}
else
if (add_edit_delete == common_file.common_app.get_edit)
{
M_Hhygl = B_Hhygl.GetModel(Convert.ToInt32(id));
M_Hhygl.id = Convert.ToInt32(id);
M_Hhygl.yydh = yydh;
M_Hhygl.zjhm = zjhm;
M_Hhygl.zjyxq = Convert.ToDateTime(zjyxq);
M_Hhygl.bz = bz;
M_Hhygl.hyjf = Convert.ToDecimal(hyjf);
M_Hhygl.hykh = hykh;
M_Hhygl.hyrx = hyrx;
M_Hhygl.krdh = krdh;
M_Hhygl.krdw = krdw;
M_Hhygl.krdz = krdz;
M_Hhygl.krEmail = krEmail;
M_Hhygl.krgj = krgj;
M_Hhygl.krmz = krmz;
M_Hhygl.krsj = krsj;
M_Hhygl.krsr = Convert.ToDateTime(krsr);
M_Hhygl.krxb = krxb;
M_Hhygl.krxm = krxm;
M_Hhygl.krzy = krzy;
M_Hhygl.hykh_bz = hykh_bz;
M_Hhygl.lzka = lzka;
M_Hhygl.qymc = qymc;
M_Hhygl.qzhm = qzhm;
M_Hhygl.qzrx = qzrx;
M_Hhygl.shxg = Convert.ToBoolean(shxg);
M_Hhygl.tjrq = Convert.ToDateTime(tjrq);
M_Hhygl.tlyxq = Convert.ToDateTime(tlyxq);
M_Hhygl.xgsj = Convert.ToDateTime(xgsj);
M_Hhygl.yxzj = yxzj;
M_Hhygl.parent_hykh = parent_hykh;
M_Hhygl.hymm = hymm;
M_Hhygl.shqr = true;
M_Hhygl.xsy = xsy;
M_Hhygl.czy = czy;
if (B_Hhygl.Update(M_Hhygl))
{
s = common_file.common_app.get_suc;
}
}
else
{
if (add_edit_delete == common_file.common_app.get_delete)
{
if (id != "")
{
Model.Hhygl M_Hhygl_new = B_Hhygl.GetModel(int.Parse(id));
if (M_Hhygl_new != null)
{
BLL.Common B_common = new Hotel_app.BLL.Common();
B_common.ExecuteSql(" delete from Hhyjf_xfjl where hykh_bz='" + M_Hhygl_new.hykh_bz + "'");
B_common.ExecuteSql(" delete from Hhyjf_df where hykh_bz='" + M_Hhygl_new.hykh_bz + "'");
B_Hhygl.Delete(Convert.ToInt32(id));
}
s = common_file.common_app.get_suc;
}
}
}
return(s);
}
//下载会员信息
public static void DownLoad_Hygl()
{
BLL.Hhygl B_Hhygl = new BLL.Hhygl();
Model.Hhygl M_Hhygl = new Model.Hhygl();
string yydh = common_file.Common.Getqyxx(1);
string s = common_file.common_app.get_failure;
DataSet DS_download = new DataSet();
int rows = 0;
string csdatatime = "1800-01-01"; //远程传过来的初始时间
string jsdatatime = "1800-01-01"; //远程传过来的结束时间
url = common_file.Common.ReadXML("add", "url") + "/Hhygl/Hhygl_app.asmx";
object[] args = new object[5];
args[0] = yydh;
args[1] = rows;
args[2] = csdatatime;
args[3] = jsdatatime;
args[4] = DS_download;
object result = jdgl_res_head_app.DynamicWebServiceCall.InvokeWebService(url, "Hhygl_download", args);
if (result.ToString() == common_file.common_app.get_suc)
{
DS_download = (DataSet)args[4]; //下载好后把值传给本地数据库
jsdatatime = (String)args[3]; //读取结束时间
csdatatime = (String)args[2]; //读取初始时间
foreach (DataRow dr in DS_download.Tables[0].Rows)
{
string hykh_service = dr["hykh"].ToString();//读取会员卡号
M_Hhygl.yydh = dr["yydh"].ToString();
M_Hhygl.qymc = dr["qymc"].ToString();
M_Hhygl.hyrx = dr["hyrx"].ToString();
M_Hhygl.hykh = dr["hykh"].ToString();
M_Hhygl.hykh_bz = dr["hykh_bz"].ToString();
M_Hhygl.krxm = dr["krxm"].ToString();
M_Hhygl.krgj = dr["krgj"].ToString();
M_Hhygl.krmz = dr["krmz"].ToString();
M_Hhygl.yxzj = dr["yxzj"].ToString();
M_Hhygl.zjhm = dr["zjhm"].ToString();
M_Hhygl.krsr = Convert.ToDateTime(dr["krsr"].ToString());
M_Hhygl.krdh = dr["krdh"].ToString();
M_Hhygl.krsj = dr["krsj"].ToString();
M_Hhygl.krEmail = dr["krEmail"].ToString();
M_Hhygl.krdz = dr["krdz"].ToString();
M_Hhygl.krzy = dr["krzy"].ToString();
M_Hhygl.krdw = dr["krdw"].ToString();
M_Hhygl.qzrx = dr["qzrx"].ToString();
M_Hhygl.qzhm = dr["qzhm"].ToString();
M_Hhygl.zjyxq = Convert.ToDateTime(dr["zjyxq"].ToString());
M_Hhygl.tlyxq = Convert.ToDateTime(dr["tlyxq"].ToString());
M_Hhygl.tjrq = Convert.ToDateTime(dr["tjrq"].ToString());
M_Hhygl.lzka = dr["lzka"].ToString();
M_Hhygl.bz = dr["bz"].ToString();
M_Hhygl.djsj = Convert.ToDateTime(dr["djsj"].ToString());
M_Hhygl.hyjf = Convert.ToDecimal(dr["hyjf"].ToString());
M_Hhygl.shsc = true;
M_Hhygl.scsj = Convert.ToDateTime(jsdatatime);//取结束时间
M_Hhygl.xgsj = Convert.ToDateTime(dr["xgsj"].ToString());
M_Hhygl.shxg = false;
M_Hhygl.shqr = true;
M_Hhygl.is_top = Convert.ToBoolean(dr["is_top"].ToString());
M_Hhygl.is_select = Convert.ToBoolean(dr["is_select"].ToString());
M_Hhygl.fkje = Convert.ToDecimal(dr["fkje"].ToString());
M_Hhygl.parent_hykh = dr["parent_hykh"].ToString(); //主卡
M_Hhygl.czy = dr["czy"].ToString();
M_Hhygl.xsy = dr["xsy"].ToString();
//根据会员卡号读出相同的数据如果相同就修改,不然就直接下载到会员表
DataSet DS_Hhyglservice = new DataSet();
DS_Hhyglservice = B_Hhygl.GetList("hykh='" + hykh_service + "'");
if (DS_Hhyglservice != null && DS_Hhyglservice.Tables[0].Rows.Count > 0)
{
M_Hhygl.id = Convert.ToInt32(DS_Hhyglservice.Tables[0].Rows[0]["id"].ToString());
if (B_Hhygl.Update(M_Hhygl))
{
s = common_file.common_app.get_suc;
}
}
else
{
if (B_Hhygl.Add(M_Hhygl) > 0)
{
s = common_file.common_app.get_suc;
}
}
}
try
{
common_file.Common_hygl.Update_hygljf(DS_download);//下载完后重新计算积分
}
catch
{ }
}
Common.AddMsg(DS_download, "下载会员信息记录");
}
