/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hotel_app.Model.Sjzmx model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Sjzmx(");
strSql.Append("yydh,qymc,is_top,is_select,id_app,jzbh,lsbh,krxm,fjrb,fjbh,sktt,xfrq,xfsj,czy,xfdr,xfrb,xfxm,xfbz,xfzy,jjje,xfje,yh,sjxfje,xfsl,shsc,czy_bc,czzt,tfsj,czsj,syzd,is_visible,xyh,jzzt,fkfs,mxbh)");
strSql.Append(" values (");
strSql.Append("@yydh,@qymc,@is_top,@is_select,@id_app,@jzbh,@lsbh,@krxm,@fjrb,@fjbh,@sktt,@xfrq,@xfsj,@czy,@xfdr,@xfrb,@xfxm,@xfbz,@xfzy,@jjje,@xfje,@yh,@sjxfje,@xfsl,@shsc,@czy_bc,@czzt,@tfsj,@czsj,@syzd,@is_visible,@xyh,@jzzt,@fkfs,@mxbh)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@yydh", SqlDbType.VarChar, 50),
new SqlParameter("@qymc", SqlDbType.VarChar, 50),
new SqlParameter("@is_top", SqlDbType.Bit, 1),
new SqlParameter("@is_select", SqlDbType.Bit, 1),
new SqlParameter("@id_app", SqlDbType.VarChar, 50),
new SqlParameter("@jzbh", SqlDbType.VarChar, 50),
new SqlParameter("@lsbh", SqlDbType.VarChar, 50),
new SqlParameter("@krxm", SqlDbType.VarChar, 50),
new SqlParameter("@fjrb", SqlDbType.VarChar, 50),
new SqlParameter("@fjbh", SqlDbType.VarChar, 50),
new SqlParameter("@sktt", SqlDbType.VarChar, 50),
new SqlParameter("@xfrq", SqlDbType.DateTime),
new SqlParameter("@xfsj", SqlDbType.DateTime),
new SqlParameter("@czy", SqlDbType.VarChar, 50),
new SqlParameter("@xfdr", SqlDbType.VarChar, 200),
new SqlParameter("@xfrb", SqlDbType.VarChar, 200),
new SqlParameter("@xfxm", SqlDbType.VarChar, 200),
new SqlParameter("@xfbz", SqlDbType.VarChar, 200),
new SqlParameter("@xfzy", SqlDbType.VarChar, 200),
new SqlParameter("@jjje", SqlDbType.Decimal, 9),
new SqlParameter("@xfje", SqlDbType.Decimal, 9),
new SqlParameter("@yh", SqlDbType.VarChar, 50),
new SqlParameter("@sjxfje", SqlDbType.Decimal, 9),
new SqlParameter("@xfsl", SqlDbType.Decimal, 9),
new SqlParameter("@shsc", SqlDbType.Bit, 1),
new SqlParameter("@czy_bc", SqlDbType.VarChar, 50),
new SqlParameter("@czzt", SqlDbType.VarChar, 50),
new SqlParameter("@tfsj", SqlDbType.DateTime),
new SqlParameter("@czsj", SqlDbType.DateTime),
new SqlParameter("@syzd", SqlDbType.VarChar, 50),
new SqlParameter("@is_visible", SqlDbType.Bit, 1),
new SqlParameter("@xyh", SqlDbType.VarChar, 50),
new SqlParameter("@jzzt", SqlDbType.VarChar, 200),
new SqlParameter("@fkfs", SqlDbType.VarChar, 50),
new SqlParameter("@mxbh", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.yydh;
parameters[1].Value = model.qymc;
parameters[2].Value = model.is_top;
parameters[3].Value = model.is_select;
parameters[4].Value = model.id_app;
parameters[5].Value = model.jzbh;
parameters[6].Value = model.lsbh;
parameters[7].Value = model.krxm;
parameters[8].Value = model.fjrb;
parameters[9].Value = model.fjbh;
parameters[10].Value = model.sktt;
parameters[11].Value = model.xfrq;
parameters[12].Value = model.xfsj;
parameters[13].Value = model.czy;
parameters[14].Value = model.xfdr;
parameters[15].Value = model.xfrb;
parameters[16].Value = model.xfxm;
parameters[17].Value = model.xfbz;
parameters[18].Value = model.xfzy;
parameters[19].Value = model.jjje;
parameters[20].Value = model.xfje;
parameters[21].Value = model.yh;
parameters[22].Value = model.sjxfje;
parameters[23].Value = model.xfsl;
parameters[24].Value = model.shsc;
parameters[25].Value = model.czy_bc;
parameters[26].Value = model.czzt;
parameters[27].Value = model.tfsj;
parameters[28].Value = model.czsj;
parameters[29].Value = model.syzd;
parameters[30].Value = model.is_visible;
parameters[31].Value = model.xyh;
parameters[32].Value = model.jzzt;
parameters[33].Value = model.fkfs;
parameters[34].Value = model.mxbh;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Hotel_app.Model.Sjzmx model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Sjzmx set ");
strSql.Append("yydh=@yydh,");
strSql.Append("qymc=@qymc,");
strSql.Append("is_top=@is_top,");
strSql.Append("is_select=@is_select,");
strSql.Append("id_app=@id_app,");
strSql.Append("jzbh=@jzbh,");
strSql.Append("lsbh=@lsbh,");
strSql.Append("krxm=@krxm,");
strSql.Append("fjrb=@fjrb,");
strSql.Append("fjbh=@fjbh,");
strSql.Append("sktt=@sktt,");
strSql.Append("xfrq=@xfrq,");
strSql.Append("xfsj=@xfsj,");
strSql.Append("czy=@czy,");
strSql.Append("xfdr=@xfdr,");
strSql.Append("xfrb=@xfrb,");
strSql.Append("xfxm=@xfxm,");
strSql.Append("xfbz=@xfbz,");
strSql.Append("xfzy=@xfzy,");
strSql.Append("jjje=@jjje,");
strSql.Append("xfje=@xfje,");
strSql.Append("yh=@yh,");
strSql.Append("sjxfje=@sjxfje,");
strSql.Append("xfsl=@xfsl,");
strSql.Append("shsc=@shsc,");
strSql.Append("czy_bc=@czy_bc,");
strSql.Append("czzt=@czzt,");
strSql.Append("tfsj=@tfsj,");
strSql.Append("czsj=@czsj,");
strSql.Append("syzd=@syzd,");
strSql.Append("is_visible=@is_visible,");
strSql.Append("xyh=@xyh,");
strSql.Append("jzzt=@jzzt,");
strSql.Append("fkfs=@fkfs,");
strSql.Append("mxbh=@mxbh");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@yydh", SqlDbType.VarChar, 50),
new SqlParameter("@qymc", SqlDbType.VarChar, 50),
new SqlParameter("@is_top", SqlDbType.Bit, 1),
new SqlParameter("@is_select", SqlDbType.Bit, 1),
new SqlParameter("@id_app", SqlDbType.VarChar, 50),
new SqlParameter("@jzbh", SqlDbType.VarChar, 50),
new SqlParameter("@lsbh", SqlDbType.VarChar, 50),
new SqlParameter("@krxm", SqlDbType.VarChar, 50),
new SqlParameter("@fjrb", SqlDbType.VarChar, 50),
new SqlParameter("@fjbh", SqlDbType.VarChar, 50),
new SqlParameter("@sktt", SqlDbType.VarChar, 50),
new SqlParameter("@xfrq", SqlDbType.DateTime),
new SqlParameter("@xfsj", SqlDbType.DateTime),
new SqlParameter("@czy", SqlDbType.VarChar, 50),
new SqlParameter("@xfdr", SqlDbType.VarChar, 200),
new SqlParameter("@xfrb", SqlDbType.VarChar, 200),
new SqlParameter("@xfxm", SqlDbType.VarChar, 200),
new SqlParameter("@xfbz", SqlDbType.VarChar, 200),
new SqlParameter("@xfzy", SqlDbType.VarChar, 200),
new SqlParameter("@jjje", SqlDbType.Decimal, 9),
new SqlParameter("@xfje", SqlDbType.Decimal, 9),
new SqlParameter("@yh", SqlDbType.VarChar, 50),
new SqlParameter("@sjxfje", SqlDbType.Decimal, 9),
new SqlParameter("@xfsl", SqlDbType.Decimal, 9),
new SqlParameter("@shsc", SqlDbType.Bit, 1),
new SqlParameter("@czy_bc", SqlDbType.VarChar, 50),
new SqlParameter("@czzt", SqlDbType.VarChar, 50),
new SqlParameter("@tfsj", SqlDbType.DateTime),
new SqlParameter("@czsj", SqlDbType.DateTime),
new SqlParameter("@syzd", SqlDbType.VarChar, 50),
new SqlParameter("@is_visible", SqlDbType.Bit, 1),
new SqlParameter("@xyh", SqlDbType.VarChar, 50),
new SqlParameter("@jzzt", SqlDbType.VarChar, 200),
new SqlParameter("@fkfs", SqlDbType.VarChar, 50),
new SqlParameter("@mxbh", SqlDbType.VarChar, 50),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.yydh;
parameters[1].Value = model.qymc;
parameters[2].Value = model.is_top;
parameters[3].Value = model.is_select;
parameters[4].Value = model.id_app;
parameters[5].Value = model.jzbh;
parameters[6].Value = model.lsbh;
parameters[7].Value = model.krxm;
parameters[8].Value = model.fjrb;
parameters[9].Value = model.fjbh;
parameters[10].Value = model.sktt;
parameters[11].Value = model.xfrq;
parameters[12].Value = model.xfsj;
parameters[13].Value = model.czy;
parameters[14].Value = model.xfdr;
parameters[15].Value = model.xfrb;
parameters[16].Value = model.xfxm;
parameters[17].Value = model.xfbz;
parameters[18].Value = model.xfzy;
parameters[19].Value = model.jjje;
parameters[20].Value = model.xfje;
parameters[21].Value = model.yh;
parameters[22].Value = model.sjxfje;
parameters[23].Value = model.xfsl;
parameters[24].Value = model.shsc;
parameters[25].Value = model.czy_bc;
parameters[26].Value = model.czzt;
parameters[27].Value = model.tfsj;
parameters[28].Value = model.czsj;
parameters[29].Value = model.syzd;
parameters[30].Value = model.is_visible;
parameters[31].Value = model.xyh;
parameters[32].Value = model.jzzt;
parameters[33].Value = model.fkfs;
parameters[34].Value = model.mxbh;
parameters[35].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Hotel_app.Model.Sjzmx GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,yydh,qymc,is_top,is_select,id_app,jzbh,lsbh,krxm,fjrb,fjbh,sktt,xfrq,xfsj,czy,xfdr,xfrb,xfxm,xfbz,xfzy,jjje,xfje,yh,sjxfje,xfsl,shsc,czy_bc,czzt,tfsj,czsj,syzd,is_visible,xyh,jzzt,fkfs,mxbh from Sjzmx ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Hotel_app.Model.Sjzmx model = new Hotel_app.Model.Sjzmx();
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]["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]["id_app"] != null && ds.Tables[0].Rows[0]["id_app"].ToString() != "")
{
model.id_app = ds.Tables[0].Rows[0]["id_app"].ToString();
}
if (ds.Tables[0].Rows[0]["jzbh"] != null && ds.Tables[0].Rows[0]["jzbh"].ToString() != "")
{
model.jzbh = ds.Tables[0].Rows[0]["jzbh"].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]["krxm"] != null && ds.Tables[0].Rows[0]["krxm"].ToString() != "")
{
model.krxm = ds.Tables[0].Rows[0]["krxm"].ToString();
}
if (ds.Tables[0].Rows[0]["fjrb"] != null && ds.Tables[0].Rows[0]["fjrb"].ToString() != "")
{
model.fjrb = ds.Tables[0].Rows[0]["fjrb"].ToString();
}
if (ds.Tables[0].Rows[0]["fjbh"] != null && ds.Tables[0].Rows[0]["fjbh"].ToString() != "")
{
model.fjbh = ds.Tables[0].Rows[0]["fjbh"].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]["xfrq"] != null && ds.Tables[0].Rows[0]["xfrq"].ToString() != "")
{
model.xfrq = DateTime.Parse(ds.Tables[0].Rows[0]["xfrq"].ToString());
}
if (ds.Tables[0].Rows[0]["xfsj"] != null && ds.Tables[0].Rows[0]["xfsj"].ToString() != "")
{
model.xfsj = DateTime.Parse(ds.Tables[0].Rows[0]["xfsj"].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]["xfdr"] != null && ds.Tables[0].Rows[0]["xfdr"].ToString() != "")
{
model.xfdr = ds.Tables[0].Rows[0]["xfdr"].ToString();
}
if (ds.Tables[0].Rows[0]["xfrb"] != null && ds.Tables[0].Rows[0]["xfrb"].ToString() != "")
{
model.xfrb = ds.Tables[0].Rows[0]["xfrb"].ToString();
}
if (ds.Tables[0].Rows[0]["xfxm"] != null && ds.Tables[0].Rows[0]["xfxm"].ToString() != "")
{
model.xfxm = ds.Tables[0].Rows[0]["xfxm"].ToString();
}
if (ds.Tables[0].Rows[0]["xfbz"] != null && ds.Tables[0].Rows[0]["xfbz"].ToString() != "")
{
model.xfbz = ds.Tables[0].Rows[0]["xfbz"].ToString();
}
if (ds.Tables[0].Rows[0]["xfzy"] != null && ds.Tables[0].Rows[0]["xfzy"].ToString() != "")
{
model.xfzy = ds.Tables[0].Rows[0]["xfzy"].ToString();
}
if (ds.Tables[0].Rows[0]["jjje"] != null && ds.Tables[0].Rows[0]["jjje"].ToString() != "")
{
model.jjje = decimal.Parse(ds.Tables[0].Rows[0]["jjje"].ToString());
}
if (ds.Tables[0].Rows[0]["xfje"] != null && ds.Tables[0].Rows[0]["xfje"].ToString() != "")
{
model.xfje = decimal.Parse(ds.Tables[0].Rows[0]["xfje"].ToString());
}
if (ds.Tables[0].Rows[0]["yh"] != null && ds.Tables[0].Rows[0]["yh"].ToString() != "")
{
model.yh = ds.Tables[0].Rows[0]["yh"].ToString();
}
if (ds.Tables[0].Rows[0]["sjxfje"] != null && ds.Tables[0].Rows[0]["sjxfje"].ToString() != "")
{
model.sjxfje = decimal.Parse(ds.Tables[0].Rows[0]["sjxfje"].ToString());
}
if (ds.Tables[0].Rows[0]["xfsl"] != null && ds.Tables[0].Rows[0]["xfsl"].ToString() != "")
{
model.xfsl = decimal.Parse(ds.Tables[0].Rows[0]["xfsl"].ToString());
}
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]["czy_bc"] != null && ds.Tables[0].Rows[0]["czy_bc"].ToString() != "")
{
model.czy_bc = ds.Tables[0].Rows[0]["czy_bc"].ToString();
}
if (ds.Tables[0].Rows[0]["czzt"] != null && ds.Tables[0].Rows[0]["czzt"].ToString() != "")
{
model.czzt = ds.Tables[0].Rows[0]["czzt"].ToString();
}
if (ds.Tables[0].Rows[0]["tfsj"] != null && ds.Tables[0].Rows[0]["tfsj"].ToString() != "")
{
model.tfsj = DateTime.Parse(ds.Tables[0].Rows[0]["tfsj"].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]["syzd"] != null && ds.Tables[0].Rows[0]["syzd"].ToString() != "")
{
model.syzd = ds.Tables[0].Rows[0]["syzd"].ToString();
}
if (ds.Tables[0].Rows[0]["is_visible"] != null && ds.Tables[0].Rows[0]["is_visible"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["is_visible"].ToString() == "1") || (ds.Tables[0].Rows[0]["is_visible"].ToString().ToLower() == "true"))
{
model.is_visible = true;
}
else
{
model.is_visible = false;
}
}
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]["jzzt"] != null && ds.Tables[0].Rows[0]["jzzt"].ToString() != "")
{
model.jzzt = ds.Tables[0].Rows[0]["jzzt"].ToString();
}
if (ds.Tables[0].Rows[0]["fkfs"] != null && ds.Tables[0].Rows[0]["fkfs"].ToString() != "")
{
model.fkfs = ds.Tables[0].Rows[0]["fkfs"].ToString();
}
if (ds.Tables[0].Rows[0]["mxbh"] != null && ds.Tables[0].Rows[0]["mxbh"].ToString() != "")
{
model.mxbh = ds.Tables[0].Rows[0]["mxbh"].ToString();
}
return(model);
}
else
{
return(null);
}
}
//平帐时用到的方法
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);
}