/// <summary>
/// 得到一个对象实体
/// </summary>
public CdHotelManage.Model.FtSet GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,Lwidth,Lhieght,Lfontf,Fontsize,Lmargin,Backcolor,Bordercolor,showType,showPrice,orderLC,ftNum,zzShowType,zzShowPrice,showFormTime,showLFico,showBmico,showyjb,showday,daynum,showyue,moneyNum,showcf,showThem,Themtext,showMember,memberText,showXy,showYuli,yuliDay,showDayTime,dayNumYl,showxz,showSf,showYuee,Showzdftime,Showbooktime,Showzf,Showlc,showPeoNum,showRk,showWupi,Showyz,Showmf,Showzdf,Beiy,Beiy2,numSize,numColor,fxSize,fxColor,yueSize,yueColor,nameSize,nameColor,priceSize,priceColor,TotimeSize,TotimeColor,zdSize,zdColor,icoColor from FtSet ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
CdHotelManage.Model.FtSet model = new CdHotelManage.Model.FtSet();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CdHotelManage.Model.FtSet DataRowToModel(DataRow row)
{
CdHotelManage.Model.FtSet model = new CdHotelManage.Model.FtSet();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["Lwidth"] != null && row["Lwidth"].ToString() != "")
{
model.Lwidth = int.Parse(row["Lwidth"].ToString());
}
if (row["Lhieght"] != null && row["Lhieght"].ToString() != "")
{
model.Lhieght = int.Parse(row["Lhieght"].ToString());
}
if (row["Lfontf"] != null)
{
model.Lfontf = row["Lfontf"].ToString();
}
if (row["Fontsize"] != null && row["Fontsize"].ToString() != "")
{
model.Fontsize = int.Parse(row["Fontsize"].ToString());
}
if (row["Lmargin"] != null && row["Lmargin"].ToString() != "")
{
model.Lmargin = int.Parse(row["Lmargin"].ToString());
}
if (row["Backcolor"] != null)
{
model.Backcolor = row["Backcolor"].ToString();
}
if (row["Bordercolor"] != null)
{
model.Bordercolor = row["Bordercolor"].ToString();
}
if (row["showType"] != null && row["showType"].ToString() != "")
{
if ((row["showType"].ToString() == "1") || (row["showType"].ToString().ToLower() == "true"))
{
model.showType = true;
}
else
{
model.showType = false;
}
}
if (row["showPrice"] != null && row["showPrice"].ToString() != "")
{
if ((row["showPrice"].ToString() == "1") || (row["showPrice"].ToString().ToLower() == "true"))
{
model.showPrice = true;
}
else
{
model.showPrice = false;
}
}
if (row["orderLC"] != null && row["orderLC"].ToString() != "")
{
if ((row["orderLC"].ToString() == "1") || (row["orderLC"].ToString().ToLower() == "true"))
{
model.orderLC = true;
}
else
{
model.orderLC = false;
}
}
if (row["ftNum"] != null && row["ftNum"].ToString() != "")
{
model.ftNum = int.Parse(row["ftNum"].ToString());
}
if (row["zzShowType"] != null && row["zzShowType"].ToString() != "")
{
if ((row["zzShowType"].ToString() == "1") || (row["zzShowType"].ToString().ToLower() == "true"))
{
model.zzShowType = true;
}
else
{
model.zzShowType = false;
}
}
if (row["zzShowPrice"] != null && row["zzShowPrice"].ToString() != "")
{
if ((row["zzShowPrice"].ToString() == "1") || (row["zzShowPrice"].ToString().ToLower() == "true"))
{
model.zzShowPrice = true;
}
else
{
model.zzShowPrice = false;
}
}
if (row["showFormTime"] != null && row["showFormTime"].ToString() != "")
{
if ((row["showFormTime"].ToString() == "1") || (row["showFormTime"].ToString().ToLower() == "true"))
{
model.showFormTime = true;
}
else
{
model.showFormTime = false;
}
}
if (row["showLFico"] != null && row["showLFico"].ToString() != "")
{
if ((row["showLFico"].ToString() == "1") || (row["showLFico"].ToString().ToLower() == "true"))
{
model.showLFico = true;
}
else
{
model.showLFico = false;
}
}
if (row["showBmico"] != null && row["showBmico"].ToString() != "")
{
if ((row["showBmico"].ToString() == "1") || (row["showBmico"].ToString().ToLower() == "true"))
{
model.showBmico = true;
}
else
{
model.showBmico = false;
}
}
if (row["showyjb"] != null && row["showyjb"].ToString() != "")
{
if ((row["showyjb"].ToString() == "1") || (row["showyjb"].ToString().ToLower() == "true"))
{
model.showyjb = true;
}
else
{
model.showyjb = false;
}
}
if (row["showday"] != null && row["showday"].ToString() != "")
{
if ((row["showday"].ToString() == "1") || (row["showday"].ToString().ToLower() == "true"))
{
model.showday = true;
}
else
{
model.showday = false;
}
}
if (row["daynum"] != null && row["daynum"].ToString() != "")
{
model.daynum = int.Parse(row["daynum"].ToString());
}
if (row["showyue"] != null && row["showyue"].ToString() != "")
{
if ((row["showyue"].ToString() == "1") || (row["showyue"].ToString().ToLower() == "true"))
{
model.showyue = true;
}
else
{
model.showyue = false;
}
}
if (row["moneyNum"] != null && row["moneyNum"].ToString() != "")
{
model.moneyNum = int.Parse(row["moneyNum"].ToString());
}
if (row["showcf"] != null && row["showcf"].ToString() != "")
{
if ((row["showcf"].ToString() == "1") || (row["showcf"].ToString().ToLower() == "true"))
{
model.showcf = true;
}
else
{
model.showcf = false;
}
}
if (row["showThem"] != null && row["showThem"].ToString() != "")
{
if ((row["showThem"].ToString() == "1") || (row["showThem"].ToString().ToLower() == "true"))
{
model.showThem = true;
}
else
{
model.showThem = false;
}
}
if (row["Themtext"] != null)
{
model.Themtext = row["Themtext"].ToString();
}
if (row["showMember"] != null && row["showMember"].ToString() != "")
{
if ((row["showMember"].ToString() == "1") || (row["showMember"].ToString().ToLower() == "true"))
{
model.showMember = true;
}
else
{
model.showMember = false;
}
}
if (row["memberText"] != null)
{
model.memberText = row["memberText"].ToString();
}
if (row["showXy"] != null && row["showXy"].ToString() != "")
{
if ((row["showXy"].ToString() == "1") || (row["showXy"].ToString().ToLower() == "true"))
{
model.showXy = true;
}
else
{
model.showXy = false;
}
}
if (row["showYuli"] != null && row["showYuli"].ToString() != "")
{
if ((row["showYuli"].ToString() == "1") || (row["showYuli"].ToString().ToLower() == "true"))
{
model.showYuli = true;
}
else
{
model.showYuli = false;
}
}
if (row["yuliDay"] != null && row["yuliDay"].ToString() != "")
{
if ((row["yuliDay"].ToString() == "1") || (row["yuliDay"].ToString().ToLower() == "true"))
{
model.yuliDay = true;
}
else
{
model.yuliDay = false;
}
}
if (row["showDayTime"] != null && row["showDayTime"].ToString() != "")
{
if ((row["showDayTime"].ToString() == "1") || (row["showDayTime"].ToString().ToLower() == "true"))
{
model.showDayTime = true;
}
else
{
model.showDayTime = false;
}
}
if (row["dayNumYl"] != null && row["dayNumYl"].ToString() != "")
{
model.dayNumYl = int.Parse(row["dayNumYl"].ToString());
}
if (row["showxz"] != null && row["showxz"].ToString() != "")
{
if ((row["showxz"].ToString() == "1") || (row["showxz"].ToString().ToLower() == "true"))
{
model.showxz = true;
}
else
{
model.showxz = false;
}
}
if (row["showSf"] != null && row["showSf"].ToString() != "")
{
if ((row["showSf"].ToString() == "1") || (row["showSf"].ToString().ToLower() == "true"))
{
model.showSf = true;
}
else
{
model.showSf = false;
}
}
if (row["showYuee"] != null && row["showYuee"].ToString() != "")
{
if ((row["showYuee"].ToString() == "1") || (row["showYuee"].ToString().ToLower() == "true"))
{
model.showYuee = true;
}
else
{
model.showYuee = false;
}
}
if (row["Showzdftime"] != null && row["Showzdftime"].ToString() != "")
{
if ((row["Showzdftime"].ToString() == "1") || (row["Showzdftime"].ToString().ToLower() == "true"))
{
model.Showzdftime = true;
}
else
{
model.Showzdftime = false;
}
}
if (row["Showbooktime"] != null && row["Showbooktime"].ToString() != "")
{
if ((row["Showbooktime"].ToString() == "1") || (row["Showbooktime"].ToString().ToLower() == "true"))
{
model.Showbooktime = true;
}
else
{
model.Showbooktime = false;
}
}
if (row["Showzf"] != null && row["Showzf"].ToString() != "")
{
if ((row["Showzf"].ToString() == "1") || (row["Showzf"].ToString().ToLower() == "true"))
{
model.Showzf = true;
}
else
{
model.Showzf = false;
}
}
if (row["Showlc"] != null && row["Showlc"].ToString() != "")
{
if ((row["Showlc"].ToString() == "1") || (row["Showlc"].ToString().ToLower() == "true"))
{
model.Showlc = true;
}
else
{
model.Showlc = false;
}
}
if (row["showPeoNum"] != null && row["showPeoNum"].ToString() != "")
{
if ((row["showPeoNum"].ToString() == "1") || (row["showPeoNum"].ToString().ToLower() == "true"))
{
model.showPeoNum = true;
}
else
{
model.showPeoNum = false;
}
}
if (row["showRk"] != null && row["showRk"].ToString() != "")
{
if ((row["showRk"].ToString() == "1") || (row["showRk"].ToString().ToLower() == "true"))
{
model.showRk = true;
}
else
{
model.showRk = false;
}
}
if (row["showWupi"] != null && row["showWupi"].ToString() != "")
{
if ((row["showWupi"].ToString() == "1") || (row["showWupi"].ToString().ToLower() == "true"))
{
model.showWupi = true;
}
else
{
model.showWupi = false;
}
}
if (row["Showyz"] != null && row["Showyz"].ToString() != "")
{
if ((row["Showyz"].ToString() == "1") || (row["Showyz"].ToString().ToLower() == "true"))
{
model.Showyz = true;
}
else
{
model.Showyz = false;
}
}
if (row["Showmf"] != null && row["Showmf"].ToString() != "")
{
if ((row["Showmf"].ToString() == "1") || (row["Showmf"].ToString().ToLower() == "true"))
{
model.Showmf = true;
}
else
{
model.Showmf = false;
}
}
if (row["Showzdf"] != null && row["Showzdf"].ToString() != "")
{
if ((row["Showzdf"].ToString() == "1") || (row["Showzdf"].ToString().ToLower() == "true"))
{
model.Showzdf = true;
}
else
{
model.Showzdf = false;
}
}
if (row["Beiy"] != null && row["Beiy"].ToString() != "")
{
if ((row["Beiy"].ToString() == "1") || (row["Beiy"].ToString().ToLower() == "true"))
{
model.Beiy = true;
}
else
{
model.Beiy = false;
}
}
if (row["Beiy2"] != null && row["Beiy2"].ToString() != "")
{
if ((row["Beiy2"].ToString() == "1") || (row["Beiy2"].ToString().ToLower() == "true"))
{
model.Beiy2 = true;
}
else
{
model.Beiy2 = false;
}
}
if (row["numSize"] != null && row["numSize"].ToString() != "")
{
model.numSize = int.Parse(row["numSize"].ToString());
}
if (row["numColor"] != null)
{
model.numColor = row["numColor"].ToString();
}
if (row["fxSize"] != null && row["fxSize"].ToString() != "")
{
model.fxSize = int.Parse(row["fxSize"].ToString());
}
if (row["fxColor"] != null)
{
model.fxColor = row["fxColor"].ToString();
}
if (row["yueSize"] != null && row["yueSize"].ToString() != "")
{
model.yueSize = int.Parse(row["yueSize"].ToString());
}
if (row["yueColor"] != null)
{
model.yueColor = row["yueColor"].ToString();
}
if (row["nameSize"] != null && row["nameSize"].ToString() != "")
{
model.nameSize = int.Parse(row["nameSize"].ToString());
}
if (row["nameColor"] != null)
{
model.nameColor = row["nameColor"].ToString();
}
if (row["priceSize"] != null && row["priceSize"].ToString() != "")
{
model.priceSize = int.Parse(row["priceSize"].ToString());
}
if (row["priceColor"] != null)
{
model.priceColor = row["priceColor"].ToString();
}
if (row["TotimeSize"] != null && row["TotimeSize"].ToString() != "")
{
model.TotimeSize = int.Parse(row["TotimeSize"].ToString());
}
if (row["TotimeColor"] != null)
{
model.TotimeColor = row["TotimeColor"].ToString();
}
if (row["zdSize"] != null && row["zdSize"].ToString() != "")
{
model.zdSize = int.Parse(row["zdSize"].ToString());
}
if (row["zdColor"] != null)
{
model.zdColor = row["zdColor"].ToString();
}
if (row["icoColor"] != null && row["icoColor"].ToString() != "")
{
model.icoColor = int.Parse(row["icoColor"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(CdHotelManage.Model.FtSet model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into FtSet(");
strSql.Append("Lwidth,Lhieght,Lfontf,Fontsize,Lmargin,Backcolor,Bordercolor,showType,showPrice,orderLC,ftNum,zzShowType,zzShowPrice,showFormTime,showLFico,showBmico,showyjb,showday,daynum,showyue,moneyNum,showcf,showThem,Themtext,showMember,memberText,showXy,showYuli,yuliDay,showDayTime,dayNumYl,showxz,showSf,showYuee,Showzdftime,Showbooktime,Showzf,Showlc,showPeoNum,showRk,showWupi,Showyz,Showmf,Showzdf,Beiy,Beiy2,numSize,numColor,fxSize,fxColor,yueSize,yueColor,nameSize,nameColor,priceSize,priceColor,TotimeSize,TotimeColor,zdSize,zdColor,icoColor)");
strSql.Append(" values (");
strSql.Append("@Lwidth,@Lhieght,@Lfontf,@Fontsize,@Lmargin,@Backcolor,@Bordercolor,@showType,@showPrice,@orderLC,@ftNum,@zzShowType,@zzShowPrice,@showFormTime,@showLFico,@showBmico,@showyjb,@showday,@daynum,@showyue,@moneyNum,@showcf,@showThem,@Themtext,@showMember,@memberText,@showXy,@showYuli,@yuliDay,@showDayTime,@dayNumYl,@showxz,@showSf,@showYuee,@Showzdftime,@Showbooktime,@Showzf,@Showlc,@showPeoNum,@showRk,@showWupi,@Showyz,@Showmf,@Showzdf,@Beiy,@Beiy2,@numSize,@numColor,@fxSize,@fxColor,@yueSize,@yueColor,@nameSize,@nameColor,@priceSize,@priceColor,@TotimeSize,@TotimeColor,@zdSize,@zdColor,@icoColor)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Lwidth", SqlDbType.Int, 4),
new SqlParameter("@Lhieght", SqlDbType.Int, 4),
new SqlParameter("@Lfontf", SqlDbType.NVarChar, 50),
new SqlParameter("@Fontsize", SqlDbType.Int, 4),
new SqlParameter("@Lmargin", SqlDbType.Int, 4),
new SqlParameter("@Backcolor", SqlDbType.NVarChar, 50),
new SqlParameter("@Bordercolor", SqlDbType.NVarChar, 50),
new SqlParameter("@showType", SqlDbType.Bit, 1),
new SqlParameter("@showPrice", SqlDbType.Bit, 1),
new SqlParameter("@orderLC", SqlDbType.Bit, 1),
new SqlParameter("@ftNum", SqlDbType.Int, 4),
new SqlParameter("@zzShowType", SqlDbType.Bit, 1),
new SqlParameter("@zzShowPrice", SqlDbType.Bit, 1),
new SqlParameter("@showFormTime", SqlDbType.Bit, 1),
new SqlParameter("@showLFico", SqlDbType.Bit, 1),
new SqlParameter("@showBmico", SqlDbType.Bit, 1),
new SqlParameter("@showyjb", SqlDbType.Bit, 1),
new SqlParameter("@showday", SqlDbType.Bit, 1),
new SqlParameter("@daynum", SqlDbType.Int, 4),
new SqlParameter("@showyue", SqlDbType.Bit, 1),
new SqlParameter("@moneyNum", SqlDbType.Int, 4),
new SqlParameter("@showcf", SqlDbType.Bit, 1),
new SqlParameter("@showThem", SqlDbType.Bit, 1),
new SqlParameter("@Themtext", SqlDbType.NVarChar, 10),
new SqlParameter("@showMember", SqlDbType.Bit, 1),
new SqlParameter("@memberText", SqlDbType.NVarChar, 10),
new SqlParameter("@showXy", SqlDbType.Bit, 1),
new SqlParameter("@showYuli", SqlDbType.Bit, 1),
new SqlParameter("@yuliDay", SqlDbType.Bit, 1),
new SqlParameter("@showDayTime", SqlDbType.Bit, 1),
new SqlParameter("@dayNumYl", SqlDbType.Int, 4),
new SqlParameter("@showxz", SqlDbType.Bit, 1),
new SqlParameter("@showSf", SqlDbType.Bit, 1),
new SqlParameter("@showYuee", SqlDbType.Bit, 1),
new SqlParameter("@Showzdftime", SqlDbType.Bit, 1),
new SqlParameter("@Showbooktime", SqlDbType.Bit, 1),
new SqlParameter("@Showzf", SqlDbType.Bit, 1),
new SqlParameter("@Showlc", SqlDbType.Bit, 1),
new SqlParameter("@showPeoNum", SqlDbType.Bit, 1),
new SqlParameter("@showRk", SqlDbType.Bit, 1),
new SqlParameter("@showWupi", SqlDbType.Bit, 1),
new SqlParameter("@Showyz", SqlDbType.Bit, 1),
new SqlParameter("@Showmf", SqlDbType.Bit, 1),
new SqlParameter("@Showzdf", SqlDbType.Bit, 1),
new SqlParameter("@Beiy", SqlDbType.Bit, 1),
new SqlParameter("@Beiy2", SqlDbType.Bit, 1),
new SqlParameter("@numSize", SqlDbType.Int, 4),
new SqlParameter("@numColor", SqlDbType.NVarChar, 10),
new SqlParameter("@fxSize", SqlDbType.Int, 4),
new SqlParameter("@fxColor", SqlDbType.NVarChar, 10),
new SqlParameter("@yueSize", SqlDbType.Int, 4),
new SqlParameter("@yueColor", SqlDbType.NVarChar, 10),
new SqlParameter("@nameSize", SqlDbType.Int, 4),
new SqlParameter("@nameColor", SqlDbType.NVarChar, 10),
new SqlParameter("@priceSize", SqlDbType.Int, 4),
new SqlParameter("@priceColor", SqlDbType.NVarChar, 10),
new SqlParameter("@TotimeSize", SqlDbType.Int, 4),
new SqlParameter("@TotimeColor", SqlDbType.NVarChar, 10),
new SqlParameter("@zdSize", SqlDbType.Int, 4),
new SqlParameter("@zdColor", SqlDbType.NVarChar, 10),
new SqlParameter("@icoColor", SqlDbType.Int, 4)
};
parameters[0].Value = model.Lwidth;
parameters[1].Value = model.Lhieght;
parameters[2].Value = model.Lfontf;
parameters[3].Value = model.Fontsize;
parameters[4].Value = model.Lmargin;
parameters[5].Value = model.Backcolor;
parameters[6].Value = model.Bordercolor;
parameters[7].Value = model.showType;
parameters[8].Value = model.showPrice;
parameters[9].Value = model.orderLC;
parameters[10].Value = model.ftNum;
parameters[11].Value = model.zzShowType;
parameters[12].Value = model.zzShowPrice;
parameters[13].Value = model.showFormTime;
parameters[14].Value = model.showLFico;
parameters[15].Value = model.showBmico;
parameters[16].Value = model.showyjb;
parameters[17].Value = model.showday;
parameters[18].Value = model.daynum;
parameters[19].Value = model.showyue;
parameters[20].Value = model.moneyNum;
parameters[21].Value = model.showcf;
parameters[22].Value = model.showThem;
parameters[23].Value = model.Themtext;
parameters[24].Value = model.showMember;
parameters[25].Value = model.memberText;
parameters[26].Value = model.showXy;
parameters[27].Value = model.showYuli;
parameters[28].Value = model.yuliDay;
parameters[29].Value = model.showDayTime;
parameters[30].Value = model.dayNumYl;
parameters[31].Value = model.showxz;
parameters[32].Value = model.showSf;
parameters[33].Value = model.showYuee;
parameters[34].Value = model.Showzdftime;
parameters[35].Value = model.Showbooktime;
parameters[36].Value = model.Showzf;
parameters[37].Value = model.Showlc;
parameters[38].Value = model.showPeoNum;
parameters[39].Value = model.showRk;
parameters[40].Value = model.showWupi;
parameters[41].Value = model.Showyz;
parameters[42].Value = model.Showmf;
parameters[43].Value = model.Showzdf;
parameters[44].Value = model.Beiy;
parameters[45].Value = model.Beiy2;
parameters[46].Value = model.numSize;
parameters[47].Value = model.numColor;
parameters[48].Value = model.fxSize;
parameters[49].Value = model.fxColor;
parameters[50].Value = model.yueSize;
parameters[51].Value = model.yueColor;
parameters[52].Value = model.nameSize;
parameters[53].Value = model.nameColor;
parameters[54].Value = model.priceSize;
parameters[55].Value = model.priceColor;
parameters[56].Value = model.TotimeSize;
parameters[57].Value = model.TotimeColor;
parameters[58].Value = model.zdSize;
parameters[59].Value = model.zdColor;
parameters[60].Value = model.icoColor;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(CdHotelManage.Model.FtSet model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update FtSet set ");
strSql.Append("Lwidth=@Lwidth,");
strSql.Append("Lhieght=@Lhieght,");
strSql.Append("Lfontf=@Lfontf,");
strSql.Append("Fontsize=@Fontsize,");
strSql.Append("Lmargin=@Lmargin,");
strSql.Append("Backcolor=@Backcolor,");
strSql.Append("Bordercolor=@Bordercolor,");
strSql.Append("showType=@showType,");
strSql.Append("showPrice=@showPrice,");
strSql.Append("orderLC=@orderLC,");
strSql.Append("ftNum=@ftNum,");
strSql.Append("zzShowType=@zzShowType,");
strSql.Append("zzShowPrice=@zzShowPrice,");
strSql.Append("showFormTime=@showFormTime,");
strSql.Append("showLFico=@showLFico,");
strSql.Append("showBmico=@showBmico,");
strSql.Append("showyjb=@showyjb,");
strSql.Append("showday=@showday,");
strSql.Append("daynum=@daynum,");
strSql.Append("showyue=@showyue,");
strSql.Append("moneyNum=@moneyNum,");
strSql.Append("showcf=@showcf,");
strSql.Append("showThem=@showThem,");
strSql.Append("Themtext=@Themtext,");
strSql.Append("showMember=@showMember,");
strSql.Append("memberText=@memberText,");
strSql.Append("showXy=@showXy,");
strSql.Append("showYuli=@showYuli,");
strSql.Append("yuliDay=@yuliDay,");
strSql.Append("showDayTime=@showDayTime,");
strSql.Append("dayNumYl=@dayNumYl,");
strSql.Append("showxz=@showxz,");
strSql.Append("showSf=@showSf,");
strSql.Append("showYuee=@showYuee,");
strSql.Append("Showzdftime=@Showzdftime,");
strSql.Append("Showbooktime=@Showbooktime,");
strSql.Append("Showzf=@Showzf,");
strSql.Append("Showlc=@Showlc,");
strSql.Append("showPeoNum=@showPeoNum,");
strSql.Append("showRk=@showRk,");
strSql.Append("showWupi=@showWupi,");
strSql.Append("Showyz=@Showyz,");
strSql.Append("Showmf=@Showmf,");
strSql.Append("Showzdf=@Showzdf,");
strSql.Append("Beiy=@Beiy,");
strSql.Append("Beiy2=@Beiy2,");
strSql.Append("numSize=@numSize,");
strSql.Append("numColor=@numColor,");
strSql.Append("fxSize=@fxSize,");
strSql.Append("fxColor=@fxColor,");
strSql.Append("yueSize=@yueSize,");
strSql.Append("yueColor=@yueColor,");
strSql.Append("nameSize=@nameSize,");
strSql.Append("nameColor=@nameColor,");
strSql.Append("priceSize=@priceSize,");
strSql.Append("priceColor=@priceColor,");
strSql.Append("TotimeSize=@TotimeSize,");
strSql.Append("TotimeColor=@TotimeColor,");
strSql.Append("zdSize=@zdSize,");
strSql.Append("zdColor=@zdColor,");
strSql.Append("icoColor=@icoColor");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@Lwidth", SqlDbType.Int, 4),
new SqlParameter("@Lhieght", SqlDbType.Int, 4),
new SqlParameter("@Lfontf", SqlDbType.NVarChar, 50),
new SqlParameter("@Fontsize", SqlDbType.Int, 4),
new SqlParameter("@Lmargin", SqlDbType.Int, 4),
new SqlParameter("@Backcolor", SqlDbType.NVarChar, 50),
new SqlParameter("@Bordercolor", SqlDbType.NVarChar, 50),
new SqlParameter("@showType", SqlDbType.Bit, 1),
new SqlParameter("@showPrice", SqlDbType.Bit, 1),
new SqlParameter("@orderLC", SqlDbType.Bit, 1),
new SqlParameter("@ftNum", SqlDbType.Int, 4),
new SqlParameter("@zzShowType", SqlDbType.Bit, 1),
new SqlParameter("@zzShowPrice", SqlDbType.Bit, 1),
new SqlParameter("@showFormTime", SqlDbType.Bit, 1),
new SqlParameter("@showLFico", SqlDbType.Bit, 1),
new SqlParameter("@showBmico", SqlDbType.Bit, 1),
new SqlParameter("@showyjb", SqlDbType.Bit, 1),
new SqlParameter("@showday", SqlDbType.Bit, 1),
new SqlParameter("@daynum", SqlDbType.Int, 4),
new SqlParameter("@showyue", SqlDbType.Bit, 1),
new SqlParameter("@moneyNum", SqlDbType.Int, 4),
new SqlParameter("@showcf", SqlDbType.Bit, 1),
new SqlParameter("@showThem", SqlDbType.Bit, 1),
new SqlParameter("@Themtext", SqlDbType.NVarChar, 10),
new SqlParameter("@showMember", SqlDbType.Bit, 1),
new SqlParameter("@memberText", SqlDbType.NVarChar, 10),
new SqlParameter("@showXy", SqlDbType.Bit, 1),
new SqlParameter("@showYuli", SqlDbType.Bit, 1),
new SqlParameter("@yuliDay", SqlDbType.Bit, 1),
new SqlParameter("@showDayTime", SqlDbType.Bit, 1),
new SqlParameter("@dayNumYl", SqlDbType.Int, 4),
new SqlParameter("@showxz", SqlDbType.Bit, 1),
new SqlParameter("@showSf", SqlDbType.Bit, 1),
new SqlParameter("@showYuee", SqlDbType.Bit, 1),
new SqlParameter("@Showzdftime", SqlDbType.Bit, 1),
new SqlParameter("@Showbooktime", SqlDbType.Bit, 1),
new SqlParameter("@Showzf", SqlDbType.Bit, 1),
new SqlParameter("@Showlc", SqlDbType.Bit, 1),
new SqlParameter("@showPeoNum", SqlDbType.Bit, 1),
new SqlParameter("@showRk", SqlDbType.Bit, 1),
new SqlParameter("@showWupi", SqlDbType.Bit, 1),
new SqlParameter("@Showyz", SqlDbType.Bit, 1),
new SqlParameter("@Showmf", SqlDbType.Bit, 1),
new SqlParameter("@Showzdf", SqlDbType.Bit, 1),
new SqlParameter("@Beiy", SqlDbType.Bit, 1),
new SqlParameter("@Beiy2", SqlDbType.Bit, 1),
new SqlParameter("@numSize", SqlDbType.Int, 4),
new SqlParameter("@numColor", SqlDbType.NVarChar, 10),
new SqlParameter("@fxSize", SqlDbType.Int, 4),
new SqlParameter("@fxColor", SqlDbType.NVarChar, 10),
new SqlParameter("@yueSize", SqlDbType.Int, 4),
new SqlParameter("@yueColor", SqlDbType.NVarChar, 10),
new SqlParameter("@nameSize", SqlDbType.Int, 4),
new SqlParameter("@nameColor", SqlDbType.NVarChar, 10),
new SqlParameter("@priceSize", SqlDbType.Int, 4),
new SqlParameter("@priceColor", SqlDbType.NVarChar, 10),
new SqlParameter("@TotimeSize", SqlDbType.Int, 4),
new SqlParameter("@TotimeColor", SqlDbType.NVarChar, 10),
new SqlParameter("@zdSize", SqlDbType.Int, 4),
new SqlParameter("@zdColor", SqlDbType.NVarChar, 10),
new SqlParameter("@icoColor", SqlDbType.Int, 4),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.Lwidth;
parameters[1].Value = model.Lhieght;
parameters[2].Value = model.Lfontf;
parameters[3].Value = model.Fontsize;
parameters[4].Value = model.Lmargin;
parameters[5].Value = model.Backcolor;
parameters[6].Value = model.Bordercolor;
parameters[7].Value = model.showType;
parameters[8].Value = model.showPrice;
parameters[9].Value = model.orderLC;
parameters[10].Value = model.ftNum;
parameters[11].Value = model.zzShowType;
parameters[12].Value = model.zzShowPrice;
parameters[13].Value = model.showFormTime;
parameters[14].Value = model.showLFico;
parameters[15].Value = model.showBmico;
parameters[16].Value = model.showyjb;
parameters[17].Value = model.showday;
parameters[18].Value = model.daynum;
parameters[19].Value = model.showyue;
parameters[20].Value = model.moneyNum;
parameters[21].Value = model.showcf;
parameters[22].Value = model.showThem;
parameters[23].Value = model.Themtext;
parameters[24].Value = model.showMember;
parameters[25].Value = model.memberText;
parameters[26].Value = model.showXy;
parameters[27].Value = model.showYuli;
parameters[28].Value = model.yuliDay;
parameters[29].Value = model.showDayTime;
parameters[30].Value = model.dayNumYl;
parameters[31].Value = model.showxz;
parameters[32].Value = model.showSf;
parameters[33].Value = model.showYuee;
parameters[34].Value = model.Showzdftime;
parameters[35].Value = model.Showbooktime;
parameters[36].Value = model.Showzf;
parameters[37].Value = model.Showlc;
parameters[38].Value = model.showPeoNum;
parameters[39].Value = model.showRk;
parameters[40].Value = model.showWupi;
parameters[41].Value = model.Showyz;
parameters[42].Value = model.Showmf;
parameters[43].Value = model.Showzdf;
parameters[44].Value = model.Beiy;
parameters[45].Value = model.Beiy2;
parameters[46].Value = model.numSize;
parameters[47].Value = model.numColor;
parameters[48].Value = model.fxSize;
parameters[49].Value = model.fxColor;
parameters[50].Value = model.yueSize;
parameters[51].Value = model.yueColor;
parameters[52].Value = model.nameSize;
parameters[53].Value = model.nameColor;
parameters[54].Value = model.priceSize;
parameters[55].Value = model.priceColor;
parameters[56].Value = model.TotimeSize;
parameters[57].Value = model.TotimeColor;
parameters[58].Value = model.zdSize;
parameters[59].Value = model.zdColor;
parameters[60].Value = model.icoColor;
parameters[61].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
