/// <summary>
/// 新增主要用来增加投诉建议、修改用来增加处理意见
/// </summary>
/// <param name="yydh"></param>
/// <param name="qymc"></param>
/// <param name="lsbh"></param>
/// <param name="fjbh"></param>
/// <param name="sktt"></param>
/// <param name="krxm"></param>
/// <param name="krsj"></param>
/// <param name="zjhm"></param>
/// <param name="xyh"></param>
/// <param name="xydw"></param>
/// <param name="hykh"></param>
/// <param name="tsrx"></param>
/// <param name="tsnr"></param>
/// <param name="tssj"></param>
/// <param name="czy"></param>
/// <param name="clbm"></param>
/// <param name="clnr"></param>
/// <param name="clsj"></param>
/// <param name="cly"></param>
/// <returns></returns>
public string Qtsjy_add_edit(string id, string yydh, string qymc, string lsbh, string fjbh, string sktt, string krxm, string krsj, string zjhm, string xyh, string xydw, string hykh, string tsrx, string tsnr, DateTime tssj, string czy, string clbm, string clnr, DateTime clsj, string cly, string add_edit, string xxzs)
{
string s = common_file.common_app.get_failure;
BLL.Qtsjy B_Qtsjy = new Hotel_app.BLL.Qtsjy();
Model.Qtsjy M_Qtsjy = new Hotel_app.Model.Qtsjy();
if (add_edit == common_file.common_app.get_add)
{
M_Qtsjy.yydh = yydh; M_Qtsjy.qymc = qymc; M_Qtsjy.lsbh = lsbh;
M_Qtsjy.fjbh = fjbh; M_Qtsjy.sktt = sktt; M_Qtsjy.krxm = krxm; M_Qtsjy.krsj = krsj; M_Qtsjy.zjhm = zjhm;
M_Qtsjy.xyh = xyh; M_Qtsjy.xydw = xydw; M_Qtsjy.hykh = hykh; M_Qtsjy.tsrx = tsrx; M_Qtsjy.tsnr = tsnr;
M_Qtsjy.tssj = tssj; M_Qtsjy.czy = czy; M_Qtsjy.clbm = clbm; M_Qtsjy.clnr = clnr; M_Qtsjy.clsj = clsj;
M_Qtsjy.cly = cly;
if (B_Qtsjy.Add(M_Qtsjy) > 0)
{
s = common_file.common_app.get_suc;
}
}
else
if (add_edit == common_file.common_app.get_edit)
{
if (id != "")
{
M_Qtsjy = B_Qtsjy.GetModel(int.Parse(id));
if (M_Qtsjy != null)
{
M_Qtsjy.clbm = clbm; M_Qtsjy.clnr = clnr; M_Qtsjy.clsj = clsj;
M_Qtsjy.cly = cly;
if (B_Qtsjy.Update(M_Qtsjy) == true)
{
s = common_file.common_app.get_suc;
}
}
}
}
return(s);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hotel_app.Model.Qtsjy model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Qtsjy(");
strSql.Append("yydh,qymc,lsbh,fjbh,sktt,krxm,krsj,zjhm,xyh,xydw,hykh,tsrx,tsnr,tssj,czy,clbm,clnr,clsj,cly,is_top,is_select,shsc)");
strSql.Append(" values (");
strSql.Append("@yydh,@qymc,@lsbh,@fjbh,@sktt,@krxm,@krsj,@zjhm,@xyh,@xydw,@hykh,@tsrx,@tsnr,@tssj,@czy,@clbm,@clnr,@clsj,@cly,@is_top,@is_select,@shsc)");
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("@fjbh", SqlDbType.VarChar, 50),
new SqlParameter("@sktt", SqlDbType.VarChar, 50),
new SqlParameter("@krxm", SqlDbType.VarChar, 50),
new SqlParameter("@krsj", SqlDbType.VarChar, 50),
new SqlParameter("@zjhm", SqlDbType.VarChar, 50),
new SqlParameter("@xyh", SqlDbType.VarChar, 50),
new SqlParameter("@xydw", SqlDbType.VarChar, 500),
new SqlParameter("@hykh", SqlDbType.VarChar, 50),
new SqlParameter("@tsrx", SqlDbType.VarChar, 50),
new SqlParameter("@tsnr", SqlDbType.VarChar, 500),
new SqlParameter("@tssj", SqlDbType.DateTime),
new SqlParameter("@czy", SqlDbType.VarChar, 50),
new SqlParameter("@clbm", SqlDbType.VarChar, 50),
new SqlParameter("@clnr", SqlDbType.VarChar, 500),
new SqlParameter("@clsj", SqlDbType.DateTime),
new SqlParameter("@cly", SqlDbType.VarChar, 50),
new SqlParameter("@is_top", SqlDbType.Bit, 1),
new SqlParameter("@is_select", SqlDbType.Bit, 1),
new SqlParameter("@shsc", SqlDbType.Bit, 1)
};
parameters[0].Value = model.yydh;
parameters[1].Value = model.qymc;
parameters[2].Value = model.lsbh;
parameters[3].Value = model.fjbh;
parameters[4].Value = model.sktt;
parameters[5].Value = model.krxm;
parameters[6].Value = model.krsj;
parameters[7].Value = model.zjhm;
parameters[8].Value = model.xyh;
parameters[9].Value = model.xydw;
parameters[10].Value = model.hykh;
parameters[11].Value = model.tsrx;
parameters[12].Value = model.tsnr;
parameters[13].Value = model.tssj;
parameters[14].Value = model.czy;
parameters[15].Value = model.clbm;
parameters[16].Value = model.clnr;
parameters[17].Value = model.clsj;
parameters[18].Value = model.cly;
parameters[19].Value = model.is_top;
parameters[20].Value = model.is_select;
parameters[21].Value = model.shsc;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Hotel_app.Model.Qtsjy GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,yydh,qymc,lsbh,fjbh,sktt,krxm,krsj,zjhm,xyh,xydw,hykh,tsrx,tsnr,tssj,czy,clbm,clnr,clsj,cly,is_top,is_select,shsc from Qtsjy ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Hotel_app.Model.Qtsjy model = new Hotel_app.Model.Qtsjy();
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]["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]["krxm"] != null && ds.Tables[0].Rows[0]["krxm"].ToString() != "")
{
model.krxm = ds.Tables[0].Rows[0]["krxm"].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]["zjhm"] != null && ds.Tables[0].Rows[0]["zjhm"].ToString() != "")
{
model.zjhm = ds.Tables[0].Rows[0]["zjhm"].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]["hykh"] != null && ds.Tables[0].Rows[0]["hykh"].ToString() != "")
{
model.hykh = ds.Tables[0].Rows[0]["hykh"].ToString();
}
if (ds.Tables[0].Rows[0]["tsrx"] != null && ds.Tables[0].Rows[0]["tsrx"].ToString() != "")
{
model.tsrx = ds.Tables[0].Rows[0]["tsrx"].ToString();
}
if (ds.Tables[0].Rows[0]["tsnr"] != null && ds.Tables[0].Rows[0]["tsnr"].ToString() != "")
{
model.tsnr = ds.Tables[0].Rows[0]["tsnr"].ToString();
}
if (ds.Tables[0].Rows[0]["tssj"] != null && ds.Tables[0].Rows[0]["tssj"].ToString() != "")
{
model.tssj = DateTime.Parse(ds.Tables[0].Rows[0]["tssj"].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]["clbm"] != null && ds.Tables[0].Rows[0]["clbm"].ToString() != "")
{
model.clbm = ds.Tables[0].Rows[0]["clbm"].ToString();
}
if (ds.Tables[0].Rows[0]["clnr"] != null && ds.Tables[0].Rows[0]["clnr"].ToString() != "")
{
model.clnr = ds.Tables[0].Rows[0]["clnr"].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]["cly"] != null && ds.Tables[0].Rows[0]["cly"].ToString() != "")
{
model.cly = ds.Tables[0].Rows[0]["cly"].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]["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;
}
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Hotel_app.Model.Qtsjy model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Qtsjy set ");
strSql.Append("yydh=@yydh,");
strSql.Append("qymc=@qymc,");
strSql.Append("lsbh=@lsbh,");
strSql.Append("fjbh=@fjbh,");
strSql.Append("sktt=@sktt,");
strSql.Append("krxm=@krxm,");
strSql.Append("krsj=@krsj,");
strSql.Append("zjhm=@zjhm,");
strSql.Append("xyh=@xyh,");
strSql.Append("xydw=@xydw,");
strSql.Append("hykh=@hykh,");
strSql.Append("tsrx=@tsrx,");
strSql.Append("tsnr=@tsnr,");
strSql.Append("tssj=@tssj,");
strSql.Append("czy=@czy,");
strSql.Append("clbm=@clbm,");
strSql.Append("clnr=@clnr,");
strSql.Append("clsj=@clsj,");
strSql.Append("cly=@cly,");
strSql.Append("is_top=@is_top,");
strSql.Append("is_select=@is_select,");
strSql.Append("shsc=@shsc");
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("@fjbh", SqlDbType.VarChar, 50),
new SqlParameter("@sktt", SqlDbType.VarChar, 50),
new SqlParameter("@krxm", SqlDbType.VarChar, 50),
new SqlParameter("@krsj", SqlDbType.VarChar, 50),
new SqlParameter("@zjhm", SqlDbType.VarChar, 50),
new SqlParameter("@xyh", SqlDbType.VarChar, 50),
new SqlParameter("@xydw", SqlDbType.VarChar, 500),
new SqlParameter("@hykh", SqlDbType.VarChar, 50),
new SqlParameter("@tsrx", SqlDbType.VarChar, 50),
new SqlParameter("@tsnr", SqlDbType.VarChar, 500),
new SqlParameter("@tssj", SqlDbType.DateTime),
new SqlParameter("@czy", SqlDbType.VarChar, 50),
new SqlParameter("@clbm", SqlDbType.VarChar, 50),
new SqlParameter("@clnr", SqlDbType.VarChar, 500),
new SqlParameter("@clsj", SqlDbType.DateTime),
new SqlParameter("@cly", SqlDbType.VarChar, 50),
new SqlParameter("@is_top", SqlDbType.Bit, 1),
new SqlParameter("@is_select", SqlDbType.Bit, 1),
new SqlParameter("@shsc", SqlDbType.Bit, 1),
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.fjbh;
parameters[4].Value = model.sktt;
parameters[5].Value = model.krxm;
parameters[6].Value = model.krsj;
parameters[7].Value = model.zjhm;
parameters[8].Value = model.xyh;
parameters[9].Value = model.xydw;
parameters[10].Value = model.hykh;
parameters[11].Value = model.tsrx;
parameters[12].Value = model.tsnr;
parameters[13].Value = model.tssj;
parameters[14].Value = model.czy;
parameters[15].Value = model.clbm;
parameters[16].Value = model.clnr;
parameters[17].Value = model.clsj;
parameters[18].Value = model.cly;
parameters[19].Value = model.is_top;
parameters[20].Value = model.is_select;
parameters[21].Value = model.shsc;
parameters[22].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
