/// <summary>
/// 门店上传散客房间到中心服务器
/// </summary>
/// <returns></returns>
public static int UpLoad_Qskyd_fjrb()
{
int i = 0;
string s = common_app.get_failure;
Model.Qskyd_fjrb M_Qskyd_fjrb = new Model.Qskyd_fjrb();
BLL.Qskyd_fjrb B_Qskyd_fjrb = new BLL.Qskyd_fjrb();
BLL.Fwx_other B_Fwx_other = new BLL.Fwx_other();
DataSet DS_Qskyd_fjrb = new DataSet();
DataSet DS_Fwx_other = new DataSet();
DS_Qskyd_fjrb = B_Qskyd_fjrb.GetList("1=1");
DS_Fwx_other = B_Fwx_other.GetList("1=1");
if (DS_Qskyd_fjrb != null && DS_Qskyd_fjrb.Tables[0].Rows.Count > 0)
{
object[] args = new object[2];
args[0] = DS_Fwx_other;
args[1] = DS_Qskyd_fjrb;
object result = jdgl_res_head_app.DynamicWebServiceCall.InvokeWebService(url, "Qskyd_fjrb_temp_ADD", args);
if (result.ToString() == common_file.common_app.get_suc)
{
Common_Shsc.Updatshsc(DS_Qskyd_fjrb, "Qskyd_fjrb");
Common_Shsc.Updatshsc(DS_Fwx_other, "Fwx_other");
i += Common_Shsc.GetRowCount(DS_Qskyd_fjrb);
i += Common_Shsc.GetRowCount(DS_Fwx_other);
Common.AddMsg(DS_Qskyd_fjrb, "上传房间类别");
Common.AddMsg(DS_Fwx_other, "上传维修房");
}
}
return(i++);
}
private bool judge_kyfs(string krxm_0, string fjbh_0, string lsbh_0)
{
float ylfs = 0; string fjrb_old = tB_fjrb.Text;
if (judge_add_edit == common_file.common_app.get_edit)
{
Model.Qskyd_fjrb M_Qskyd_fjrb_temp = B_Qskyd_fjrb.GetModel(int.Parse(Qskdj_fjrb_id));
ylfs = float.Parse(M_Qskyd_fjrb_temp.lzfs.ToString());
fjrb_old = M_Qskyd_fjrb_temp.fjrb;
}
return(common_file.common_used_fjzt.judge_kyfs(judge_add_edit, yddj, tB_lzfs.Text, ylfs, fjrb_old, tB_fjrb.Text, ddsj, lksj, krxm_0, fjbh_0, lsbh_0, ""));
}
//public string add_fjbh_dj_fjzt(string fjbh, Model.Qskyd_fjrb M_Qskyd_fjrb, DateTime czsj, string czy, string xxzs)
////登记时变更去修改房态,返回成功或失败
//{
// string s = common_file.common_app.get_failure;
// string krxm0 = ""; string sktt0 = ""; string lsbh0 = "";
// bool shlf0 = false; bool shts0 = false; bool shvip0 = false; bool fjbm0 = false;
// BLL.Ffjzt B_Ffjzt = new Hotel_app.BLL.Ffjzt();
// DataSet ds_temp = B_Ffjzt.GetList("fjbh='" + fjbh + "'");
// Model.Ffjzt M_Ffjzt;
// Ffjzt.Ffjzt_add_edit Ffjzt_add_edit_new = new Hotel_app.Ffjzt.Ffjzt_add_edit();
// if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
// {
// M_Ffjzt = B_Ffjzt.GetModel(int.Parse(ds_temp.Tables[0].Rows[0]["id"].ToString()));
// lsbh0 = M_Qskyd_fjrb.lsbh;
// krxm0 = M_Qskyd_fjrb.krxm;
// sktt0 = M_Qskyd_fjrb.sktt;
// shlf0 = common_file.common_fjzt.Islf(lsbh0); //判断是否联房
// shts0 = common_file.common_fjzt.Ists(lsbh0);//判断是否特殊
// shvip0 = common_file.common_fjzt.IsVIP(lsbh0);//判断是否VIP或会员
// fjbm0 = common_file.common_fjzt.Isbm(lsbh0);
// Ffjzt_add_edit_new.Ffjzt_xgft(common_file.common_fjzt.zzf, M_Ffjzt.zyzt_second, M_Ffjzt.zybz, fjbh, krxm0, M_Qskyd_fjrb.ddsj, M_Qskyd_fjrb.lksj, M_Ffjzt.yd_ddsj, M_Ffjzt.yd_lksj, shlf0, shts0, shvip0,fjbm0, sktt0, lsbh0, czsj, czy, common_file.common_fjzt.ff, xxzs);
// s = common_file.common_app.get_suc;
// }
// return s;
//}
//登记时变更去修改房态,返回成功或失败
public string add_fjbh_dj_fjzt(string fjbh, Model.Qskyd_fjrb M_Qskyd_fjrb, DateTime czsj, string czy, string xxzs)
{
string s = common_file.common_app.get_failure;
string krxm0 = ""; string sktt0 = ""; string lsbh0 = "";
bool shlf0 = false; bool shts0 = false; bool shvip0 = false; bool fjbm0 = false;
BLL.Ffjzt B_Ffjzt = new Hotel_app.BLL.Ffjzt();
DataSet ds_temp = B_Ffjzt.GetList("fjbh='" + fjbh + "'");
Model.Ffjzt M_Ffjzt;
Ffjzt.Ffjzt_add_edit Ffjzt_add_edit_new = new Hotel_app.Server.Ffjzt.Ffjzt_add_edit();
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
{
M_Ffjzt = B_Ffjzt.GetModel(int.Parse(ds_temp.Tables[0].Rows[0]["id"].ToString()));
lsbh0 = M_Qskyd_fjrb.lsbh;
krxm0 = M_Qskyd_fjrb.krxm;
sktt0 = M_Qskyd_fjrb.sktt;
DateTime yd_ddsj_temp = M_Qskyd_fjrb.ddsj;
DateTime yd_lksj_temp = M_Qskyd_fjrb.lksj;
shlf0 = common_file.common_fjzt.Islf(lsbh0); //判断是否联房
shts0 = common_file.common_fjzt.Ists(lsbh0); //判断是否特殊
shvip0 = common_file.common_fjzt.IsVIP(lsbh0); //判断是否VIP或会员
fjbm0 = common_file.common_fjzt.Isbm(lsbh0);
Ffjzt_add_edit_new.Ffjzt_xgft(common_file.common_fjzt.zzf, M_Ffjzt.zyzt_second, M_Ffjzt.zybz, fjbh, krxm0, M_Qskyd_fjrb.ddsj, M_Qskyd_fjrb.lksj, M_Ffjzt.yd_ddsj, M_Ffjzt.yd_lksj, shlf0, shts0, shvip0, fjbm0, sktt0, lsbh0, czsj, czy, common_file.common_fjzt.ff, xxzs);
M_Ffjzt = B_Ffjzt.GetModel(int.Parse(ds_temp.Tables[0].Rows[0]["id"].ToString()));
if (M_Ffjzt != null)
{
if (M_Ffjzt.yd_ddsj == yd_ddsj_temp && M_Ffjzt.yd_lksj == yd_lksj_temp)
{
M_Ffjzt.zyzt_second = "";
M_Ffjzt.yd_ddsj = DateTime.Parse(common_file.common_app.cssj);
M_Ffjzt.yd_lksj = DateTime.Parse(common_file.common_app.cssj);
B_Ffjzt.Update(M_Ffjzt);
}
}
s = common_file.common_app.get_suc;
}
//s = common_file.common_app.get_suc;
return(s);
}
//2012.5.11本地传到远程的Qskyd_fjrb_temp然后在添加到Qskyd_fjrb表
//1.如果有相同的lsbh就修改，否者添加。
//2.最后和Qskyd_fjrb_temp这张表对比，如果Qskyd_fjrb not in(lsbh)的条件就删除
//这样做是怕本的删除了远程有可能还有这条记录在
public static string Add_Qskyd_fjrb(DataSet DS_Qskyd_fjrb, string yydh)
{
// id,yydh,qymc,lsbh,krxm,sktt,yddj,fjrb,fjbh,ddsj,lksj,lzfs,shqh,fjjg,sjfjjg,yh,yhbl,bz,is_top,
//is_select,shsc,czy,czsj,cznr,sdcz,fjbm,jcje
string s = common_file.common_app.get_failure;
if (DS_Qskyd_fjrb != null && DS_Qskyd_fjrb.Tables[0].Rows.Count > 0)
{
Model.Qskyd_fjrb M_Qskyd_fjrb = new Model.Qskyd_fjrb();
BLL.Qskyd_fjrb B_Qskyd_fjrb = new BLL.Qskyd_fjrb();
string strlsbh_ds = ""; //记录总的lsbh以“，”号隔开
foreach (DataRow dr in DS_Qskyd_fjrb.Tables[0].Rows)
{
string strLsbh = dr["lsbh"].ToString();
M_Qskyd_fjrb.lsbh = dr["lsbh"].ToString();
M_Qskyd_fjrb.yydh = dr["yydh"].ToString();
M_Qskyd_fjrb.qymc = dr["qymc"].ToString();
M_Qskyd_fjrb.krxm = dr["krxm"].ToString();
M_Qskyd_fjrb.sktt = dr["sktt"].ToString();
M_Qskyd_fjrb.yddj = dr["yddj"].ToString();
M_Qskyd_fjrb.fjrb = dr["fjrb"].ToString();
M_Qskyd_fjrb.fjbh = dr["fjbh"].ToString();
M_Qskyd_fjrb.ddsj = Convert.ToDateTime(dr["ddsj"].ToString());
M_Qskyd_fjrb.lksj = Convert.ToDateTime(dr["lksj"].ToString());
M_Qskyd_fjrb.lzfs = Convert.ToDecimal(dr["lzfs"].ToString());
M_Qskyd_fjrb.shqh = dr["shqh"].ToString();
M_Qskyd_fjrb.fjjg = Convert.ToDecimal(dr["fjjg"].ToString());
M_Qskyd_fjrb.sjfjjg = Convert.ToDecimal(dr["sjfjjg"].ToString());
M_Qskyd_fjrb.yh = "";
M_Qskyd_fjrb.yhbl = 0;
M_Qskyd_fjrb.bz = "";
M_Qskyd_fjrb.is_top = false;
M_Qskyd_fjrb.is_select = false;
M_Qskyd_fjrb.shsc = true;
M_Qskyd_fjrb.czy = dr["czy"].ToString();
M_Qskyd_fjrb.czsj = Convert.ToDateTime(dr["czsj"].ToString());
M_Qskyd_fjrb.cznr = dr["cznr"].ToString();
//如果有相同lsbh就修改，，然后添加。
DataSet ds = B_Qskyd_fjrb.GetList("lsbh='" + strLsbh + "' and fjrb='" + dr["fjrb"].ToString() + "'");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
int fid = Convert.ToInt32(ds.Tables[0].Rows[0]["id"].ToString());
M_Qskyd_fjrb.id = fid;
if (B_Qskyd_fjrb.Update(M_Qskyd_fjrb))
{
s = common_file.common_app.get_suc;
}
}
else
{
//添加到Qskyd_fjrb表里
if (B_Qskyd_fjrb.Add(M_Qskyd_fjrb) > 0)
{
s = common_file.common_app.get_suc;
}
}
strlsbh_ds += "'" + strLsbh + "'" + ","; //累加lsbh以“，”号相隔
}
s = common_file.common_app.get_suc;
//相反不相等的话就删除，防止本地删除中央服务器还没有删除lsbh not in
if (strlsbh_ds.Length != 0)
{
strlsbh_ds = strlsbh_ds.Remove(strlsbh_ds.Length - 1, 1);//删除最后一个，号
string strsql = "delete from Qskyd_fjrb where lsbh not in(" + strlsbh_ds + ") and yydh='" + yydh + "'";
DbHelperSQL.Exists(strsql);
s = common_file.common_app.get_suc;
}
}
return(s);
}
//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;
}
public void delete_fjrb(DataGridViewSummary dg_fjrb, Model.Qskyd_fjrb M_Qskyd_fjrb, BLL.Qskyd_fjrb B_Qskyd_fjrb)
{
common_file.common_app.get_czsj();
if (dg_fjrb.Rows.Count > 0 && dg_fjrb.Rows[0].Cells["id"].Value != null && dg_fjrb.Rows[0].Cells["id"].Value.ToString() != string.Empty)
{
if (dg_fjrb.CurrentRow.Index >= 0 || dg_fjrb.Rows.Count > 0)
{
if (common_file.common_app.message_box_show_select(common_file.common_app.message_title, "你真的要删除所选的记录吗？") == true)
{
string id = dg_fjrb.Rows[dg_fjrb.CurrentRow.Index].Cells["id"].Value.ToString();
M_Qskyd_fjrb = B_Qskyd_fjrb.GetModel(int.Parse(id));
if (M_Qskyd_fjrb != null)
{
if (M_Qskyd_fjrb.fjbh == "" && M_Qskyd_fjrb.fjrb == "")
{
common_file.common_app.Message_box_show(common_file.common_app.message_title, "对不起,当前记录只能修改！");
return;
}
if (M_Qskyd_fjrb.fjbh != "" && M_Qskyd_fjrb.fjrb != "")
{
common_file.common_app.Message_box_show(common_file.common_app.message_title, "对不起,排房记录不能在此删除！若要删除，请到主单去操作！");
return;
}
if (M_Qskyd_fjrb.fjbh == "" && M_Qskyd_fjrb.fjrb != "")
{
BLL.Common B_Common = new Hotel_app.BLL.Common();
DataSet ds_temp = B_Common.GetList("select * from Qskyd_fjrb", "lsbh='" + M_Qskyd_fjrb.lsbh + "'");
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 1)
{
common_file.common_app.get_czsj();
string url = common_file.common_app.service_url + "Qyddj/Qyddj_app.asmx";
object[] args = new object[26];
args[0] = id;
args[1] = common_file.common_app.yydh;
args[2] = common_file.common_app.qymc;
args[3] = M_Qskyd_fjrb.lsbh;
args[4] = M_Qskyd_fjrb.krxm;
args[5] = M_Qskyd_fjrb.sktt;
args[6] = M_Qskyd_fjrb.yddj;
args[7] = M_Qskyd_fjrb.fjrb;
args[8] = M_Qskyd_fjrb.fjbh;
args[9] = M_Qskyd_fjrb.ddsj;
args[10] = M_Qskyd_fjrb.lksj;
args[11] = M_Qskyd_fjrb.lzfs;
args[12] = M_Qskyd_fjrb.shqh;
args[13] = M_Qskyd_fjrb.fjjg;
args[14] = M_Qskyd_fjrb.sjfjjg;
args[15] = M_Qskyd_fjrb.yh;
args[16] = M_Qskyd_fjrb.yhbl;
args[17] = M_Qskyd_fjrb.bz;
args[18] = common_file.common_app.czy;
args[19] = DateTime.Now;
args[20] = common_file.common_app.chinese_delete;
args[21] = M_Qskyd_fjrb.yddj;//有三种状态,一种预订、一种登记、一种预订转登记
args[22] = common_file.common_app.get_delete;
args[23] = common_file.common_app.xxzs;
args[24] = "";
args[25] = decimal.Parse("0");
Hotel_app.Server.Qyddj.Qskyd_fjrb_add_edit_delete Qskyd_fjrb_add_edit_delete_services = new Hotel_app.Server.Qyddj.Qskyd_fjrb_add_edit_delete();
string result = Qskyd_fjrb_add_edit_delete_services.Qskyd_fjrb_add_edit_delete_app(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(), DateTime.Parse(args[9].ToString()), DateTime.Parse(args[10].ToString()), Decimal.Parse(args[11].ToString()), args[12].ToString(), Decimal.Parse(args[13].ToString()),
Decimal.Parse(args[14].ToString()), args[15].ToString(), Decimal.Parse(args[16].ToString()), args[17].ToString(), args[18].ToString(), DateTime.Parse(args[19].ToString()), args[20].ToString(), args[21].ToString(), args[22].ToString(), args[23].ToString(), args[24].ToString(), Decimal.Parse(args[25].ToString()));
// object result = Hotel_app.我的替换DynamicWebServiceCall.InvokeWebService(url, "Qskyd_fjrb_add_edit_delete_app", args);
if (result == common_file.common_app.get_suc)
{
dg_fjrb.Rows.Remove(dg_fjrb.CurrentRow);
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, "操作失败！");
}
}
else
{
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, "你好,找不到相应的记录！");
}
}
}
else
{
//提示
common_file.common_app.Message_box_show(common_file.common_app.message_title, "你好,你没有选择任何信息！");
}
}
Cursor.Current = Cursors.Default;
}
public string Qskyd_fjrb_add_edit_delete_app_1(string id, string yydh, string qymc, string lsbh, string krxm, string sktt, string yddj, string fjrb, string fjbh, DateTime ddsj, DateTime lksj, Decimal lzfs, string shqh, decimal fjjg, decimal sjfjjg, string yh, decimal yhbl, string bz, string czy, DateTime czsj,
string cznr, string zyzt, string add_edit_delete, string xxzs, string fjbm, decimal jcje)
{
string s = common_file.common_app.get_failure;
BLL.Qskyd_fjrb B_temp = new Hotel_app.BLL.Qskyd_fjrb();
Model.Qskyd_fjrb M_Qskyd_fjrb = new Hotel_app.Model.Qskyd_fjrb();
Ffjzt.Flfsz_add_edit Flfsz_add_edit_new = new Hotel_app.Server.Ffjzt.Flfsz_add_edit();
BLL.Common B_Common = new Hotel_app.BLL.Common();
DataSet ds = new DataSet();
int id_temp = 0; int id_temp2 = 0;
int j_temp = 1;
string lsbh_News = "";
string ddbh_News = "";
string lfbh_News = ""; int i_1 = 0;
string old_fjbh = "";
BLL.Flfsz B_flfsz = new Hotel_app.BLL.Flfsz();
Model.Flfsz M_flfsz = new Hotel_app.Model.Flfsz();
//if (sktt == common_file.common_sktt.sktt_sk || sktt == common_file.common_sktt.sktt_cz)
{
#region 预订新增房间类型
//1.新增有房号的主单
//2.修改新增主单里的房类信息把fjbh加进去并把lzfs设为1.
//3.设置联房，要先去查看原来的临时编号有没有存在联房，有就不再重新生成联房编号，直接修改。
//4.修改fjrb表，把没有房号的LZFS扣除1同时加到联房里，再修改现有主单里的房类信息
if (add_edit_delete == common_file.common_app.get_add)
{
if (yddj == common_file.common_yddj.yddj_yd)
{
if (lzfs > 1 && fjbh != "")
{
//新增客人主单
ds = B_Qskyd_mainrecord.GetList("lsbh='" + lsbh + "'");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModel(Convert.ToInt32(ds.Tables[0].Rows[0]["id"].ToString()));
lsbh_News = common_file.common_ddbh.ddbh("skyd", "skyddate", "skydcounter", 6);
ddbh_News = common_file.common_ddbh.ddbh("skyd", "skyddate", "skydcounter", 6);
s = common_file_server.Common_pl_Qskyd_mainRecord_add.Pladd(yydh, qymc, lsbh, lsbh_News, ddbh_News, czy, czsj.ToString(), "", "");//根据lsbh读起主单信息，添加一条有房号的记录。
if (s == common_file.common_app.get_suc)
{
s = common_file.common_app.get_failure;
//修改新增主单里的房类信息把fjbh加进去并把lzfs设为1.
ds = B_temp.GetList("lsbh='" + lsbh_News + "'");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Model.Qskyd_fjrb M_temp = B_temp.GetModel(Convert.ToInt32(ds.Tables[0].Rows[0]["id"]));
M_temp.fjbh = fjbh;
M_temp.fjrb = fjrb;
M_temp.fjjg = fjjg;
M_temp.sjfjjg = sjfjjg;
M_temp.yh = yh;
M_temp.yhbl = yhbl;
M_temp.shqh = shqh;
M_temp.bz = bz;
M_temp.lzfs = 1;
M_temp.fjbm = fjbm;
M_temp.jcje = jcje;
if (B_temp.Update(M_temp))
{
Qskyd_fjrb_add_edit_delete_new.add_fjbh_yd_fjzt(M_temp.lsbh, M_temp.fjbh, M_temp.sktt, czsj, czy, xxzs);
#region 当前主单以前没有联房过()
if (B_flfsz.GetModelList("lsbh='" + lsbh + "'").Count == 0)
{
//生成新的联房编号
lfbh_News = common_file.common_ddbh.ddbh("lf", "lfdate", "lfcounter", 6);
s = Flfsz_add_edit_new.Flfsz_add_edit_delete("", yydh, qymc, lfbh_News, lsbh_News, fjbh, krxm, sktt, yddj, czy, czsj.ToString(), common_file.common_app.shlz, common_file.common_app.get_add, xxzs);
if (s == common_file.common_app.get_suc)
{
//主单增加到联房，增加新的一条无房号的记录到fjrb表
lzfs = lzfs - 1;
if (Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(id.ToString(), yydh, qymc, lsbh, krxm, sktt, yddj, fjrb, "", ddsj, lksj, lzfs, shqh, fjjg, sjfjjg, yh, yhbl, bz, czy, DateTime.Now, cznr, zyzt, common_file.common_app.get_add, xxzs, fjbm, jcje) == common_file.common_app.get_suc)
{
//新增临时编号到联房里面
string fjbh_0 = "";
DataSet DS_temp = B_Common.GetList("select fjbh from Qskyd_fjrb", "lsbh='" + lsbh + "' and fjbh<>''");
if (DS_temp != null && DS_temp.Tables[0].Rows.Count > 0)
{
fjbh_0 = DS_temp.Tables[0].Rows[0]["fjbh"].ToString();
}
s = Flfsz_add_edit_new.Flfsz_add_edit_delete("", yydh, qymc, lfbh_News, lsbh, fjbh_0, krxm, sktt, yddj, czy, czsj.ToString(), common_file.common_app.shlz, common_file.common_app.get_add, xxzs);
//M_flfsz.yydh = yydh;
//M_flfsz.qymc = qymc;
//M_flfsz.lsbh = lsbh;
//M_flfsz.fjbh = "";
//M_flfsz.lfbh = lfbh_News;
//M_flfsz.krxm = krxm;
//M_flfsz.sktt = sktt;
//M_flfsz.yddj = yddj;
//M_flfsz.czy = czy;
//M_flfsz.czsj = czsj;
//if (B_flfsz.Add(M_flfsz) > 0)
//{
// s = common_file.common_app.get_suc;
//}
//else
//{
// return s;
//}
}
else
{
return(s);
}
}
else
{
return(s);
}
}
#endregion
#region 当前主单有联房过
else
{
//直接把新增的一条加到联房表，fjbh不存在的一条不管
lfbh_News = B_flfsz.GetModelList("lsbh='" + lsbh + "'")[0].lfbh;
s = Flfsz_add_edit_new.Flfsz_add_edit_delete("", yydh, qymc, lfbh_News, lsbh_News, fjbh, krxm, sktt, yddj, czy, czsj.ToString(), common_file.common_app.shlz, common_file.common_app.get_add, xxzs);
if (s == common_file.common_app.get_suc)
{
//主单增加到联房，增加新的一条无房号的记录到fjrb表
lzfs = lzfs - 1;
if (Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(id.ToString(), yydh, qymc, lsbh, krxm, sktt, yddj, fjrb, "", ddsj, lksj, lzfs, shqh, fjjg, sjfjjg, yh, yhbl, bz, czy, DateTime.Now, cznr, zyzt, common_file.common_app.get_add, xxzs, fjbm, jcje) == common_file.common_app.get_suc)
{
s = common_file.common_app.get_suc;
}
else
{
return(s);
}
}
else
{
return(s);
}
}
#endregion
}
else
{
return(s);
}
}
}
else
{
return(s);
}
}
}//if (lzfs > 1 && fjbh != "")
else
{
j_temp = 1;
//如果原来已经有等一条已经排房的记录，新的（增加修改记录）房型一样且如果仍为1时的情况
if (B_temp.GetModelList("lsbh='" + lsbh + "' and fjrb='" + fjrb + "' and fjbh<>'' ").Count > 0)
{
j_temp = 3;
}
if (j_temp != 3)
{
//如果原来已经有等一条已经排房的记录，新的（增加修改记录）房型如果不一样且如果仍为1时的情况
#region 判断当前的临时编号对应的lzfs是否为1，并在fjrb表有多条记录的时候
if (B_temp.GetModelList("lsbh='" + lsbh + "' and fjrb<>'" + fjrb + "' and fjrb<>'' ").Count > 0)
{
j_temp = 3;
}
#endregion
#region 只有一条记录的时候,直接修改fjrb,并加到联房表
else
{
if (Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(id.ToString(), yydh, qymc, lsbh, krxm, sktt, yddj, fjrb, fjbh, ddsj, lksj, lzfs, shqh, fjjg, sjfjjg, yh, yhbl, bz, czy, czsj, cznr, zyzt, add_edit_delete, xxzs, fjbm, jcje) == common_file.common_app.get_suc)
{
s = common_file.common_app.get_suc;
}
else
{
return(s);
}
}
}
if (j_temp == 3)//输入房数为1时的判断，且原来有记录的情况
{
if (fjbh != "")
{
//找到当前房间类型为1，而且还没有排房号的那条记录
//M_Qskyd_fjrb = B_temp.GetModelList("lsbh='" + lsbh + "' and fjrb='" + fjrb + "' and lzfs=1 and fjbh=''")[0];
//得到主单的信息：
lsbh_News = common_file.common_ddbh.ddbh("skyd", "skyddate", "skydcounter", 6);
ddbh_News = common_file.common_ddbh.ddbh("skyd", "skyddate", "skydcounter", 6);
//通过当前的主单信息新增一条新的记录
if (common_file_server.Common_pl_Qskyd_mainRecord_add.Pladd(yydh, qymc, lsbh, lsbh_News, ddbh_News, czy, czsj.ToString(), "", "") == common_file.common_app.get_suc)
{
#region //修改fjrb表里当前生成这条记录的房间信息
id_temp2 = GetModel("", lsbh_News).id;
if (Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(id_temp2.ToString(), yydh, qymc, lsbh_News, krxm, sktt, yddj, fjrb, fjbh, ddsj, lksj, lzfs, shqh, fjjg, sjfjjg, yh, yhbl, bz, czy, czsj, "自动新增", zyzt, common_file.common_app.get_edit, xxzs, fjbm, jcje) == common_file.common_app.get_suc)
{
if (lf_GetResult(lsbh, qymc, lsbh_News, yydh, fjbh, krxm, sktt, yddj, czy, czsj, xxzs))
{
s = common_file.common_app.get_suc;
}
}
#endregion
}
}
else
{
if (Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(id.ToString(), yydh, qymc, lsbh, krxm, sktt, yddj, fjrb, fjbh, ddsj, lksj, lzfs, shqh, fjjg, sjfjjg, yh, yhbl, bz, czy, czsj, cznr, zyzt, add_edit_delete, xxzs, fjbm, jcje) == common_file.common_app.get_suc)
{
s = common_file.common_app.get_suc;
}
else
{
return(s);
}
}
}
#endregion
}
}
}
#endregion
#region 预订修改房间类型
else
if (add_edit_delete == common_file.common_app.get_edit)
{
if (yddj == common_file.common_yddj.yddj_yd)
{
#region 新增主单lzfs > 1 && fjbh != ""
if (lzfs > 1 && fjbh != "")
{
//新增主单
//修改新增主单里的房类信息
//设置联房，要先去查看原来的临时编号有没有存在联房，有就不再重新生成联房编号
//把没有房号的LZFS扣除1同里加到联房里，再修改现有主单里的房类信息
ds = B_Qskyd_mainrecord.GetList("lsbh='" + lsbh + "'");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModel(Convert.ToInt32(ds.Tables[0].Rows[0]["id"].ToString()));
lsbh_News = common_file.common_ddbh.ddbh("skyd", "skyddate", "skydcounter", 6);
ddbh_News = common_file.common_ddbh.ddbh("skyd", "skyddate", "skydcounter", 6);
s = common_file_server.Common_pl_Qskyd_mainRecord_add.Pladd(yydh, qymc, lsbh, lsbh_News, ddbh_News, czy, czsj.ToString(), "", "");
if (s == common_file.common_app.get_suc)
{
s = common_file.common_app.get_failure;
//修改新增主单里的房类信息把fjbh加进去
ds = B_temp.GetList("lsbh='" + lsbh_News + "'");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
//修改新增主单的Qskyd_fjrb表的fjbh并加到联房
Model.Qskyd_fjrb M_temp = B_temp.GetModel(Convert.ToInt32(ds.Tables[0].Rows[0]["id"]));
M_temp.fjbh = fjbh;
M_temp.fjrb = fjrb;
M_temp.fjjg = fjjg;
M_temp.sjfjjg = sjfjjg;
M_temp.yh = yh;
M_temp.yhbl = yhbl;
M_temp.shqh = shqh;
M_temp.bz = bz;
M_temp.lzfs = 1;
M_temp.fjbm = fjbm;
M_temp.jcje = jcje;
//M_temp.id=Convert.ToInt32(ds.Tables[0].Rows[0]["id"]);
#region //以前没有联房的处理节
if (B_flfsz.GetModelList("lsbh='" + lsbh + "'").Count == 0) //以前没有联房
{
lfbh_News = common_file.common_ddbh.ddbh("lf", "lfdate", "lfcounter", 6); //
s = Flfsz_add_edit_new.Flfsz_add_edit_delete("", yydh, qymc, lfbh_News, lsbh_News, fjbh, krxm, sktt, yddj, czy, czsj.ToString(), common_file.common_app.shlz, common_file.common_app.get_add, xxzs);
//增加到联房,修改新增的主单fjrb表里的fjbh并把lzfs-1；并增加到联房)
if (B_temp.Update(M_temp) && s == common_file.common_app.get_suc)
{
Qskyd_fjrb_add_edit_delete_new.add_fjbh_yd_fjzt(M_temp.lsbh, M_temp.fjbh, M_temp.sktt, czsj, czy, xxzs);
ds = B_temp.GetList("lsbh='" + lsbh + "' and fjrb='' and id='" + id.ToString() + "'");
i_1 = 5;
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
i_1 = 6;
}
else
{
i_1 = 5;
ds = B_temp.GetList("lsbh='" + lsbh + "' and fjrb<>'' and id='" + id.ToString() + "'");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["fjrb"].ToString() == fjrb)
{
i_1 = 5;
}
else
{
i_1 = 7;
}
}
}
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
id_temp = Convert.ToInt32(ds.Tables[0].Rows[0]["id"]);
M_Qskyd_fjrb = B_temp.GetModel(id_temp);
}
if (i_1 == 5 || i_1 == 6 || i_1 == 7)
{
M_Qskyd_fjrb.lzfs = lzfs - 1;
M_Qskyd_fjrb.czy = czy;
M_Qskyd_fjrb.czsj = DateTime.Now;
M_Qskyd_fjrb.cznr = common_file.common_app.get_edit;
if (i_1 == 6 || i_1 == 7)
{
M_Qskyd_fjrb.fjrb = fjrb;
if (i_1 == 6)
{
M_Qskyd_fjrb.shqh = shqh;
M_Qskyd_fjrb.fjjg = fjjg; //decimal.Parse(common_file.common_get_fjjg.get_fjjg(fjrb));
M_Qskyd_fjrb.sjfjjg = sjfjjg;
M_Qskyd_fjrb.yh = yh;
M_Qskyd_fjrb.yhbl = yhbl;
M_Qskyd_fjrb.bz = bz;
M_Qskyd_fjrb.fjbm = fjbm;
M_Qskyd_fjrb.bz = bz;
}
}
}
if (B_temp.Update(M_Qskyd_fjrb)) //无房间编号的房类主单也加到联房表里面
{
s = Flfsz_add_edit_new.Flfsz_add_edit_delete("", yydh, qymc, lfbh_News, lsbh, "", krxm, sktt, yddj, czy, czsj.ToString(), common_file.common_app.shlz, common_file.common_app.get_add, xxzs);
}
else
{
return(s);
}
}
else
{
return(s);
}
}
#endregion
#region 以前有联房
else
{
//读出联房信息
lfbh_News = B_flfsz.GetModelList("lsbh='" + lsbh + "'")[0].lfbh;
//将新增主单加到联房表里面 同时 修改新增的一条fjrb表里面的信息
M_Qskyd_fjrb = B_temp.GetModelList("lsbh='" + lsbh_News + "'")[0];
//相同信息
M_Qskyd_fjrb.fjrb = fjrb;
M_Qskyd_fjrb.fjbh = fjbh;
M_Qskyd_fjrb.cznr = common_file.common_app.get_edit;
M_Qskyd_fjrb.czsj = DateTime.Now;
M_Qskyd_fjrb.lzfs = 1;
M_Qskyd_fjrb.fjjg = fjjg;
M_Qskyd_fjrb.yh = yh;
M_Qskyd_fjrb.yhbl = yhbl;
M_Qskyd_fjrb.shqh = shqh;
M_Qskyd_fjrb.bz = bz;
M_Qskyd_fjrb.fjbm = fjbm;
M_Qskyd_fjrb.jcje = jcje;
s = Flfsz_add_edit_new.Flfsz_add_edit_delete("", yydh, qymc, lfbh_News, lsbh_News, fjbh, krxm, sktt, yddj, czy, czsj.ToString(), common_file.common_app.shlz, common_file.common_app.get_add, xxzs);
if (s == common_file.common_app.get_suc && B_temp.Update(M_Qskyd_fjrb))
{
Qskyd_fjrb_add_edit_delete_new.add_fjbh_yd_fjzt(M_Qskyd_fjrb.lsbh, M_Qskyd_fjrb.fjbh, M_Qskyd_fjrb.sktt, czsj, czy, xxzs);
//修改原来的fjrb表的信息
//M_Qskyd_fjrb = B_temp.GetModelList("lsbh='" + lsbh + "' and fjrb='" + fjrb + "'")[0];
M_Qskyd_fjrb = B_temp.GetModel(int.Parse(id));
M_Qskyd_fjrb.id = int.Parse(id);
M_Qskyd_fjrb.lzfs = lzfs - 1;
M_Qskyd_fjrb.fjrb = fjrb;
M_Qskyd_fjrb.fjjg = fjjg;
M_Qskyd_fjrb.sjfjjg = sjfjjg;
M_Qskyd_fjrb.yh = yh;
M_Qskyd_fjrb.yhbl = yhbl;
M_Qskyd_fjrb.shqh = shqh;
M_Qskyd_fjrb.bz = bz;
M_Qskyd_fjrb.fjbm = fjbm;
M_Qskyd_fjrb.jcje = jcje;
if (B_temp.Update(M_Qskyd_fjrb))
{
s = common_file.common_app.get_suc;
}
else
{
return(s);
}
}
else
{
return(s);
}
}
#endregion
}
}
else
{
return(s);
}
}
}
#endregion
else
{
#region 判断当前的临时编号对应的lzfs是否为1，并在fjrb表有多条记录的时候
DataSet DS_temp_1;
DS_temp_1 = B_temp.GetList("id='" + id + "'");
if (DS_temp_1 != null && DS_temp_1.Tables[0].Rows.Count > 0)
{
old_fjbh = DS_temp_1.Tables[0].Rows[0]["fjbh"].ToString();
}
j_temp = 1;
//如果原来已经有等一条已经排房的记录，新的（增加修改记录）房型一样且如果仍为1时的情况
if (B_temp.GetModelList("lsbh='" + lsbh + "' and fjrb='" + fjrb + "' and fjbh<>'' ").Count > 0)
{
j_temp = 3;
}
if (j_temp != 3)
{
if (B_temp.GetModelList("lsbh='" + lsbh + "' and fjrb<>'" + fjrb + "' and fjrb<>'' ").Count > 0)
{
j_temp = 3;
if (old_fjbh == "" && fjbh != "")
{
if (B_temp.GetModelList("lsbh='" + lsbh + "' and fjrb<>'" + fjrb + "' and fjrb<>'' and fjbh='' ").Count > 0)
{
j_temp = 1;
}
}
}
#endregion
#region 只有一条记录的时候,直接修改fjrb,并加到联房表
else
{
if (Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(id.ToString(), yydh, qymc, lsbh, krxm, sktt, yddj, fjrb, fjbh, ddsj, lksj, lzfs, shqh, fjjg, sjfjjg, yh, yhbl, bz, czy, czsj, cznr, zyzt, add_edit_delete, xxzs, fjbm, jcje) == common_file.common_app.get_suc)
{
s = common_file.common_app.get_suc;
}
else
{
return(s);
}
}
#endregion
}
if (old_fjbh != "")
{
j_temp = 1;
}
if (j_temp == 3)
{
if (fjbh != "")
{
//找到当前房间类型为1，而且还没有排房号的那条记录
//M_Qskyd_fjrb = B_temp.GetModelList("lsbh='" + lsbh + "' and fjrb='" + fjrb + "' and lzfs=1 and fjbh=''")[0];
//得到主单的信息：
lsbh_News = common_file.common_ddbh.ddbh("skyd", "skyddate", "skydcounter", 6);
ddbh_News = common_file.common_ddbh.ddbh("skyd", "skyddate", "skydcounter", 6);
//通过当前的主单信息新增一条新的记录
if (common_file_server.Common_pl_Qskyd_mainRecord_add.Pladd(yydh, qymc, lsbh, lsbh_News, ddbh_News, czy, czsj.ToString(), "", "") == common_file.common_app.get_suc)
{
#region //修改fjrb表里当前生成这条记录的房间信息
id_temp2 = GetModel("", lsbh_News).id;
if (Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(id_temp2.ToString(), yydh, qymc, lsbh_News, krxm, sktt, yddj, fjrb, fjbh, ddsj, lksj, lzfs, shqh, fjjg, sjfjjg, yh, yhbl, bz, czy, czsj, "自动新增", zyzt, common_file.common_app.get_edit, xxzs, fjbm, jcje) == common_file.common_app.get_suc)
{
//修改成功后，把当前原来fjrb表里面对应的那条记录删除
if (GetModel(fjrb, lsbh) != null)
{
id_temp2 = int.Parse(id);
if (B_temp.Delete(id_temp2))
{
//删除对应记录成功后，把新生成的记录加到联房里
#region 判断当前的lsbh在不在在联房表里面，然后做相应处理
if (lf_GetResult(lsbh, qymc, lsbh_News, yydh, fjbh, krxm, sktt, yddj, czy, czsj, xxzs))
{
s = common_file.common_app.get_suc;
}
#endregion
}
}
}
#endregion
}
}
else
{
if (Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(id.ToString(), yydh, qymc, lsbh, krxm, sktt, yddj, fjrb, fjbh, ddsj, lksj, lzfs, shqh, fjjg, sjfjjg, yh, yhbl, bz, czy, czsj, cznr, zyzt, add_edit_delete, xxzs, fjbm, jcje) == common_file.common_app.get_suc)
{
s = common_file.common_app.get_suc;
}
else
{
return(s);
}
}
}
else
{
if (Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(id.ToString(), yydh, qymc, lsbh, krxm, sktt, yddj, fjrb, fjbh, ddsj, lksj, lzfs, shqh, fjjg, sjfjjg, yh, yhbl, bz, czy, czsj, cznr, zyzt, add_edit_delete, xxzs, fjbm, jcje) == common_file.common_app.get_suc)
{
s = common_file.common_app.get_suc;
}
}
}
} //if (yddj == common_file.common_yddj.yddj_yd)
else
if (yddj == common_file.common_yddj.yddj_dj)
{
if (Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(id.ToString(), yydh, qymc, lsbh, krxm, sktt, yddj, fjrb, fjbh, ddsj, lksj, lzfs, shqh, fjjg, sjfjjg, yh, yhbl, bz, czy, czsj, cznr, zyzt, add_edit_delete, xxzs, fjbm, jcje) == common_file.common_app.get_suc)
{
s = common_file.common_app.get_suc;
}
else
{
return(s);
}
} //if (yddj == common_file.common_yddj.yddj_dj)
}
#endregion
#region hy类型的时候
else
if (sktt == common_file.common_sktt.sktt_tt || sktt == common_file.common_sktt.sktt_hy)
{
if (add_edit_delete == common_file.common_app.get_add)
{
if (yddj == common_file.common_yddj.yddj_yd)
{
//1.新增主单
//2.修改房类Qskyd_Fjrb表，把fjbh写进，lzfs设为1.
//3.修改没有带房号的临时编号lzfs减1
}
}
else
if (add_edit_delete == common_file.common_app.get_edit)
{
}
}
#endregion
}
ds.Dispose();
return(s);
}
//2012.5.11本地传到远程的Qskyd_fjrb_temp然后在添加到Qskyd_fjrb表
//1.如果有相同的lsbh就修改，否者添加。
//2.最后和Qskyd_fjrb_temp这张表对比，如果Qskyd_fjrb not in(lsbh)的条件就删除
//这样做是怕本的删除了远程有可能还有这条记录在
public static string Add_Qskyd_fjrb(DataSet DS_Qskyd_fjrb, string yydh)
{
// id,yydh,qymc,lsbh,krxm,sktt,yddj,fjrb,fjbh,ddsj,lksj,lzfs,shqh,fjjg,sjfjjg,yh,yhbl,bz,is_top,
//is_select,shsc,czy,czsj,cznr,sdcz,fjbm,jcje
string s = common_file.common_app.get_failure;
if (DS_Qskyd_fjrb != null && DS_Qskyd_fjrb.Tables[0].Rows.Count > 0)
{
string strsql_03 = "delete from Qskyd_fjrb where isok=1 and yydh='" + yydh + "'";
DbHelperSQL.ExecuteSql(strsql_03);
Model.Qskyd_fjrb M_Qskyd_fjrb = new Model.Qskyd_fjrb();
BLL.Qskyd_fjrb B_Qskyd_fjrb = new BLL.Qskyd_fjrb();
foreach (DataRow dr in DS_Qskyd_fjrb.Tables[0].Rows)
{
string strLsbh = dr["lsbh"].ToString();
M_Qskyd_fjrb.lsbh = dr["lsbh"].ToString();
M_Qskyd_fjrb.yydh = dr["yydh"].ToString();
M_Qskyd_fjrb.qymc = dr["qymc"].ToString();
M_Qskyd_fjrb.krxm = dr["krxm"].ToString();
M_Qskyd_fjrb.sktt = dr["sktt"].ToString();
M_Qskyd_fjrb.yddj = dr["yddj"].ToString();
M_Qskyd_fjrb.fjrb = dr["fjrb"].ToString();
M_Qskyd_fjrb.fjbh = dr["fjbh"].ToString();
M_Qskyd_fjrb.ddsj = Convert.ToDateTime(dr["ddsj"].ToString());
M_Qskyd_fjrb.lksj = Convert.ToDateTime(dr["lksj"].ToString());
M_Qskyd_fjrb.lzfs = Convert.ToDecimal(dr["lzfs"].ToString());
M_Qskyd_fjrb.shqh = dr["shqh"].ToString();
M_Qskyd_fjrb.fjjg = Convert.ToDecimal(dr["fjjg"].ToString());
M_Qskyd_fjrb.sjfjjg = Convert.ToDecimal(dr["sjfjjg"].ToString());
M_Qskyd_fjrb.yh = "";
M_Qskyd_fjrb.yhbl = 0;
M_Qskyd_fjrb.bz = "";
M_Qskyd_fjrb.is_top = false;
M_Qskyd_fjrb.is_select = false;
M_Qskyd_fjrb.shsc = true;
M_Qskyd_fjrb.czy = dr["czy"].ToString();
M_Qskyd_fjrb.czsj = Convert.ToDateTime(dr["czsj"].ToString());
M_Qskyd_fjrb.cznr = dr["cznr"].ToString();
M_Qskyd_fjrb.isok = true;
//如果有相同lsbh就修改，，然后添加。
DataSet ds = B_Qskyd_fjrb.GetList("lsbh='" + strLsbh + "' and fjrb='" + dr["fjrb"].ToString() + "' and fjbh='" + dr["fjbh"].ToString() + "' and lzfs='" + dr["lzfs"].ToString() + "' and ddsj='" + dr["ddsj"] + "' and lksj='" + dr["lksj"] + "' and isok=0 ");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
int fid = Convert.ToInt32(ds.Tables[0].Rows[0]["id"].ToString());
string strsql_01 = "update Qskyd_fjrb set isok=1 where id=" + fid + "";
if (DbHelperSQL.ExecuteSql(strsql_01) > 0)
{
M_Qskyd_fjrb.id = fid;
B_Qskyd_fjrb.Update(M_Qskyd_fjrb);
s = common_file.common_app.get_suc;
}
}
else
{
//添加到Qskyd_fjrb表里
if (B_Qskyd_fjrb.Add(M_Qskyd_fjrb) > 0)
{
s = common_file.common_app.get_suc;
}
}
}
string strsql = "delete from Qskyd_fjrb where isok=0 and yydh='" + yydh + "'";
DbHelperSQL.ExecuteSql(strsql);
string strsql_02 = "update Qskyd_fjrb set isok=0 where yydh='" + yydh + "'";
DbHelperSQL.ExecuteSql(strsql_02);
s = common_file.common_app.get_suc;
}
return(s);
}
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;
}
//下载网上预订的方法
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);
}
