public static string GetXyhByXxydw(string xydw)
{
string xyh = "";
BLL.Yxydw B_Yxydw = new Hotel_app.BLL.Yxydw();
Model.Yxydw M_yxydw = new Hotel_app.Model.Yxydw();
List <Model.Yxydw> list_temp = B_Yxydw.GetModelList(" yydh='" + common_file.common_app.yydh + "' and xydw='" + xydw + "' and rx='" + common_file.common_xydw.xyrx_gzdw + "'");
if (list_temp != null && list_temp.Count > 0)
{
return(xyh = list_temp[0].xyh);
}
return(xyh);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hotel_app.Model.Yxydw model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Yxydw(");
strSql.Append("krly,yydh,qymc,xyrx,krgj,pq,xyh,xyh_inner,rx,xydw,zjm,nxr,krdh,krcz,krEmail,krdz,xsy,shsc,bz,lzfs,fkje,xfje,clsj,xzxg,is_top,is_select,shsh,sign_image,xsed)");
strSql.Append(" values (");
strSql.Append("@krly,@yydh,@qymc,@xyrx,@krgj,@pq,@xyh,@xyh_inner,@rx,@xydw,@zjm,@nxr,@krdh,@krcz,@krEmail,@krdz,@xsy,@shsc,@bz,@lzfs,@fkje,@xfje,@clsj,@xzxg,@is_top,@is_select,@shsh,@sign_image,@xsed)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@krly", SqlDbType.VarChar, 50),
new SqlParameter("@yydh", SqlDbType.VarChar, 50),
new SqlParameter("@qymc", SqlDbType.VarChar, 50),
new SqlParameter("@xyrx", SqlDbType.VarChar, 50),
new SqlParameter("@krgj", SqlDbType.VarChar, 50),
new SqlParameter("@pq", SqlDbType.VarChar, 50),
new SqlParameter("@xyh", SqlDbType.VarChar, 50),
new SqlParameter("@xyh_inner", SqlDbType.VarChar, 50),
new SqlParameter("@rx", SqlDbType.VarChar, 50),
new SqlParameter("@xydw", SqlDbType.VarChar, 200),
new SqlParameter("@zjm", SqlDbType.VarChar, 50),
new SqlParameter("@nxr", SqlDbType.VarChar, 50),
new SqlParameter("@krdh", SqlDbType.VarChar, 50),
new SqlParameter("@krcz", SqlDbType.VarChar, 50),
new SqlParameter("@krEmail", SqlDbType.VarChar, 50),
new SqlParameter("@krdz", SqlDbType.VarChar, 200),
new SqlParameter("@xsy", SqlDbType.VarChar, 50),
new SqlParameter("@shsc", SqlDbType.Bit, 1),
new SqlParameter("@bz", SqlDbType.VarChar, 300),
new SqlParameter("@lzfs", SqlDbType.Decimal, 9),
new SqlParameter("@fkje", SqlDbType.Decimal, 9),
new SqlParameter("@xfje", SqlDbType.Decimal, 9),
new SqlParameter("@clsj", SqlDbType.DateTime),
new SqlParameter("@xzxg", SqlDbType.VarChar, 50),
new SqlParameter("@is_top", SqlDbType.Bit, 1),
new SqlParameter("@is_select", SqlDbType.Bit, 1),
new SqlParameter("@shsh", SqlDbType.Bit, 1),
new SqlParameter("@sign_image", SqlDbType.Image),
new SqlParameter("@xsed", SqlDbType.Decimal, 5)
};
parameters[0].Value = model.krly;
parameters[1].Value = model.yydh;
parameters[2].Value = model.qymc;
parameters[3].Value = model.xyrx;
parameters[4].Value = model.krgj;
parameters[5].Value = model.pq;
parameters[6].Value = model.xyh;
parameters[7].Value = model.xyh_inner;
parameters[8].Value = model.rx;
parameters[9].Value = model.xydw;
parameters[10].Value = model.zjm;
parameters[11].Value = model.nxr;
parameters[12].Value = model.krdh;
parameters[13].Value = model.krcz;
parameters[14].Value = model.krEmail;
parameters[15].Value = model.krdz;
parameters[16].Value = model.xsy;
parameters[17].Value = model.shsc;
parameters[18].Value = model.bz;
parameters[19].Value = model.lzfs;
parameters[20].Value = model.fkje;
parameters[21].Value = model.xfje;
parameters[22].Value = model.clsj;
parameters[23].Value = model.xzxg;
parameters[24].Value = model.is_top;
parameters[25].Value = model.is_select;
parameters[26].Value = model.shsh;
parameters[27].Value = model.sign_image;
parameters[28].Value = model.xsed;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Hotel_app.Model.Yxydw GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,krly,yydh,qymc,xyrx,krgj,pq,xyh,xyh_inner,rx,xydw,zjm,nxr,krdh,krcz,krEmail,krdz,xsy,shsc,bz,lzfs,fkje,xfje,clsj,xzxg,is_top,is_select,shsh,sign_image,xsed from Yxydw ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Hotel_app.Model.Yxydw model = new Hotel_app.Model.Yxydw();
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]["krly"] != null && ds.Tables[0].Rows[0]["krly"].ToString() != "")
{
model.krly = ds.Tables[0].Rows[0]["krly"].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]["xyrx"] != null && ds.Tables[0].Rows[0]["xyrx"].ToString() != "")
{
model.xyrx = ds.Tables[0].Rows[0]["xyrx"].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]["pq"] != null && ds.Tables[0].Rows[0]["pq"].ToString() != "")
{
model.pq = ds.Tables[0].Rows[0]["pq"].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]["xyh_inner"] != null && ds.Tables[0].Rows[0]["xyh_inner"].ToString() != "")
{
model.xyh_inner = ds.Tables[0].Rows[0]["xyh_inner"].ToString();
}
if (ds.Tables[0].Rows[0]["rx"] != null && ds.Tables[0].Rows[0]["rx"].ToString() != "")
{
model.rx = ds.Tables[0].Rows[0]["rx"].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]["zjm"] != null && ds.Tables[0].Rows[0]["zjm"].ToString() != "")
{
model.zjm = ds.Tables[0].Rows[0]["zjm"].ToString();
}
if (ds.Tables[0].Rows[0]["nxr"] != null && ds.Tables[0].Rows[0]["nxr"].ToString() != "")
{
model.nxr = ds.Tables[0].Rows[0]["nxr"].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]["krcz"] != null && ds.Tables[0].Rows[0]["krcz"].ToString() != "")
{
model.krcz = ds.Tables[0].Rows[0]["krcz"].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]["krdz"] != null && ds.Tables[0].Rows[0]["krdz"].ToString() != "")
{
model.krdz = ds.Tables[0].Rows[0]["krdz"].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]["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]["bz"] != null && ds.Tables[0].Rows[0]["bz"].ToString() != "")
{
model.bz = ds.Tables[0].Rows[0]["bz"].ToString();
}
if (ds.Tables[0].Rows[0]["lzfs"] != null && ds.Tables[0].Rows[0]["lzfs"].ToString() != "")
{
model.lzfs = decimal.Parse(ds.Tables[0].Rows[0]["lzfs"].ToString());
}
if (ds.Tables[0].Rows[0]["fkje"] != null && ds.Tables[0].Rows[0]["fkje"].ToString() != "")
{
model.fkje = decimal.Parse(ds.Tables[0].Rows[0]["fkje"].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]["clsj"] != null && ds.Tables[0].Rows[0]["clsj"].ToString() != "")
{
model.clsj = DateTime.Parse(ds.Tables[0].Rows[0]["clsj"].ToString());
}
if (ds.Tables[0].Rows[0]["xzxg"] != null && ds.Tables[0].Rows[0]["xzxg"].ToString() != "")
{
model.xzxg = ds.Tables[0].Rows[0]["xzxg"].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]["shsh"] != null && ds.Tables[0].Rows[0]["shsh"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["shsh"].ToString() == "1") || (ds.Tables[0].Rows[0]["shsh"].ToString().ToLower() == "true"))
{
model.shsh = true;
}
else
{
model.shsh = false;
}
}
if (ds.Tables[0].Rows[0]["sign_image"] != null && ds.Tables[0].Rows[0]["sign_image"].ToString() != "")
{
model.sign_image = (byte[])ds.Tables[0].Rows[0]["sign_image"];
}
if (ds.Tables[0].Rows[0]["xsed"] != null && ds.Tables[0].Rows[0]["xsed"].ToString() != "")
{
model.xsed = decimal.Parse(ds.Tables[0].Rows[0]["xsed"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Hotel_app.Model.Yxydw model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Yxydw set ");
strSql.Append("krly=@krly,");
strSql.Append("yydh=@yydh,");
strSql.Append("qymc=@qymc,");
strSql.Append("xyrx=@xyrx,");
strSql.Append("krgj=@krgj,");
strSql.Append("pq=@pq,");
strSql.Append("xyh=@xyh,");
strSql.Append("xyh_inner=@xyh_inner,");
strSql.Append("rx=@rx,");
strSql.Append("xydw=@xydw,");
strSql.Append("zjm=@zjm,");
strSql.Append("nxr=@nxr,");
strSql.Append("krdh=@krdh,");
strSql.Append("krcz=@krcz,");
strSql.Append("krEmail=@krEmail,");
strSql.Append("krdz=@krdz,");
strSql.Append("xsy=@xsy,");
strSql.Append("shsc=@shsc,");
strSql.Append("bz=@bz,");
strSql.Append("lzfs=@lzfs,");
strSql.Append("fkje=@fkje,");
strSql.Append("xfje=@xfje,");
strSql.Append("clsj=@clsj,");
strSql.Append("xzxg=@xzxg,");
strSql.Append("is_top=@is_top,");
strSql.Append("is_select=@is_select,");
strSql.Append("shsh=@shsh,");
strSql.Append("sign_image=@sign_image,");
strSql.Append("xsed=@xsed");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@krly", SqlDbType.VarChar, 50),
new SqlParameter("@yydh", SqlDbType.VarChar, 50),
new SqlParameter("@qymc", SqlDbType.VarChar, 50),
new SqlParameter("@xyrx", SqlDbType.VarChar, 50),
new SqlParameter("@krgj", SqlDbType.VarChar, 50),
new SqlParameter("@pq", SqlDbType.VarChar, 50),
new SqlParameter("@xyh", SqlDbType.VarChar, 50),
new SqlParameter("@xyh_inner", SqlDbType.VarChar, 50),
new SqlParameter("@rx", SqlDbType.VarChar, 50),
new SqlParameter("@xydw", SqlDbType.VarChar, 200),
new SqlParameter("@zjm", SqlDbType.VarChar, 50),
new SqlParameter("@nxr", SqlDbType.VarChar, 50),
new SqlParameter("@krdh", SqlDbType.VarChar, 50),
new SqlParameter("@krcz", SqlDbType.VarChar, 50),
new SqlParameter("@krEmail", SqlDbType.VarChar, 50),
new SqlParameter("@krdz", SqlDbType.VarChar, 200),
new SqlParameter("@xsy", SqlDbType.VarChar, 50),
new SqlParameter("@shsc", SqlDbType.Bit, 1),
new SqlParameter("@bz", SqlDbType.VarChar, 300),
new SqlParameter("@lzfs", SqlDbType.Decimal, 9),
new SqlParameter("@fkje", SqlDbType.Decimal, 9),
new SqlParameter("@xfje", SqlDbType.Decimal, 9),
new SqlParameter("@clsj", SqlDbType.DateTime),
new SqlParameter("@xzxg", SqlDbType.VarChar, 50),
new SqlParameter("@is_top", SqlDbType.Bit, 1),
new SqlParameter("@is_select", SqlDbType.Bit, 1),
new SqlParameter("@shsh", SqlDbType.Bit, 1),
new SqlParameter("@sign_image", SqlDbType.Image),
new SqlParameter("@xsed", SqlDbType.Decimal, 5),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.krly;
parameters[1].Value = model.yydh;
parameters[2].Value = model.qymc;
parameters[3].Value = model.xyrx;
parameters[4].Value = model.krgj;
parameters[5].Value = model.pq;
parameters[6].Value = model.xyh;
parameters[7].Value = model.xyh_inner;
parameters[8].Value = model.rx;
parameters[9].Value = model.xydw;
parameters[10].Value = model.zjm;
parameters[11].Value = model.nxr;
parameters[12].Value = model.krdh;
parameters[13].Value = model.krcz;
parameters[14].Value = model.krEmail;
parameters[15].Value = model.krdz;
parameters[16].Value = model.xsy;
parameters[17].Value = model.shsc;
parameters[18].Value = model.bz;
parameters[19].Value = model.lzfs;
parameters[20].Value = model.fkje;
parameters[21].Value = model.xfje;
parameters[22].Value = model.clsj;
parameters[23].Value = model.xzxg;
parameters[24].Value = model.is_top;
parameters[25].Value = model.is_select;
parameters[26].Value = model.shsh;
parameters[27].Value = model.sign_image;
parameters[28].Value = model.xsed;
parameters[29].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public string Yxydw_add_edit(string id, string yydh, string qymc, string zjm, string xyrx, string xyh_inner, string xydw, string nxr, string krdh, string kremail, string krcz, string krdz, string xsy, string bz, string krly, byte[] sign_image, string rx, string xyh, string add_edit_delete, string xxzs, string sxed)
{
string s = common_file.common_app.get_failure;
BLL.Yxydw B_Yxydw = new Hotel_app.BLL.Yxydw();
Model.Yxydw M_Yxydw = new Hotel_app.Model.Yxydw();
Decimal sxed_get = 0;
if (xxzs == common_file.common_app.xxzs_xxvalue)
{
}
if (xxzs == common_file.common_app.xxzs_zsvalue)
{
}
try
{
sxed_get = decimal.Parse(sxed);
}
catch
{
sxed_get = 0;
}
if (add_edit_delete == common_file.common_app.get_add)
{
M_Yxydw.yydh = yydh;
M_Yxydw.qymc = qymc;
M_Yxydw.zjm = zjm;
M_Yxydw.xyrx = xyrx;
M_Yxydw.xyh_inner = xyh_inner;
M_Yxydw.xydw = xydw;
M_Yxydw.nxr = nxr;
M_Yxydw.krdh = krdh;
M_Yxydw.krEmail = kremail;
M_Yxydw.krcz = krcz;
M_Yxydw.krdz = krdz;
M_Yxydw.xsy = xsy;
M_Yxydw.bz = bz;
M_Yxydw.krly = krly;
M_Yxydw.rx = rx;
M_Yxydw.xyh = xyh;
//M_Yxydw.sign_image = System.Text.Encoding.Default.GetBytes(sign_image);
M_Yxydw.sign_image = sign_image;
M_Yxydw.xsed = sxed_get;
M_Yxydw.clsj = DateTime.Now;
//M_Yxydw.is_top =is_top;
//M_Yxydw.is_select =is_select;
//int ss = B_Yxydw.Add(M_Yxydw);
if (B_Yxydw.Add(M_Yxydw) > 0)
{
s = common_file.common_app.get_suc;
}
}
else
if (add_edit_delete == common_file.common_app.get_edit)
{
M_Yxydw = B_Yxydw.GetModel(Convert.ToInt32(id));
M_Yxydw.yydh = yydh;
M_Yxydw.qymc = qymc;
M_Yxydw.zjm = zjm;
M_Yxydw.xyrx = xyrx;
M_Yxydw.xyh_inner = xyh_inner;
M_Yxydw.xydw = xydw;
M_Yxydw.nxr = nxr;
M_Yxydw.krdh = krdh;
M_Yxydw.krEmail = kremail;
M_Yxydw.krcz = krcz;
M_Yxydw.krdz = krdz;
M_Yxydw.xsy = xsy;
M_Yxydw.bz = bz;
M_Yxydw.krly = krly;
M_Yxydw.rx = rx;
M_Yxydw.xyh = xyh;
M_Yxydw.shsc = false;
M_Yxydw.id = int.Parse(id);
// M_Yxydw.sign_image = System.Text.Encoding.Default.GetBytes(sign_image);
//M_Yxydw.is_top = is_top;
//M_Yxydw.is_select = is_select;
M_Yxydw.sign_image = sign_image;
M_Yxydw.xsed = sxed_get;
if (B_Yxydw.Update(M_Yxydw))
{
s = common_file.common_app.get_suc;
}
}
else
if (add_edit_delete == common_file.common_app.get_delete)
{
if (id != "")
{
B_Yxydw.Delete(Convert.ToInt32(id));
s = common_file.common_app.get_suc;
}
}
return(s);
}
