//检查团体成员的帐务情况，返回真假，结清，返回真，没有结清返回假
public bool CheckTTcyZwStatus(string lsbh)//团体的临时编号
{
DataSet ds_temp;
string ddbh_temp = "";
M_Qttyd_mainrecord = B_Qttyd_mainrecord.GetModelList("id>=0 " + common_file.common_app.yydh_select + " and lsbh='" + lsbh + "'")[0];
ddbh_temp = M_Qttyd_mainrecord.ddbh;
ds_temp = B_common.GetList("select * from Syjcz", " lsbh in (select lsbh from Qskyd_mainrecord where ddbh='" + ddbh_temp + "')");
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
{
return(false);
}
else
{
ds_temp = B_common.GetList("select * from Szwmx", " lsbh in (select lsbh from Qskyd_mainrecord where ddbh='" + ddbh_temp + "')");
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
{
return(false);
}
else//成员帐务都结清，团体可以进行结帐
{
return(true);
}
}
}
/// <summary>
/// 用来删除主单或退房时单据的删除和修改房态及备份相应记录
/// </summary>
/// <param name="id"></param>
/// <param name="czzt"></param>两个值,一个是删除“sc”，一个是结账"jz"
/// <param name="czbz"></param>主要是两个值，一个是“取消”，一个“未到”到common_yddj里去找
/// <param name="qxyy"></param>取消原因
/// <param name="jzbh"></param>
/// <param name="czy"></param>
/// <param name="czsj"></param>
/// <param name="xxzs"></param>
/// <returns></returns>
public string delete_sz_ttyd(string id, string czzt, string czbz, string qxyy, string jzbh, string czy, string czsj, string xxzs)
{
int i_temp = 8;//用来M_Qskyd_mainrecord =NULL时判断
string s = common_file.common_app.get_failure;
BLL.Qttyd_mainrecord B_Qttyd_mainrecord = new Hotel_app.BLL.Qttyd_mainrecord();
Model.Qttyd_mainrecord M_Qttyd_mainrecord = new Hotel_app.Model.Qttyd_mainrecord();
BLL.Qttyd_mainrecord_new B_Qttyd_mainrecord_new = new Hotel_app.BLL.Qttyd_mainrecord_new();
Qyddj.Qyddj_add_edit_delete Qyddj_add_edit_delete_new = new Qyddj_add_edit_delete();
BLL.Common B_Common = new Hotel_app.BLL.Common();
if (id != "")
{
DataSet DS_temp;
M_Qttyd_mainrecord = B_Qttyd_mainrecord.GetModel(int.Parse(id));
//判断预订的记录有两条房类时删除同一个主单避免出错
if (M_Qttyd_mainrecord == null)
{
i_temp = 9;
}
else
{
s = common_file.common_app.get_suc;
DS_temp = B_Common.GetList("select * from Qskyd_mainrecord", "ddbh='" + M_Qttyd_mainrecord.ddbh + "'");
if (DS_temp != null && DS_temp.Tables[0].Rows.Count > 0)
{
s = common_file.common_app.get_failure;
for (int i_temp_0 = 0; i_temp_0 < DS_temp.Tables[0].Rows.Count; i_temp_0++)
{
s = Qyddj_add_edit_delete_new.delete_sz_xgft(DS_temp.Tables[0].Rows[i_temp_0]["id"].ToString(), czzt, czbz, qxyy, jzbh, czy, czsj, xxzs);
}
}
if (s == common_file.common_app.get_suc)
{
s = common_file.common_app.get_failure;
//清除入住记录
int strid = int.Parse(id);
//common_file.common_Qskyd_mainrecord.PlInter(int.Parse(id), "删除");
B_Qttyd_mainrecord_new.Pladd(strid, czbz, qxyy, czy, czsj, czzt, jzbh);//删除前批量添加到备份表里
if (B_Qttyd_mainrecord.Delete(strid) == true)
{
//s = common_file.common_app.get_suc;
}
}
}
if (i_temp == 9)
{
//s = common_file.common_app.get_suc;
}
}
s = common_file.common_app.get_suc;
return(s);
}
public string Qttyd_add_edit_delete_app(string id, string yydh, string qymc, string lsbh, string ddbh, string krxm, string krbh, string yddj, string sktt, string krgj, string krdz, string krly, string xyh, string xydw, string xsy, string krdh, string krsj, string kremail, string ydrxm, string ddsj, string lzts, string lksj, string qtyq, string ddrx, string ddwz, string zyzt, string czy, string cznr, string czsj, string syzd, string tsyq, string add_edit_delete, string xxzs, string ddly)
{
string s = common_file.common_app.get_failure;
Model.Qttyd_mainrecord M_Qttyd_mainrecord = new Hotel_app.Model.Qttyd_mainrecord();
BLL.Qttyd_mainrecord B_Qttyd_mainrecord = new Hotel_app.BLL.Qttyd_mainrecord();
//DataSet Ds_temp;
if (add_edit_delete == common_file.common_app.get_add)
{
M_Qttyd_mainrecord.cznr = cznr;
M_Qttyd_mainrecord.czsj = Convert.ToDateTime(czsj);
M_Qttyd_mainrecord.czy = czy;
M_Qttyd_mainrecord.ddbh = ddbh;
M_Qttyd_mainrecord.ddrx = ddrx;
M_Qttyd_mainrecord.ddsj = Convert.ToDateTime(ddsj);
M_Qttyd_mainrecord.ddwz = ddwz;
M_Qttyd_mainrecord.krbh = krbh;
M_Qttyd_mainrecord.krdh = krdh;
M_Qttyd_mainrecord.krdz = krdz;
M_Qttyd_mainrecord.krEmail = kremail;
M_Qttyd_mainrecord.krgj = krgj;
M_Qttyd_mainrecord.krly = krly;
M_Qttyd_mainrecord.krsj = krsj;
M_Qttyd_mainrecord.krxm = krxm;
M_Qttyd_mainrecord.lksj = Convert.ToDateTime(lksj);
M_Qttyd_mainrecord.lsbh = lsbh;
M_Qttyd_mainrecord.lzts = Convert.ToInt32(lzts);
M_Qttyd_mainrecord.qtyq = qtyq;
M_Qttyd_mainrecord.qymc = qymc;
M_Qttyd_mainrecord.sktt = sktt;
M_Qttyd_mainrecord.syzd = syzd;
M_Qttyd_mainrecord.tsyq = tsyq;
M_Qttyd_mainrecord.xsy = xsy;
M_Qttyd_mainrecord.xydw = xydw;
M_Qttyd_mainrecord.xyh = xyh;
M_Qttyd_mainrecord.yddj = yddj;
M_Qttyd_mainrecord.ydrxm = ydrxm;
M_Qttyd_mainrecord.yydh = yydh;
M_Qttyd_mainrecord.zyzt = zyzt;
M_Qttyd_mainrecord.ddly = ddly;
int IsAdd = B_Qttyd_mainrecord.Add(M_Qttyd_mainrecord);
if (IsAdd > 0)
{
s = common_file.common_app.get_suc;
}
}
else if (add_edit_delete == common_file.common_app.get_edit)
{
M_Qttyd_mainrecord = B_Qttyd_mainrecord.GetModel(int.Parse(id));
if (M_Qttyd_mainrecord != null)
{
DateTime ddsj_temp = M_Qttyd_mainrecord.ddsj;
DateTime lksj_temp = M_Qttyd_mainrecord.lksj;
M_Qttyd_mainrecord.id = int.Parse(id);
M_Qttyd_mainrecord.cznr = cznr;
M_Qttyd_mainrecord.czsj = Convert.ToDateTime(czsj);
M_Qttyd_mainrecord.czy = czy;
M_Qttyd_mainrecord.ddbh = ddbh;
M_Qttyd_mainrecord.ddrx = ddrx;
M_Qttyd_mainrecord.ddsj = Convert.ToDateTime(ddsj);
M_Qttyd_mainrecord.ddwz = ddwz;
M_Qttyd_mainrecord.krbh = krbh;
M_Qttyd_mainrecord.krdh = krdh;
M_Qttyd_mainrecord.krdz = krdz;
M_Qttyd_mainrecord.krEmail = kremail;
M_Qttyd_mainrecord.krgj = krgj;
M_Qttyd_mainrecord.krsj = krsj;
M_Qttyd_mainrecord.krxm = krxm;
M_Qttyd_mainrecord.lksj = Convert.ToDateTime(lksj);
M_Qttyd_mainrecord.lsbh = lsbh;
M_Qttyd_mainrecord.lzts = Convert.ToInt32(lzts);
M_Qttyd_mainrecord.qtyq = qtyq;
M_Qttyd_mainrecord.qymc = qymc;
M_Qttyd_mainrecord.sktt = sktt;
M_Qttyd_mainrecord.syzd = syzd;
M_Qttyd_mainrecord.tsyq = tsyq;
M_Qttyd_mainrecord.yddj = yddj;
M_Qttyd_mainrecord.ydrxm = ydrxm;
M_Qttyd_mainrecord.yydh = yydh;
M_Qttyd_mainrecord.zyzt = zyzt;
M_Qttyd_mainrecord.ddly = ddly;
if (M_Qttyd_mainrecord.ddyy != common_file_server.common_app.ydzx_flage)
{
M_Qttyd_mainrecord.xsy = xsy;
M_Qttyd_mainrecord.xydw = xydw;
M_Qttyd_mainrecord.krly = krly;
M_Qttyd_mainrecord.xyh = xyh;
}
//if (M_Qttyd_mainrecord.ddyy != common_file.common_app.ydzx_flage&&M_Qttyd_mainrecord.krly != common_file.common_app.krly_xydw_flage)
//{
// M_Qttyd_mainrecord.xsy = xsy;
// }
if (ddsj_temp != M_Qttyd_mainrecord.ddsj || lksj_temp != M_Qttyd_mainrecord.lksj)
{
DataSet ds_temp_0;
BLL.Qskyd_mainrecord B_Qskyd_mainrecord = new Hotel_app.BLL.Qskyd_mainrecord();
ds_temp_0 = B_Qskyd_mainrecord.GetList("ddbh='" + M_Qttyd_mainrecord.ddbh + "'");
if (ds_temp_0 != null && ds_temp_0.Tables[0].Rows.Count > 0)
{
Model.Qskyd_mainrecord M_Qskyd_mainrecord = new Hotel_app.Model.Qskyd_mainrecord();
for (int i_temp_0 = 0; i_temp_0 < ds_temp_0.Tables[0].Rows.Count; i_temp_0++)
{
M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModel(int.Parse(ds_temp_0.Tables[0].Rows[i_temp_0]["id"].ToString()));
if (M_Qskyd_mainrecord != null)
{
Qyddj.Qyddj_add_edit_delete Qyddj_add_edit_delete_new = new Qyddj_add_edit_delete();
Qyddj_add_edit_delete_new.Qskdj_add_edit_delete(M_Qskyd_mainrecord.id.ToString(), M_Qskyd_mainrecord.yydh,
M_Qskyd_mainrecord.qymc, M_Qskyd_mainrecord.lsbh,
M_Qskyd_mainrecord.ddbh, M_Qskyd_mainrecord.hykh,
M_Qskyd_mainrecord.hyrx, M_Qskyd_mainrecord.krxm, M_Qskyd_mainrecord.tlkr, M_Qskyd_mainrecord.krgj,
M_Qskyd_mainrecord.krmz, M_Qskyd_mainrecord.yxzj, M_Qskyd_mainrecord.zjhm, M_Qskyd_mainrecord.krxb,
M_Qskyd_mainrecord.krsr.ToString(), M_Qskyd_mainrecord.krdh, M_Qskyd_mainrecord.krsj, M_Qskyd_mainrecord.krEmail,
M_Qskyd_mainrecord.krdz, M_Qskyd_mainrecord.krjg, M_Qskyd_mainrecord.krdw, M_Qskyd_mainrecord.krzy,
M_Qskyd_mainrecord.cxmd, M_Qskyd_mainrecord.qzrx, M_Qskyd_mainrecord.qzhm, M_Qskyd_mainrecord.zjyxq.ToString(),
M_Qskyd_mainrecord.tlyxq.ToString(), M_Qskyd_mainrecord.tjrq.ToString(), M_Qskyd_mainrecord.lzka, M_Qskyd_mainrecord.krly,
M_Qttyd_mainrecord.xyh, M_Qttyd_mainrecord.xydw, M_Qttyd_mainrecord.xsy, M_Qttyd_mainrecord.ddrx,
M_Qttyd_mainrecord.ddwz, M_Qttyd_mainrecord.zyzt, M_Qskyd_mainrecord.krrx, M_Qskyd_mainrecord.kr_children.ToString(),
M_Qttyd_mainrecord.ddsj.ToString(), M_Qttyd_mainrecord.lzts.ToString(), M_Qttyd_mainrecord.lksj.ToString(), M_Qskyd_mainrecord.qtyq, czy,
czsj, cznr, M_Qttyd_mainrecord.sktt, M_Qttyd_mainrecord.yddj,
M_Qskyd_mainrecord.main_sec, M_Qskyd_mainrecord.yddj,
M_Qttyd_mainrecord.syzd, M_Qskyd_mainrecord.vip_type, M_Qskyd_mainrecord.tsyq, add_edit_delete, xxzs, M_Qttyd_mainrecord.ddly, M_Qskyd_mainrecord.hykh_bz);
}
}
}
ds_temp_0.Dispose();
}
if (B_Qttyd_mainrecord.Update(M_Qttyd_mainrecord))
{
s = common_file.common_app.get_suc;
}
}
}
else if (add_edit_delete == common_file.common_app.get_delete)
{
if (id != "")
{
s = delete_sz_ttyd(id, "sc", cznr, qtyq, "", czy, czsj, xxzs);
}
}
return(s);
}
//结帐,记帐,挂帐处理过程
public string GetJzResult(string lsbh, string jzbh, string czzt, string sk_tt, string czy, string czsj, string hykh, string xfje, string phoneNo, string yydh)
{
string s = common_app.get_failure;
//记帐，挂帐，结帐的处理节
if (czzt == common_file.common_jzzt.czzt_sz)//算帐
{
strSql = new StringBuilder();
strSql.Append("delete from Syjcz where id>0 " + common_app.yydh_select + " and lsbh='" + lsbh + "'");
B_common.ExecuteSql(strSql.ToString());
strSql = new StringBuilder();
strSql.Append("delete from Szwmx where id>0 " + common_file.common_app.yydh_select + " and lsbh='" + lsbh + "'");
B_common.ExecuteSql(strSql.ToString());
}
//更新Ssyxfmx里的Jzbh
B_common.ExecuteSql("update Ssyxfmx set jzbh='" + jzbh + "' where lsbh='" + lsbh + "'");
if (czzt == common_jzzt.czzt_gz || czzt == common_jzzt.czzt_jz || czzt == common_file.common_jzzt.czzt_sz)
{
//清除Szw_temp
strSql = new StringBuilder();
strSql.Append("delete from Szw_temp where id>0 " + common_app.yydh_select + " and lsbh='" + lsbh + "'");
if (B_common.ExecuteSql(strSql.ToString()) >= 0) //清除Szw_temp里面的数据了
{
//调用修改房态的方法(第五步)
if (sk_tt == "sk")
{
M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModelList("id>0 " + common_app.yydh_select + " and lsbh='" + lsbh + "'")[0];
id = M_Qskyd_mainrecord.id.ToString();
//删除主单记录（这里有包含主单记录删除时的备份）
if (Qyddj_add_edit_delete_new.delete_sz_xgft(id, "jz", common_file.common_jzzt.czzt_sz, "", jzbh, czy, czsj, xxzs) == common_app.get_suc)
{
s = common_app.get_suc;
}
}
else//是团体
{
M_Qttyd_mainrecord = B_Qttyd_mainrecord.GetModelList("ID>0 " + common_app.yydh_select + " AND lsbh='" + lsbh + "'")[0];
string tt_id = M_Qttyd_mainrecord.id.ToString();
//要成批更新团体所有成员的房态，并删除成员主单
string ddbh_temp = M_Qttyd_mainrecord.ddbh;
if (Qttyd_add_edit_delete_new.delete_sz_ttyd(tt_id, "jz", common_file.common_jzzt.czzt_sz, "", jzbh, czy, czsj, xxzs) == common_file.common_app.get_suc)
{
s = common_file.common_app.get_suc;
}
}
//结帐成功后,更新会员的积分(挂-结，记-结，部分结，结帐都要加积分
//会员卡号,当前记录的lsbh，
if ((czzt == common_jzzt.czzt_sz) || (czzt == common_jzzt.czzt_jz) || (czzt == common_jzzt.czzt_gz) || (czzt == common_jzzt.czzt_bfsz))
{
string zjf = "0"; bool shsj = false; string hyrx_now = "";//银卡
string dfjf = "0";
string lsbh_df = common_file.common_ddbh.ddbh("df", "lsbhdfdate", "lsbhdfcounter", 6);
string qymc = "";
if (!yydh.Equals(""))
{
DataSet ds000 = B_common.GetList(" select * from Xqyxx ", " id>=0 and yydh='" + yydh + "' ");
if (ds000 != null && ds000.Tables[0].Rows.Count > 0)
{
qymc = ds000.Tables[0].Rows[0]["qymc"].ToString();
}
}
IncHYScore(jzbh, lsbh, sk_tt, hykh, xfje, ref zjf, ref shsj);
//发送会员消费短信
Hhygl.Hhygl_verifyCode Hhygl_verifyCode_new = new Hotel_app.Server.Hhygl.Hhygl_verifyCode();
Hhygl_verifyCode_new.Hhygl_SendMsm(phoneNo, zjf, yydh, qymc, common_hyAction.hy_Action_hytf, czsj, "", "", "", hykh, xfje, xxzs);
BLL.Hhygl B_Hhygl_new = new Hotel_app.BLL.Hhygl();
DataSet ds111 = B_Hhygl_new.GetList(" hykh_bz='" + hykh + "' and id>=0 and hykh_bz!='' ");
if (ds111 != null && ds111.Tables[0].Rows.Count > 0)
{
hyrx_now = ds111.Tables[0].Rows[0]["hykh_bz"].ToString();
}
//升级需要的积分数
BLL.Hhyjb B_Hhyjb_new = new Hotel_app.BLL.Hhyjb();
DataSet ds222 = B_Hhyjb_new.GetList(" hyrx='" + common_app.hykh_rx + "' and id>=0 and qymc='" + qymc + "' ");
if (ds222 != null && ds222.Tables[0].Rows.Count > 0)
{
dfjf = ds222.Tables[0].Rows[0]["hykh_bz"].ToString();
}
if (!hyrx_now.Equals("") && hyrx_now.Equals(common_app.hykh_rx))
{
//发送短信(判断当前的会员类型),是银卡才自动升级
if (shsj)//自动发送升级短信
{
Hhygl_verifyCode_new.Hhygl_SendMsm(phoneNo, zjf, yydh, qymc, common_hyAction.hy_Action_hytf, czsj, "", "", "", hykh, xfje, xxzs);
//调用升级会员的方法，扣除升级积分
Hhygl.Hhyjf_df Hhyjf_dr_new = new Hotel_app.Server.Hhygl.Hhyjf_df();
Hhyjf_dr_new.Hhyjfdf_add_edit("", yydh, qymc, "", hykh, "", dfjf, "升级金卡", "1", lsbh_df, hykh, common_app.chinese_add, xxzs);
}
}
}
}
}
return(s);
}
//平帐时用到的方法
public string Sjzmx_pz(string id, string yydh, string qymc, string id_app, string jzbh, string lsbh, string krxm, string fjrb, string fjbh, string sktt,
string xfrq, string xfsj, string czy, string xfdr, string xfrb, string xfxm, string xfbz, string xfzy, string xfje, string yh, string sjxfje, string xfsl,
string czy_bc, string czzt, string czsj, string syzd, string add_edit_delete, string xxzs, string fkfs)
{
string s = common_file.common_app.get_failure;
string xyh_temp = "";
string jzzt = "";
BLL.Sjzmx B_Sjzmx = new Hotel_app.BLL.Sjzmx();
Model.Sjzmx M_Sjzmx = new Hotel_app.Model.Sjzmx();
if (xxzs == common_file.common_app.xxzs_xxvalue)
{
}
if (xxzs == common_file.common_app.xxzs_zsvalue)
{
}
if (add_edit_delete == common_file.common_app.get_add)
{
//id,yydh,qymc,id_app,jzbh,,lsbh,krxm,fjrb,fjbh,sktt,
//xfrq,xfsj,czy,xfdr,xfrb,xfxm,xfbz,xfzy
//xfje,yh,sjxfje,xfsl,czy_bc,czzt,czsj,syzd,fkfs,add,xxzs,fkfs
M_Sjzmx.yydh = yydh;
M_Sjzmx.qymc = qymc;
M_Sjzmx.id_app = id_app;
M_Sjzmx.jzbh = jzbh;
M_Sjzmx.lsbh = lsbh;
M_Sjzmx.krxm = krxm;
M_Sjzmx.fjrb = fjrb;
M_Sjzmx.fjbh = fjbh;
M_Sjzmx.sktt = sktt;
M_Sjzmx.xfrq = Convert.ToDateTime(xfrq);
M_Sjzmx.xfsj = Convert.ToDateTime(xfsj);
M_Sjzmx.czy = czy;
M_Sjzmx.xfdr = xfdr;
M_Sjzmx.xfrb = xfrb;
M_Sjzmx.xfxm = xfxm;
M_Sjzmx.xfbz = xfbz;
M_Sjzmx.xfzy = xfzy;
M_Sjzmx.xfje = Convert.ToDecimal(xfje);
M_Sjzmx.yh = yh;
M_Sjzmx.sjxfje = Convert.ToDecimal(sjxfje);
M_Sjzmx.xfsl = Convert.ToDecimal(xfsl);
M_Sjzmx.czy_bc = czy_bc;
M_Sjzmx.czzt = czzt;
M_Sjzmx.czsj = Convert.ToDateTime(czsj);
M_Sjzmx.syzd = syzd;
M_Sjzmx.fkfs = fkfs;
if (czzt == common_jzzt.czzt_sz)//结帐(结帐是直接从主单里面读）
{
if (sktt == "sk")
{
M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModelList("id>0 and yydh='" + yydh + "' and lsbh='" + lsbh + "'")[0];
xyh_temp = M_Qskyd_mainrecord.xyh;//直接读出协议号
jzzt = M_Qskyd_mainrecord.krxm;
}
if (sktt == "tt")
{
{
M_Qttyd_mainrecord = B_Qttyd_mainrecord.GetModelList("id>0 and yydh='" + yydh + "' and lsbh='" + lsbh + "'")[0];
xyh_temp = M_Qttyd_mainrecord.xyh;//直接读出协议号
jzzt = M_Qttyd_mainrecord.krxm;
}
}
}
else if (czzt == common_jzzt.czzt_gz || czzt == common_jzzt.czzt_jz)
{
object obj = DbHelperSQL.GetSingle("SELECT xyh from Sjzzd where id>0 and yydh='" + yydh + "' and jzbh='" + jzbh + "'");
if (obj != null)
{
xyh_temp = obj.ToString();
}
else
{
xyh_temp = "";
}
obj = DbHelperSQL.GetSingle("SELECT jzzt from Sjzzd where id>0 and yydh='" + yydh + "' and jzbh='" + jzbh + "'");
if (obj != null)
{
jzzt = obj.ToString();
}
else
{
jzzt = "";
}
}
M_Sjzmx.xyh = xyh_temp;
M_Sjzmx.jzzt = jzzt;
if (B_Sjzmx.Add(M_Sjzmx) > 0)
{
if (czzt == common_jzzt.czzt_gz || czzt == common_jzzt.czzt_jz)//写入付款方式设置
{
strSql = new StringBuilder();
strSql.Append("insert into Sfkfssz(yydh,qymc,jzbh,jzzt,lsbh,fjbh,krxm,fkfs,xfdr,xfrb,xfxm,xfje,sjxfje,fkrq,fksj,xfrq,xfsj,czy,czy_bc,syzd,id_app)");
strSql.Append(" select yydh,qymc,jzbh,'" + jzzt + "',lsbh,fjbh,krxm,fkfs,xfdr,xfrb,xfxm,-xfje,-sjxfje,xfrq,xfsj,xfrq,xfsj,czy,'" + czy_bc + "','" + syzd + "',id_app from sjzmx");
strSql.Append(" where yydh='" + yydh + "' and id_app='" + id_app + "'");
B_common.ExecuteSql(strSql.ToString());
}
s = common_file.common_app.get_suc;
}
}
if (add_edit_delete == common_file.common_app.get_delete)
{
if (id != "")
{
B_Sjzmx.Delete(Convert.ToInt32(id));
s = common_file.common_app.get_suc;
}
}
return(s);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hotel_app.Model.Qttyd_mainrecord model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Qttyd_mainrecord(");
strSql.Append("yydh,qymc,lsbh,ddbh,krxm,krbh,yddj,sktt,krgj,krdz,krly,xyh,xydw,xsy,krdh,krsj,krEmail,ydrxm,ddsj,ddyy,lzts,lksj,qtyq,ddrx,ddwz,zyzt,czy,cznr,czsj,is_top,is_select,ffshys,shsc,sdcz,syzd,tsyq,ddly)");
strSql.Append(" values (");
strSql.Append("@yydh,@qymc,@lsbh,@ddbh,@krxm,@krbh,@yddj,@sktt,@krgj,@krdz,@krly,@xyh,@xydw,@xsy,@krdh,@krsj,@krEmail,@ydrxm,@ddsj,@ddyy,@lzts,@lksj,@qtyq,@ddrx,@ddwz,@zyzt,@czy,@cznr,@czsj,@is_top,@is_select,@ffshys,@shsc,@sdcz,@syzd,@tsyq,@ddly)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@yydh", SqlDbType.VarChar, 50),
new SqlParameter("@qymc", SqlDbType.VarChar, 50),
new SqlParameter("@lsbh", SqlDbType.VarChar, 50),
new SqlParameter("@ddbh", SqlDbType.VarChar, 50),
new SqlParameter("@krxm", SqlDbType.VarChar, 50),
new SqlParameter("@krbh", SqlDbType.VarChar, 50),
new SqlParameter("@yddj", SqlDbType.VarChar, 50),
new SqlParameter("@sktt", SqlDbType.VarChar, 50),
new SqlParameter("@krgj", SqlDbType.VarChar, 50),
new SqlParameter("@krdz", SqlDbType.VarChar, 50),
new SqlParameter("@krly", SqlDbType.VarChar, 50),
new SqlParameter("@xyh", SqlDbType.VarChar, 50),
new SqlParameter("@xydw", SqlDbType.VarChar, 500),
new SqlParameter("@xsy", SqlDbType.VarChar, 50),
new SqlParameter("@krdh", SqlDbType.VarChar, 50),
new SqlParameter("@krsj", SqlDbType.VarChar, 50),
new SqlParameter("@krEmail", SqlDbType.VarChar, 50),
new SqlParameter("@ydrxm", SqlDbType.VarChar, 50),
new SqlParameter("@ddsj", SqlDbType.DateTime),
new SqlParameter("@ddyy", SqlDbType.VarChar, 200),
new SqlParameter("@lzts", SqlDbType.Int, 4),
new SqlParameter("@lksj", SqlDbType.DateTime),
new SqlParameter("@qtyq", SqlDbType.VarChar, 800),
new SqlParameter("@ddrx", SqlDbType.VarChar, 50),
new SqlParameter("@ddwz", SqlDbType.VarChar, 50),
new SqlParameter("@zyzt", SqlDbType.VarChar, 50),
new SqlParameter("@czy", SqlDbType.VarChar, 50),
new SqlParameter("@cznr", SqlDbType.VarChar, 50),
new SqlParameter("@czsj", SqlDbType.DateTime),
new SqlParameter("@is_top", SqlDbType.Bit, 1),
new SqlParameter("@is_select", SqlDbType.Bit, 1),
new SqlParameter("@ffshys", SqlDbType.Bit, 1),
new SqlParameter("@shsc", SqlDbType.Bit, 1),
new SqlParameter("@sdcz", SqlDbType.Bit, 1),
new SqlParameter("@syzd", SqlDbType.VarChar, 50),
new SqlParameter("@tsyq", SqlDbType.VarChar, 500),
new SqlParameter("@ddly", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.yydh;
parameters[1].Value = model.qymc;
parameters[2].Value = model.lsbh;
parameters[3].Value = model.ddbh;
parameters[4].Value = model.krxm;
parameters[5].Value = model.krbh;
parameters[6].Value = model.yddj;
parameters[7].Value = model.sktt;
parameters[8].Value = model.krgj;
parameters[9].Value = model.krdz;
parameters[10].Value = model.krly;
parameters[11].Value = model.xyh;
parameters[12].Value = model.xydw;
parameters[13].Value = model.xsy;
parameters[14].Value = model.krdh;
parameters[15].Value = model.krsj;
parameters[16].Value = model.krEmail;
parameters[17].Value = model.ydrxm;
parameters[18].Value = model.ddsj;
parameters[19].Value = model.ddyy;
parameters[20].Value = model.lzts;
parameters[21].Value = model.lksj;
parameters[22].Value = model.qtyq;
parameters[23].Value = model.ddrx;
parameters[24].Value = model.ddwz;
parameters[25].Value = model.zyzt;
parameters[26].Value = model.czy;
parameters[27].Value = model.cznr;
parameters[28].Value = model.czsj;
parameters[29].Value = model.is_top;
parameters[30].Value = model.is_select;
parameters[31].Value = model.ffshys;
parameters[32].Value = model.shsc;
parameters[33].Value = model.sdcz;
parameters[34].Value = model.syzd;
parameters[35].Value = model.tsyq;
parameters[36].Value = model.ddly;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Hotel_app.Model.Qttyd_mainrecord GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,yydh,qymc,lsbh,ddbh,krxm,krbh,yddj,sktt,krgj,krdz,krly,xyh,xydw,xsy,krdh,krsj,krEmail,ydrxm,ddsj,ddyy,lzts,lksj,qtyq,ddrx,ddwz,zyzt,czy,cznr,czsj,is_top,is_select,ffshys,shsc,sdcz,syzd,tsyq,ddly from Qttyd_mainrecord ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Hotel_app.Model.Qttyd_mainrecord model = new Hotel_app.Model.Qttyd_mainrecord();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["yydh"] != null && ds.Tables[0].Rows[0]["yydh"].ToString() != "")
{
model.yydh = ds.Tables[0].Rows[0]["yydh"].ToString();
}
if (ds.Tables[0].Rows[0]["qymc"] != null && ds.Tables[0].Rows[0]["qymc"].ToString() != "")
{
model.qymc = ds.Tables[0].Rows[0]["qymc"].ToString();
}
if (ds.Tables[0].Rows[0]["lsbh"] != null && ds.Tables[0].Rows[0]["lsbh"].ToString() != "")
{
model.lsbh = ds.Tables[0].Rows[0]["lsbh"].ToString();
}
if (ds.Tables[0].Rows[0]["ddbh"] != null && ds.Tables[0].Rows[0]["ddbh"].ToString() != "")
{
model.ddbh = ds.Tables[0].Rows[0]["ddbh"].ToString();
}
if (ds.Tables[0].Rows[0]["krxm"] != null && ds.Tables[0].Rows[0]["krxm"].ToString() != "")
{
model.krxm = ds.Tables[0].Rows[0]["krxm"].ToString();
}
if (ds.Tables[0].Rows[0]["krbh"] != null && ds.Tables[0].Rows[0]["krbh"].ToString() != "")
{
model.krbh = ds.Tables[0].Rows[0]["krbh"].ToString();
}
if (ds.Tables[0].Rows[0]["yddj"] != null && ds.Tables[0].Rows[0]["yddj"].ToString() != "")
{
model.yddj = ds.Tables[0].Rows[0]["yddj"].ToString();
}
if (ds.Tables[0].Rows[0]["sktt"] != null && ds.Tables[0].Rows[0]["sktt"].ToString() != "")
{
model.sktt = ds.Tables[0].Rows[0]["sktt"].ToString();
}
if (ds.Tables[0].Rows[0]["krgj"] != null && ds.Tables[0].Rows[0]["krgj"].ToString() != "")
{
model.krgj = ds.Tables[0].Rows[0]["krgj"].ToString();
}
if (ds.Tables[0].Rows[0]["krdz"] != null && ds.Tables[0].Rows[0]["krdz"].ToString() != "")
{
model.krdz = ds.Tables[0].Rows[0]["krdz"].ToString();
}
if (ds.Tables[0].Rows[0]["krly"] != null && ds.Tables[0].Rows[0]["krly"].ToString() != "")
{
model.krly = ds.Tables[0].Rows[0]["krly"].ToString();
}
if (ds.Tables[0].Rows[0]["xyh"] != null && ds.Tables[0].Rows[0]["xyh"].ToString() != "")
{
model.xyh = ds.Tables[0].Rows[0]["xyh"].ToString();
}
if (ds.Tables[0].Rows[0]["xydw"] != null && ds.Tables[0].Rows[0]["xydw"].ToString() != "")
{
model.xydw = ds.Tables[0].Rows[0]["xydw"].ToString();
}
if (ds.Tables[0].Rows[0]["xsy"] != null && ds.Tables[0].Rows[0]["xsy"].ToString() != "")
{
model.xsy = ds.Tables[0].Rows[0]["xsy"].ToString();
}
if (ds.Tables[0].Rows[0]["krdh"] != null && ds.Tables[0].Rows[0]["krdh"].ToString() != "")
{
model.krdh = ds.Tables[0].Rows[0]["krdh"].ToString();
}
if (ds.Tables[0].Rows[0]["krsj"] != null && ds.Tables[0].Rows[0]["krsj"].ToString() != "")
{
model.krsj = ds.Tables[0].Rows[0]["krsj"].ToString();
}
if (ds.Tables[0].Rows[0]["krEmail"] != null && ds.Tables[0].Rows[0]["krEmail"].ToString() != "")
{
model.krEmail = ds.Tables[0].Rows[0]["krEmail"].ToString();
}
if (ds.Tables[0].Rows[0]["ydrxm"] != null && ds.Tables[0].Rows[0]["ydrxm"].ToString() != "")
{
model.ydrxm = ds.Tables[0].Rows[0]["ydrxm"].ToString();
}
if (ds.Tables[0].Rows[0]["ddsj"] != null && ds.Tables[0].Rows[0]["ddsj"].ToString() != "")
{
model.ddsj = DateTime.Parse(ds.Tables[0].Rows[0]["ddsj"].ToString());
}
if (ds.Tables[0].Rows[0]["ddyy"] != null && ds.Tables[0].Rows[0]["ddyy"].ToString() != "")
{
model.ddyy = ds.Tables[0].Rows[0]["ddyy"].ToString();
}
if (ds.Tables[0].Rows[0]["lzts"] != null && ds.Tables[0].Rows[0]["lzts"].ToString() != "")
{
model.lzts = int.Parse(ds.Tables[0].Rows[0]["lzts"].ToString());
}
if (ds.Tables[0].Rows[0]["lksj"] != null && ds.Tables[0].Rows[0]["lksj"].ToString() != "")
{
model.lksj = DateTime.Parse(ds.Tables[0].Rows[0]["lksj"].ToString());
}
if (ds.Tables[0].Rows[0]["qtyq"] != null && ds.Tables[0].Rows[0]["qtyq"].ToString() != "")
{
model.qtyq = ds.Tables[0].Rows[0]["qtyq"].ToString();
}
if (ds.Tables[0].Rows[0]["ddrx"] != null && ds.Tables[0].Rows[0]["ddrx"].ToString() != "")
{
model.ddrx = ds.Tables[0].Rows[0]["ddrx"].ToString();
}
if (ds.Tables[0].Rows[0]["ddwz"] != null && ds.Tables[0].Rows[0]["ddwz"].ToString() != "")
{
model.ddwz = ds.Tables[0].Rows[0]["ddwz"].ToString();
}
if (ds.Tables[0].Rows[0]["zyzt"] != null && ds.Tables[0].Rows[0]["zyzt"].ToString() != "")
{
model.zyzt = ds.Tables[0].Rows[0]["zyzt"].ToString();
}
if (ds.Tables[0].Rows[0]["czy"] != null && ds.Tables[0].Rows[0]["czy"].ToString() != "")
{
model.czy = ds.Tables[0].Rows[0]["czy"].ToString();
}
if (ds.Tables[0].Rows[0]["cznr"] != null && ds.Tables[0].Rows[0]["cznr"].ToString() != "")
{
model.cznr = ds.Tables[0].Rows[0]["cznr"].ToString();
}
if (ds.Tables[0].Rows[0]["czsj"] != null && ds.Tables[0].Rows[0]["czsj"].ToString() != "")
{
model.czsj = DateTime.Parse(ds.Tables[0].Rows[0]["czsj"].ToString());
}
if (ds.Tables[0].Rows[0]["is_top"] != null && ds.Tables[0].Rows[0]["is_top"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["is_top"].ToString() == "1") || (ds.Tables[0].Rows[0]["is_top"].ToString().ToLower() == "true"))
{
model.is_top = true;
}
else
{
model.is_top = false;
}
}
if (ds.Tables[0].Rows[0]["is_select"] != null && ds.Tables[0].Rows[0]["is_select"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["is_select"].ToString() == "1") || (ds.Tables[0].Rows[0]["is_select"].ToString().ToLower() == "true"))
{
model.is_select = true;
}
else
{
model.is_select = false;
}
}
if (ds.Tables[0].Rows[0]["ffshys"] != null && ds.Tables[0].Rows[0]["ffshys"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["ffshys"].ToString() == "1") || (ds.Tables[0].Rows[0]["ffshys"].ToString().ToLower() == "true"))
{
model.ffshys = true;
}
else
{
model.ffshys = false;
}
}
if (ds.Tables[0].Rows[0]["shsc"] != null && ds.Tables[0].Rows[0]["shsc"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["shsc"].ToString() == "1") || (ds.Tables[0].Rows[0]["shsc"].ToString().ToLower() == "true"))
{
model.shsc = true;
}
else
{
model.shsc = false;
}
}
if (ds.Tables[0].Rows[0]["sdcz"] != null && ds.Tables[0].Rows[0]["sdcz"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["sdcz"].ToString() == "1") || (ds.Tables[0].Rows[0]["sdcz"].ToString().ToLower() == "true"))
{
model.sdcz = true;
}
else
{
model.sdcz = false;
}
}
if (ds.Tables[0].Rows[0]["syzd"] != null && ds.Tables[0].Rows[0]["syzd"].ToString() != "")
{
model.syzd = ds.Tables[0].Rows[0]["syzd"].ToString();
}
if (ds.Tables[0].Rows[0]["tsyq"] != null && ds.Tables[0].Rows[0]["tsyq"].ToString() != "")
{
model.tsyq = ds.Tables[0].Rows[0]["tsyq"].ToString();
}
if (ds.Tables[0].Rows[0]["ddly"] != null && ds.Tables[0].Rows[0]["ddly"].ToString() != "")
{
model.ddly = ds.Tables[0].Rows[0]["ddly"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Hotel_app.Model.Qttyd_mainrecord model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Qttyd_mainrecord set ");
strSql.Append("yydh=@yydh,");
strSql.Append("qymc=@qymc,");
strSql.Append("lsbh=@lsbh,");
strSql.Append("ddbh=@ddbh,");
strSql.Append("krxm=@krxm,");
strSql.Append("krbh=@krbh,");
strSql.Append("yddj=@yddj,");
strSql.Append("sktt=@sktt,");
strSql.Append("krgj=@krgj,");
strSql.Append("krdz=@krdz,");
strSql.Append("krly=@krly,");
strSql.Append("xyh=@xyh,");
strSql.Append("xydw=@xydw,");
strSql.Append("xsy=@xsy,");
strSql.Append("krdh=@krdh,");
strSql.Append("krsj=@krsj,");
strSql.Append("krEmail=@krEmail,");
strSql.Append("ydrxm=@ydrxm,");
strSql.Append("ddsj=@ddsj,");
strSql.Append("ddyy=@ddyy,");
strSql.Append("lzts=@lzts,");
strSql.Append("lksj=@lksj,");
strSql.Append("qtyq=@qtyq,");
strSql.Append("ddrx=@ddrx,");
strSql.Append("ddwz=@ddwz,");
strSql.Append("zyzt=@zyzt,");
strSql.Append("czy=@czy,");
strSql.Append("cznr=@cznr,");
strSql.Append("czsj=@czsj,");
strSql.Append("is_top=@is_top,");
strSql.Append("is_select=@is_select,");
strSql.Append("ffshys=@ffshys,");
strSql.Append("shsc=@shsc,");
strSql.Append("sdcz=@sdcz,");
strSql.Append("syzd=@syzd,");
strSql.Append("tsyq=@tsyq,");
strSql.Append("ddly=@ddly");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@yydh", SqlDbType.VarChar, 50),
new SqlParameter("@qymc", SqlDbType.VarChar, 50),
new SqlParameter("@lsbh", SqlDbType.VarChar, 50),
new SqlParameter("@ddbh", SqlDbType.VarChar, 50),
new SqlParameter("@krxm", SqlDbType.VarChar, 50),
new SqlParameter("@krbh", SqlDbType.VarChar, 50),
new SqlParameter("@yddj", SqlDbType.VarChar, 50),
new SqlParameter("@sktt", SqlDbType.VarChar, 50),
new SqlParameter("@krgj", SqlDbType.VarChar, 50),
new SqlParameter("@krdz", SqlDbType.VarChar, 50),
new SqlParameter("@krly", SqlDbType.VarChar, 50),
new SqlParameter("@xyh", SqlDbType.VarChar, 50),
new SqlParameter("@xydw", SqlDbType.VarChar, 500),
new SqlParameter("@xsy", SqlDbType.VarChar, 50),
new SqlParameter("@krdh", SqlDbType.VarChar, 50),
new SqlParameter("@krsj", SqlDbType.VarChar, 50),
new SqlParameter("@krEmail", SqlDbType.VarChar, 50),
new SqlParameter("@ydrxm", SqlDbType.VarChar, 50),
new SqlParameter("@ddsj", SqlDbType.DateTime),
new SqlParameter("@ddyy", SqlDbType.VarChar, 200),
new SqlParameter("@lzts", SqlDbType.Int, 4),
new SqlParameter("@lksj", SqlDbType.DateTime),
new SqlParameter("@qtyq", SqlDbType.VarChar, 800),
new SqlParameter("@ddrx", SqlDbType.VarChar, 50),
new SqlParameter("@ddwz", SqlDbType.VarChar, 50),
new SqlParameter("@zyzt", SqlDbType.VarChar, 50),
new SqlParameter("@czy", SqlDbType.VarChar, 50),
new SqlParameter("@cznr", SqlDbType.VarChar, 50),
new SqlParameter("@czsj", SqlDbType.DateTime),
new SqlParameter("@is_top", SqlDbType.Bit, 1),
new SqlParameter("@is_select", SqlDbType.Bit, 1),
new SqlParameter("@ffshys", SqlDbType.Bit, 1),
new SqlParameter("@shsc", SqlDbType.Bit, 1),
new SqlParameter("@sdcz", SqlDbType.Bit, 1),
new SqlParameter("@syzd", SqlDbType.VarChar, 50),
new SqlParameter("@tsyq", SqlDbType.VarChar, 500),
new SqlParameter("@ddly", SqlDbType.VarChar, 50),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.yydh;
parameters[1].Value = model.qymc;
parameters[2].Value = model.lsbh;
parameters[3].Value = model.ddbh;
parameters[4].Value = model.krxm;
parameters[5].Value = model.krbh;
parameters[6].Value = model.yddj;
parameters[7].Value = model.sktt;
parameters[8].Value = model.krgj;
parameters[9].Value = model.krdz;
parameters[10].Value = model.krly;
parameters[11].Value = model.xyh;
parameters[12].Value = model.xydw;
parameters[13].Value = model.xsy;
parameters[14].Value = model.krdh;
parameters[15].Value = model.krsj;
parameters[16].Value = model.krEmail;
parameters[17].Value = model.ydrxm;
parameters[18].Value = model.ddsj;
parameters[19].Value = model.ddyy;
parameters[20].Value = model.lzts;
parameters[21].Value = model.lksj;
parameters[22].Value = model.qtyq;
parameters[23].Value = model.ddrx;
parameters[24].Value = model.ddwz;
parameters[25].Value = model.zyzt;
parameters[26].Value = model.czy;
parameters[27].Value = model.cznr;
parameters[28].Value = model.czsj;
parameters[29].Value = model.is_top;
parameters[30].Value = model.is_select;
parameters[31].Value = model.ffshys;
parameters[32].Value = model.shsc;
parameters[33].Value = model.sdcz;
parameters[34].Value = model.syzd;
parameters[35].Value = model.tsyq;
parameters[36].Value = model.ddly;
parameters[37].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
