//private void display_new_commonform_1(string judge_type_0, int left_0, int top_0, TextBox TB_ls) //{ // common_file.common_app.get_czsj(); // Xxtsz.X_common_one X_common_one_new = new Hotel_app.Xxtsz.X_common_one(); // X_common_one_new.judge_type = judge_type_0; // X_common_one_new.Left = common_file.common_app.x(); // X_common_one_new.Top = common_file.common_app.y(); // if (X_common_one_new.ShowDialog() == DialogResult.OK) // { // TB_ls.Text = X_common_one_new.get_value; // } // X_common_one_new.Dispose(); // TB_ls.Focus(); // Cursor.Current = Cursors.Default; //} private void b_save_Click(object sender, EventArgs e) { common_file.common_app.get_czsj(); if (checkTbValue()) { id_app = common_file.common_ddbh.ddbh("pzsk", "lsbhdate", "lsbhcounter", 6);//平帐收款 string url = common_file.common_app.service_url + "Szwgl/Szwgl_app.asmx"; object[] args = new object[30]; args[0] = "0";//Xxfxr_id args[1] = common_file.common_app.yydh; args[2] = common_file.common_app.qymc; args[3] = id_app; if ((openfrom == "Szw_Common") || (openfrom == "Sfjcz") || (openfrom == "Szw_pljz")) //部分算帐,记/挂分结都要生成新的jzbh { args[4] = ""; //初始jzbh为空 } if ((openfrom == "Sjjzwll")) { args[4] = jzbh; //B_sjzmx.GetModelList("id>=0 " + common_file.common_app.yydh_select + " and lsbh='" + lsbh + "'")[0].jzbh; } if (openfrom == "Szw_pljz") { args[5] = common_file.common_ddbh.ddbh("gzpj", "lsbhdate", "lsbhcounter", 6); //args[5] = this.lsbh; args[6] = jzzt; args[7] = ""; args[8] = ""; args[9] = ""; } else { args[5] = this.lsbh; args[6] = jzzt; args[7] = ""; args[8] = ""; args[9] = ""; } if ((openfrom == "Szw_Common") || (openfrom == "Sfjcz" && jjType == common_file.common_jzzt.czzt_bfsz))//部分算帐才会在主单里面找 { if (sk_tt == "sk") { M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModelList("id>=0 " + common_file.common_app.yydh_select + " and lsbh='" + this.lsbh + "'")[0]; M_Qskyd_fjrb = B_Qskyd_fjrb.GetModelList("id>=0 " + common_file.common_app.yydh_select + " and lsbh='" + this.lsbh + "'")[0]; args[6] = M_Qskyd_mainrecord.krxm; args[7] = M_Qskyd_fjrb.fjrb; args[8] = M_Qskyd_fjrb.fjbh; args[9] = M_Qskyd_mainrecord.sktt; } if (sk_tt == "tt") { M_Qttyd_mainrecord = B_Qttyd_mainrecord.GetModelList("id>=0 " + common_file.common_app.yydh_select + " and lsbh='" + this.lsbh + "'")[0]; args[6] = M_Qttyd_mainrecord.krxm; args[7] = ""; args[8] = ""; args[9] = M_Qttyd_mainrecord.sktt; } } //是从帐务浏览打开或者分结操作中的记/挂帐分结 else if (openfrom == "Sjjzwll" || (openfrom == "Sfjcz" && (jjType == common_file.common_jzzt.czzt_gz || jjType == common_file.common_jzzt.czzt_jz)))//是从帐务浏览打开的 { if (sk_tt == "sk") { BLL.Common B_common = new Hotel_app.BLL.Common(); DataSet ds_00 = B_common.GetList("select * from Sjzzd ", "id>=0 " + common_file.common_app.yydh_select + " and jzbh='" + jzbh + "'"); if (ds_00 != null && ds_00.Tables[0].Rows.Count > 0) { //M_Qskyd_mainrecord_bak = B_Qskyd_mainrecord_bak.GetModelList("id>=0 " + common_file.common_app.yydh_select + " and lsbh='" + this.lsbh + "'")[0]; //M_Qskyd_fjrb_bak = B_Qskyd_fjrb_bak.GetModelList("id>=0 " + common_file.common_app.yydh_select + " and lsbh='" + this.lsbh + "'")[0]; args[6] = ds_00.Tables[0].Rows[0]["krxm"].ToString(); args[7] = ""; args[8] = ds_00.Tables[0].Rows[0]["fjbh"].ToString(); args[9] = ds_00.Tables[0].Rows[0]["sktt"].ToString(); } } if (sk_tt == "tt") { //M_Qttyd_mainrecord_bak = B_Qttyd_mainrecord_bak.GetModelList("id>=0 " + common_file.common_app.yydh_select + " and lsbh='" + this.lsbh + "'")[0]; BLL.Common B_common = new Hotel_app.BLL.Common(); DataSet ds_00 = B_common.GetList("select * from Sjzzd ", "id>=0 " + common_file.common_app.yydh_select + " and jzbh='" + jzbh + "'"); if (ds_00 != null) { args[6] = ds_00.Tables[0].Rows[0]["krxm"].ToString(); args[7] = ""; args[8] = ""; args[9] = ds_00.Tables[0].Rows[0]["sktt"].ToString(); } else { args[6] = ""; args[7] = ""; args[8] = ""; args[9] = ""; } } } //xfrq,xfsj,czy,xfdr,xfrb,xfxm,xfbz,xfzy args[10] = DateTime.Now.ToString("yyyy-MM-dd"); args[11] = DateTime.Now.ToString(); args[12] = common_file.common_app.czy; args[13] = common_file.common_app.fkdr;//这里是找出节点的付款大类 args[14] = common_file.common_app.dj_pzsk; args[15] = common_file.common_app.dj_pzsk; args[16] = "平帐时,客户再付款为:" + tB_krzfk.Text.Trim() + ";客户最后收回:" + tB_krxsh.Text.Trim();//摘要描述平帐时的操作 args[17] = common_file.common_app.dj_pzsk; //xfje,yh,sjxfje,xfsl,czy_bc,czzt,czsj,syzd,add,xxzs if (krzqk > 0) { args[18] = "-" + krzqk.ToString().Trim().Replace("'", "-"); args[20] = "-" + krzqk.ToString().Trim().Replace("'", "-"); } if (krzqk < 0) { args[18] = Math.Abs(krzqk).ToString().Trim().Replace("'", "-"); args[20] = Math.Abs(krzqk).ToString().Trim().Replace("'", "-"); } args[19] = ""; args[21] = "1"; args[22] = common_file.common_app.czy_bc; if (openfrom == "Sjjzwll") { string czzt_Temp = (jjType == common_file.common_jzzt.czzt_gz) ? common_file.common_jzzt.czzt_gzzsz : common_file.common_jzzt.czzt_jzzsz; args[23] = czzt_Temp; } if (openfrom == "Sfjcz" && (jjType == common_file.common_jzzt.czzt_gz || jjType == common_file.common_jzzt.czzt_jz || jjType == common_file.common_jzzt.czzt_bfsz)) { string czzt_temp = ""; if (jjType == common_file.common_jzzt.czzt_gz || jjType == common_file.common_jzzt.czzt_gzfj) { czzt_temp = (jjType == common_file.common_jzzt.czzt_gz) ? jjType = common_file.common_jzzt.czzt_gzfj : jjType = common_file.common_jzzt.czzt_jzfj; } else { czzt_temp = common_file.common_jzzt.czzt_bfsz; } args[23] = czzt_temp; } else if (openfrom == "Szw_Common") { args[23] = jjType;//挂,记,结 直接用(当结帐时要更改相应记录的状态) } else if (openfrom == "Szw_pljz") { args[23] = common_file.common_jzzt.czzt_gzzsz; } //czsj, syzd, is_visible, add_edit_delete, xxzs,jjje //args[24] = common_file.common_app.xxzs,fkfs args[24] = DateTime.Now.ToString(); args[25] = common_file.common_app.syzd; args[26] = common_file.common_app.get_add; args[27] = common_file.common_app.xxzs; args[28] = tB_fkfs.Text.Trim(); args[29] = common_file.common_app.czy_GUID; Hotel_app.Server.Szwgl.Szw_jzOrgzOrSZ Szw_jzOrgzOrSZ_services = new Hotel_app.Server.Szwgl.Szw_jzOrgzOrSZ(); string result = Szw_jzOrgzOrSZ_services.Sjzmx_pz(args[0].ToString(), args[1].ToString(), args[2].ToString(), args[3].ToString(), args[4].ToString(), args[5].ToString(), args[6].ToString(), args[7].ToString(), args[8].ToString(), args[9].ToString(), args[10].ToString(), args[11].ToString(), args[12].ToString(), args[13].ToString(), args[14].ToString(), args[15].ToString(), args[16].ToString(), args[17].ToString(), args[18].ToString(), args[19].ToString(), args[20].ToString(), args[21].ToString(), args[22].ToString(), args[23].ToString(), args[24].ToString(), args[25].ToString(), args[26].ToString(), args[27].ToString(), args[28].ToString(), args[29].ToString()); //object result = Hotel_app.我的替换DynamicWebServiceCall.InvokeWebService(url, "Fun_PZ", args); if (result != null && result == common_file.common_app.get_suc) { common_file.common_app.Message_box_show(common_file.common_app.message_title, "平帐成功"); this.DialogResult = DialogResult.OK; //common_file.common_form.Szwcz_new.pz_control = true;//成功后,可以结帐 this.Close(); } } Cursor.Current = Cursors.Default; }
private void b_save_Click(object sender, EventArgs e) { common_file.common_app.get_czsj(); if (tB_fkfs.Text.Trim() == "") { common_file.common_app.Message_box_show(common_file.common_app.message_title, "请选择付款方式"); return; } else if (tB_xfje.Text.Trim() == "") { common_file.common_app.Message_box_show(common_file.common_app.message_title, "请填写付款金额"); return; } //既不是数字也不是decimal else if (((Maticsoft.Common.PageValidate.IsDecimal(tB_xfje.Text.Trim())) || (Maticsoft.Common.PageValidate.IsNumber(tB_xfje.Text.Trim()))) == false) { common_file.common_app.Message_box_show(common_file.common_app.message_title, "对不起,所输入的金额不是有效数字!"); tB_xfje.Focus(); } else { id_app = common_file.common_ddbh.ddbh("yjcz", "lsbhdate", "lsbhcounter", 6); //id, yydh, qymc, id_app, jzbh, lsbh, krxm, fjrb, fjbh, sktt, xfrq, xfsj, czy, xfdr, xfrb, xfxm, xfbz, xfzy, fkfs, xfje, sjxfje, czy_bc, syzd, add_edit_delete, xxzs string url = common_file.common_app.service_url + "Szwgl/Szwgl_app.asmx"; object[] args = new object[26]; args[0] = Syjcz_id; args[1] = common_file.common_app.yydh; args[2] = common_file.common_app.qymc; args[3] = id_app; if (openfrom == "Szwcl") //结记挂帐之前 { args[4] = ""; //结帐前jzbh为空 } else { //string jzbh_temp = DbHelperSQL.GetSingle("SELECT Jzbh from Sjzzd where lsbh='" + lsbh + "'").ToString(); args[4] = jzbh; } args[5] = lsbh; if (openfrom == "Szwcl") { if (sk_tt == "sk") { M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModelList("id>=0 " + common_file.common_app.yydh_select + " and lsbh='" + lsbh + "'")[0]; M_Qskyd_fjrb = B_Qskyd_fjrb.GetModelList("id>=0 " + common_file.common_app.yydh_select + " and Lsbh='" + lsbh + "'")[0]; args[6] = M_Qskyd_mainrecord.krxm; args[7] = M_Qskyd_fjrb.fjrb; args[8] = M_Qskyd_fjrb.fjbh; args[9] = M_Qskyd_mainrecord.sktt; } else if (sk_tt == "tt") { M_Qttyd_mainrecord = B_M_Qttyd_mainrecord.GetModelList("id>=0 " + common_file.common_app.yydh_select + " and lsbh='" + lsbh + "'")[0]; args[6] = M_Qttyd_mainrecord.krxm; args[7] = ""; args[8] = ""; args[9] = M_Qttyd_mainrecord.sktt; } } else { if (sk_tt == "sk") { List <Model.Qskyd_mainrecord_bak> list = new List <Hotel_app.Model.Qskyd_mainrecord_bak>(); list = B_Qskyd_mainrecord_bak.GetModelList("id>=0 " + common_file.common_app.yydh_select + " and lsbh='" + lsbh + "'"); if (list.Count > 0) { M_Qskyd_mainrecord_bak = list[0]; M_Qskyd_fjrb_bak = B_Qskyd_fjrb_bak.GetModelList("id>=0 " + common_file.common_app.yydh_select + " and Lsbh='" + lsbh + "'")[0]; args[6] = M_Qskyd_mainrecord_bak.krxm; args[7] = M_Qskyd_fjrb_bak.fjrb; if (M_Qskyd_fjrb_bak.fjbh != null) { args[8] = M_Qskyd_fjrb_bak.fjbh; } else { args[8] = ""; } args[9] = M_Qskyd_mainrecord_bak.sktt; } else { args[6] = ""; args[7] = ""; args[8] = ""; } } else if (sk_tt == "tt") { List <Model.Qttyd_mainrecord_bak> list = new List <Hotel_app.Model.Qttyd_mainrecord_bak>(); list = B_Qttyd_mainrecord_bak.GetModelList("id>=0 " + common_file.common_app.yydh_select + " and lsbh='" + lsbh + "'"); if (list.Count > 0) { M_Qttyd_mainrecord_bak = list[0]; args[6] = M_Qttyd_mainrecord_bak.krxm; } else { args[6] = ""; } args[7] = ""; args[8] = ""; if (list.Count > 0) { args[9] = M_Qttyd_mainrecord_bak.sktt; } else { args[9] = common_file.common_sktt.sktt_tt; } } } args[10] = DateTime.Now.ToString("yyyy-MM-dd"); args[11] = DateTime.Now.ToString(); args[12] = common_file.common_app.czy; args[13] = common_file.common_app.fkdr; args[14] = common_file.common_app.dj_ysk; args[15] = tB_xfxm.Text.Trim().Replace("'", "-"); args[16] = tB_bz.Text.Trim().Replace("'", "-"); args[17] = tB_fkzy.Text.Trim().Replace("'", "-"); args[18] = tB_fkfs.Text.Trim().Replace("'", "-"); args[19] = tB_xfje.Text.Trim().Replace("'", "-"); args[20] = tB_xfje.Text.Trim().Replace("'", "-"); args[21] = common_file.common_app.czy_bc; args[22] = common_file.common_app.syzd; args[23] = judge_add_edit; args[24] = common_file.common_app.xxzs; args[25] = DateTime.Now.ToString(); Hotel_app.Server.Szwgl.Syjcz Syjcz_new = new Hotel_app.Server.Szwgl.Syjcz(); string result = Syjcz_new.Syjcz_add_edit(args[0].ToString(), args[1].ToString(), args[2].ToString(), args[3].ToString(), args[4].ToString(), args[5].ToString(), args[6].ToString(), args[7].ToString(), args[8].ToString(), args[9].ToString(), args[10].ToString(), args[11].ToString(), args[12].ToString(), args[13].ToString(), args[14].ToString(), args[15].ToString(), args[16].ToString(), args[17].ToString(), args[18].ToString(), args[19].ToString(), args[20].ToString(), args[21].ToString(), args[22].ToString(), args[23].ToString(), args[24].ToString(), args[25].ToString()); // object result = Hotel_app.我的替换DynamicWebServiceCall.InvokeWebService(url, "Syjcz_add_edit", args); if (result == common_file.common_app.get_suc) { this.DialogResult = DialogResult.OK; common_file.common_app.Message_box_show(common_file.common_app.message_title, "保存成功!"); } else { common_file.common_app.Message_box_show(common_file.common_app.message_title, "操作失败!"); } } Cursor.Current = Cursors.Default; }
private void GetZzInfo() { common_file.common_app.get_czsj(); // 记、挂--转帐 if (Zz_Type == Szwgl.common_zw.zwzz_gz_tt || Zz_Type == Szwgl.common_zw.zwzz_jz_tt || Zz_Type == Szwgl.common_zw.zwzz_gz_sk || Zz_Type == Szwgl.common_zw.zwzz_jz_sk) { //帐务向团体转 if (Zz_Type == Szwgl.common_zw.zwzz_gz_tt || Zz_Type == Szwgl.common_zw.zwzz_jz_tt)//向团体转 { if (dg_tt.Rows.Count > 0) { if (dg_tt.CurrentRow != null) { int i = dg_tt.CurrentRow.Index; DataRowView dgr = dg_tt.CurrentRow.DataBoundItem as DataRowView; i = DS_Qtt.Tables[0].Rows.IndexOf(dgr.Row); if (i > -1 && i < dg_tt.Rows.Count)//当前行为内容行 { int id_temp = Convert.ToInt32(DS_Qtt.Tables[0].Rows[i]["id"].ToString()); M_Qttyd_mainrecord = B_Qttyd_mainrecord.GetModelList("Id=" + id_temp)[0]; lsbh_new = M_Qttyd_mainrecord.lsbh; } } else { return; } } else { return; } } //帐务向散客转 if (Zz_Type == Szwgl.common_zw.zwzz_gz_sk || Zz_Type == Szwgl.common_zw.zwzz_jz_sk)//向散客转 { if (dg_sk.Rows.Count > 0) { if (dg_sk.CurrentRow != null) { int i = dg_sk.CurrentRow.Index; DataRowView dgr = dg_sk.CurrentRow.DataBoundItem as DataRowView; if (dgr != null) { i = DS_Qsk.Tables[0].Rows.IndexOf(dgr.Row); if (i > -1 && i < dg_sk.Rows.Count)//当前行为内容行 { int id_temp = Convert.ToInt32(DS_Qsk.Tables[0].Rows[i]["id"].ToString()); //DS_Qsk.Tables[0].Rows[i]["id"].ToString(); M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModelList("id=" + id_temp)[0]; lsbh_new = M_Qskyd_mainrecord.lsbh; } } } else { return; } } else { return; } } //注意这里传的是记挂的结帐主单ID M_Sjzzd = B_Sjzzd.GetModel(int.Parse(id)); lsbh_old = M_Sjzzd.lsbh; jzbh_old = M_Sjzzd.jzbh; sk_tt = M_Sjzzd.sktt; } //在住---向团体转 if (Zz_Type == Szwgl.common_zw.zwzz_sk_tt || Zz_Type == Szwgl.common_zw.zwzz_tt_tt || Zz_Type == Szwgl.common_zw.zwzz_tt_sk || Zz_Type == Szwgl.common_zw.zwzz_sk_sk) { if (Zz_Type == Szwgl.common_zw.zwzz_sk_tt || Zz_Type == Szwgl.common_zw.zwzz_tt_tt) { if (dg_tt.Rows.Count > 0) { if (dg_tt.CurrentRow != null) { int i = dg_tt.CurrentRow.Index; DataRowView dgr = dg_tt.CurrentRow.DataBoundItem as DataRowView; if (dgr != null) { i = DS_Qtt.Tables[0].Rows.IndexOf(dgr.Row); if (i > -1 && i < dg_tt.Rows.Count)//当前行为内容行 { int id_temp = Convert.ToInt32(DS_Qtt.Tables[0].Rows[i]["id"].ToString()); M_Qttyd_mainrecord = B_Qttyd_mainrecord.GetModelList("Id=" + id_temp)[0]; lsbh_new = M_Qttyd_mainrecord.lsbh; } } if (Zz_Type == Szwgl.common_zw.zwzz_sk_tt) { M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModel(int.Parse(id)); lsbh_old = M_Qskyd_mainrecord.lsbh; sk_tt = M_Qskyd_mainrecord.sktt; } if (Zz_Type == Szwgl.common_zw.zwzz_tt_tt) { M_Qttyd_mainrecord = B_Qttyd_mainrecord.GetModel(int.Parse(id)); lsbh_old = M_Qttyd_mainrecord.lsbh; sk_tt = M_Qttyd_mainrecord.sktt; } } else { return; } } else { return; } } //在住---向散客转 if (Zz_Type == Szwgl.common_zw.zwzz_tt_sk || Zz_Type == Szwgl.common_zw.zwzz_sk_sk) { if (dg_sk.Rows.Count > 0) { if (dg_sk.CurrentRow != null) { int i = dg_sk.CurrentRow.Index; DataRowView dgr = dg_sk.CurrentRow.DataBoundItem as DataRowView; if (dgr != null) { i = DS_Qsk.Tables[0].Rows.IndexOf(dgr.Row); if (i > -1 && i < dg_sk.Rows.Count)//当前行为内容行 { int id_temp = Convert.ToInt32(DS_Qsk.Tables[0].Rows[i]["id"].ToString()); //DS_Qsk.Tables[0].Rows[i]["id"].ToString(); M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModelList("id=" + id_temp)[0]; lsbh_new = M_Qskyd_mainrecord.lsbh; } } if (Zz_Type == Szwgl.common_zw.zwzz_sk_sk) { { M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModel(int.Parse(id)); lsbh_old = M_Qskyd_mainrecord.lsbh; sk_tt = M_Qskyd_mainrecord.sktt; } } if (Zz_Type == Szwgl.common_zw.zwzz_tt_sk) { M_Qttyd_mainrecord = B_Qttyd_mainrecord.GetModel(int.Parse(id)); lsbh_old = M_Qttyd_mainrecord.lsbh; sk_tt = M_Qttyd_mainrecord.sktt; } } else { return; } } else { return; } } } Cursor.Current = Cursors.Default; }
//下载网上预订的方法 public static int Download_orderFrom400() { Model.Qskyd_mainrecord M_Qskyd_mainrecord = new Model.Qskyd_mainrecord(); BLL.Qskyd_mainrecord B_Qskyd_mainrecord = new BLL.Qskyd_mainrecord(); string lsbh = ""; string ddbh = ""; int dlsum = 0; string ss = common_app.get_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", obj); ss = result.ToString(); if (ss == common_app.get_suc) { #region 预订中心数据处理 try { DS_downloadData = (DataSet)obj[3]; foreach (DataRow dr in DS_downloadData.Tables[0].Rows) { string sktt_value = dr[30].ToString(); //第一步,生成本地临时编号 string lflsbh = common_file.common_ddbh.ddbh("lf", "skyddate", "skydcounter", 6);; //联房编号 string Remote_lsbh = dr[3].ToString(); //远程lsbh string Local_yydh = dr[1].ToString(); //中心服务的yydh string yydh = dr[1].ToString(); qymc = dr[2].ToString(); int xfCount = 0; //如果是团体直接添加到本地Qttyd_mainrecord表中和中心服务器Qydlsbhbg_yy表插入数据 if (sktt_value == common_app.sktt_tt) { //id,yydh,qymc,lsbh,ddbh,hykh,hykh_bz,hyrx,krxm,krbh,ydrxm, //krgj,krmz,yxzj,zjhm,krxb,krsr,krdh,krsj,krEmail,krdz, //qtyq,krly,xyh,xydw,xsy,ddsj,lksj,czy,ydsj,sktt, //yddj,vip_type,fjrb,fjbh,sjjg,jsjg,lzfs,lzts,lzrs,sfqr, //ydxg,shxg,shsc Model.Qttyd_mainrecord M_Qttyd_mainrecord = new Model.Qttyd_mainrecord(); BLL.Qttyd_mainrecord B_Qttyd_mainrecord = new BLL.Qttyd_mainrecord(); lsbh = common_file.common_ddbh.ddbh("ttyd", "ttyddate", "ttydcounter", 6); ddbh = common_file.common_ddbh.ddbh("ttyd", "ttyddate", "ttydcounter", 6); M_Qttyd_mainrecord.cznr = common_app.cznr_add; M_Qttyd_mainrecord.czsj = DateTime.Now; M_Qttyd_mainrecord.czy = dr[28].ToString(); M_Qttyd_mainrecord.ddbh = ddbh; M_Qttyd_mainrecord.ddly = common_app.ddly; M_Qttyd_mainrecord.ddrx = ""; M_Qttyd_mainrecord.ddsj = Convert.ToDateTime(dr[26].ToString()).AddHours(12); M_Qttyd_mainrecord.ddwz = ""; M_Qttyd_mainrecord.ddyy = ""; M_Qttyd_mainrecord.ffshys = false; M_Qttyd_mainrecord.krbh = dr[9].ToString(); M_Qttyd_mainrecord.krdh = dr[17].ToString(); M_Qttyd_mainrecord.krdz = dr[20].ToString(); M_Qttyd_mainrecord.krEmail = dr[19].ToString(); M_Qttyd_mainrecord.krgj = dr[11].ToString(); M_Qttyd_mainrecord.krly = dr[22].ToString(); M_Qttyd_mainrecord.krsj = dr[18].ToString(); M_Qttyd_mainrecord.krxm = dr[8].ToString(); M_Qttyd_mainrecord.lksj = Convert.ToDateTime(dr[27].ToString()).AddHours(12); M_Qttyd_mainrecord.lsbh = lsbh; M_Qttyd_mainrecord.lzts = Convert.ToInt32(dr[38].ToString()); M_Qttyd_mainrecord.qtyq = dr[21].ToString(); M_Qttyd_mainrecord.qymc = qymc; M_Qttyd_mainrecord.sdcz = false; M_Qttyd_mainrecord.shsc = true; M_Qttyd_mainrecord.sktt = common_app.sktt_tt; M_Qttyd_mainrecord.syzd = ""; M_Qttyd_mainrecord.tsyq = ""; M_Qttyd_mainrecord.xsy = dr[25].ToString(); M_Qttyd_mainrecord.xydw = dr[24].ToString(); M_Qttyd_mainrecord.xyh = dr[23].ToString(); M_Qttyd_mainrecord.yddj = common_app.yddj_yd; M_Qttyd_mainrecord.ydrxm = dr[10].ToString(); M_Qttyd_mainrecord.yydh = yydh; M_Qttyd_mainrecord.zyzt = ""; M_Qttyd_mainrecord.ddyy = common_app.ddyy;//标志网上预订 M_Qskyd_mainrecord.zyzt = common_app.yddj_yd; B_Qttyd_mainrecord.Add(M_Qttyd_mainrecord); //向中心服务器加本地的新生成的lsbh,成功后修改web_skyd的shsc = 1都放在同一个存储过程注意, InsertToQyddjlsbhbg_yy(Remote_lsbh, lsbh, Local_yydh); } //第二步,1.sktt=散客,根据房间数量生成相对应的Qskyd_mainrecord主单和中心服务器Qydlsbhbg_yy表插入数据,修改Qskyd_fjrb表里的fjrb,lzfs,shsc,并且添加到联房。 // 2.sktt=团体,如果是第一条房型的话就直接修改Qskyd_fjrb,第二种房型就直接加到Qskyd_fjrb表 DataSet DS_Fjrb = Qskydfjrb_ds(qymc, Remote_lsbh); foreach (DataRow rb in DS_Fjrb.Tables[0].Rows) { xfCount++; string lzfs = rb[12].ToString().Substring(0, rb[12].ToString().TrimEnd().IndexOf(".")); int qc_lzfsa = int.Parse(lzfs.ToString()); string qc_fjrb = rb[8].ToString(); //房间类别 decimal qc_lzfs = Convert.ToDecimal(rb[12].ToString()); //入住房数 decimal qc_fjjg = Convert.ToDecimal(rb[14].ToString()); if (qc_lzfsa > 0) { #region 如果sktt=散客。 if (sktt_value == common_app.sktt_sk)//如果是散客 { for (int i = 0; i <= qc_lzfsa - 1; i++) { //id,yydh,qymc,lsbh,ddbh,hykh,hykh_bz,hyrx,krxm,krbh,ydrxm, //krgj,krmz,yxzj,zjhm,krxb,krsr,krdh,krsj,krEmail,krdz, //qtyq,krly,xyh,xydw,xsy,ddsj,lksj,czy,ydsj,sktt, //yddj,vip_type,fjrb,fjbh,sjjg,jsjg,lzfs,lzts,lzrs,sfqr, //ydxg,shxg,shsc lsbh = common_file.common_ddbh.ddbh("skyd", "skyddate", "skydcounter", 6); ddbh = common_file.common_ddbh.ddbh("skyd", "skyddate", "skydcounter", 6); string krxm = dr[8].ToString(); M_Qskyd_mainrecord.lsbh = lsbh; M_Qskyd_mainrecord.yydh = yydh; M_Qskyd_mainrecord.qymc = qymc; M_Qskyd_mainrecord.ddbh = ddbh; M_Qskyd_mainrecord.hykh = dr[5].ToString(); M_Qskyd_mainrecord.hyrx = dr[7].ToString(); M_Qskyd_mainrecord.krxm = krxm; M_Qskyd_mainrecord.krgj = dr[11].ToString(); M_Qskyd_mainrecord.krmz = dr[12].ToString(); M_Qskyd_mainrecord.yxzj = dr[13].ToString(); M_Qskyd_mainrecord.zjhm = dr[14].ToString(); M_Qskyd_mainrecord.krxb = dr[15].ToString(); M_Qskyd_mainrecord.krsj = dr[18].ToString(); M_Qskyd_mainrecord.krEmail = dr[19].ToString(); M_Qskyd_mainrecord.krdz = dr[20].ToString(); M_Qskyd_mainrecord.krly = dr[22].ToString(); M_Qskyd_mainrecord.yddj = common_app.yddj_yd; M_Qskyd_mainrecord.sktt = common_app.sktt_sk; M_Qskyd_mainrecord.ddly = common_app.ddly; M_Qskyd_mainrecord.cznr = common_app.cznr_add; M_Qskyd_mainrecord.xyh = dr[23].ToString(); M_Qskyd_mainrecord.xydw = dr[24].ToString(); M_Qskyd_mainrecord.xsy = dr[25].ToString(); M_Qskyd_mainrecord.ddsj = Convert.ToDateTime(dr[26].ToString()).AddHours(12); M_Qskyd_mainrecord.lksj = Convert.ToDateTime(dr[27].ToString()).AddHours(12); M_Qskyd_mainrecord.czy = dr[28].ToString(); M_Qskyd_mainrecord.hykh_bz = dr[6].ToString(); M_Qskyd_mainrecord.lzts = Convert.ToInt32(dr[38].ToString()); M_Qskyd_mainrecord.shsc = true; M_Qskyd_mainrecord.ddyy = common_app.ddyy; //标志网上预订 M_Qskyd_mainrecord.zyzt = common_app.yddj_yd; M_Qskyd_mainrecord.qtyq = dr[21].ToString(); //其它要求 B_Qskyd_mainrecord.Add(M_Qskyd_mainrecord); //向中心服务器加本的新生成的lsbh成功后修改web_skyd各web_Qskyd_fjrb中字段shsc = 1都放在同一个存储过程注意; InsertToQyddjlsbhbg_yy(Remote_lsbh, lsbh, Local_yydh); //下载完后修改本地Qskyd_fjrb表fjrb,fjjg等 Qskyd_fjrb_Update(lsbh, qc_fjrb, 1, qc_fjjg, qc_fjjg); //下载完后添加到联房里 Common_flfsz.Flfsz_add(yydh, qymc, lflsbh, lsbh, "", krxm, common_app.sktt_sk, common_app.yddj_yd, dr[28].ToString()); } dlsum = int.Parse(DS_downloadData.Tables[0].Rows.Count.ToString());//返回行数 } #endregion #region 如果是团体 else if (sktt_value == common_app.sktt_tt)//如果是团体 { //修改本地Qskyd_fjrb表中的房型 //1.如果是第一条房型的话就直接修改Qskyd_fjrb。 //2.除第一条其它数据就直接添加房型 if (xfCount == 1) { Qskyd_fjrb_Update(lsbh, qc_fjrb, qc_lzfs, qc_fjjg, qc_fjjg); } else { Model.Qskyd_fjrb M_fjrb = new Model.Qskyd_fjrb(); BLL.Qskyd_fjrb B_fjrb = new BLL.Qskyd_fjrb(); M_fjrb.yydh = yydh; M_fjrb.yddj = common_app.yddj_yd; M_fjrb.sktt = common_app.sktt_tt; M_fjrb.sjfjjg = Convert.ToDecimal(rb[15].ToString()); M_fjrb.shsc = true; M_fjrb.shqh = rb[13].ToString(); M_fjrb.qymc = qymc; M_fjrb.lzfs = Convert.ToDecimal(rb[12].ToString()); M_fjrb.lsbh = lsbh; M_fjrb.lksj = Convert.ToDateTime(dr[27].ToString()).AddHours(12); M_fjrb.krxm = rb[5].ToString(); M_fjrb.fjrb = rb[8].ToString(); M_fjrb.fjjg = Convert.ToDecimal(rb[15].ToString()); M_fjrb.fjbh = ""; M_fjrb.fjbm = ""; M_fjrb.ddsj = Convert.ToDateTime(dr[26].ToString()).AddHours(12); M_fjrb.bz = rb[16].ToString(); M_fjrb.cznr = common_app.cznr_add; M_fjrb.czy = dr[28].ToString(); B_fjrb.Add(M_fjrb); } dlsum = int.Parse(DS_downloadData.Tables[0].Rows.Count.ToString());//返回行数 } #endregion //UpdateWeb_skyd_fjrb_shsc(int.Parse(rb[0].ToString())); } } } return(dlsum); } catch (Exception ee) { errorInfo = ee.Message.ToString(); postion = "向本地Qskyd_mainrecord插入数据之后到修改远程服务器下载数据的过程之中"; Common.WriteLog(errorInfo, postion); } #endregion } return(dlsum); }