public Eyousoft_yhq.Model.Product GetModel(string ProductID)
{
Eyousoft_yhq.Model.Product model = null;
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat("SELECT *,");
strSql.AppendFormat(" (SELECT Name,FilePath,Size,IsWebImage FROM tbl_Attach WHERE ItemId='{0}' FOR XML RAW,ROOT('ROOT'))AS ComAttachXML ", ProductID);
strSql.Append(" FROM view_Product ");
strSql.Append(" where ProductID=@ProductID ");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "ProductID", System.Data.DbType.AnsiStringFixedLength, ProductID);
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
while (dr.Read())
{
model = new Eyousoft_yhq.Model.Product();
model.ProductID = ProductID;
model.ProductName = dr.GetString(dr.GetOrdinal("ProductName"));
model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType"));
model.TourDate = dr.IsDBNull(dr.GetOrdinal("TourDate")) ? null : Utils.GetDateTimeNullable(dr.GetDateTime(dr.GetOrdinal("TourDate")).ToString());
model.MarketPrice = dr.GetDecimal(dr.GetOrdinal("MarketPrice"));
model.AppPrice = dr.GetDecimal(dr.GetOrdinal("AppPrice"));
model.FavourCode = dr.GetString(dr.GetOrdinal("FavourCode"));
model.LinkTel = dr.GetString(dr.GetOrdinal("LinkTel"));
model.ProductDis = dr.GetString(dr.GetOrdinal("ProductDis"));
model.TourDis = dr.GetString(dr.GetOrdinal("TourDis"));
model.SendTourKnow = dr.GetString(dr.GetOrdinal("SendTourKnow"));
model.ValidiDate = dr.GetDateTime(dr.GetOrdinal("ValidiDate"));
//model.ProductState = dr.GetInt32(dr.GetOrdinal("ProductState"));
model.AttachList = this.GetAttachList(dr["ComAttachXML"].ToString(), ProductID);
model.IsEveryDay = dr.IsDBNull(dr.GetOrdinal("IsEveryDay")) ? false : GetBoolean(dr.GetString(dr.GetOrdinal("IsEveryDay")));
model.IsHot = dr.IsDBNull(dr.GetOrdinal("IsHot")) ? 0 : dr.GetByte(dr.GetOrdinal("IsHot"));
model.ServiceQQ = dr.IsDBNull(dr.GetOrdinal("ServiceQQ")) ? "" : dr.GetString(dr.GetOrdinal("ServiceQQ"));
model.ContractType = (Eyousoft_yhq.Model.ContractType)dr.GetByte(dr.GetOrdinal("ContractType"));
model.ControlPeople = dr.GetInt32(dr.GetOrdinal("ControlPeople"));
model.ResidueNum = dr.GetInt32(dr.GetOrdinal("ResidueNum"));
model.SaleNum = dr.GetInt32(dr.GetOrdinal("SaleNum"));
model.ProductOpState = (Eyousoft_yhq.Model.ProductOp)dr.GetByte(dr.GetOrdinal("ProductOpState"));
model.ProductSdate = dr.IsDBNull(dr.GetOrdinal("ProductSdate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ProductSdate"));
model.ZCodeViaDate = dr.IsDBNull(dr.GetOrdinal("ZCodeViaDate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ZCodeViaDate"));
model.PType = dr.IsDBNull(dr.GetOrdinal("PType")) ? 1 : dr.GetInt32(dr.GetOrdinal("PType"));
model.Scompare = dr.IsDBNull(dr.GetOrdinal("Scompare")) ? "" : dr.GetString(dr.GetOrdinal("Scompare"));
model.FaBuRenId = dr["FaBuRenId"].ToString();
model.ShenHeStatus = (Eyousoft_yhq.Model.ChanPinShenHeStatus)dr.GetInt32(dr.GetOrdinal("ShenHeStatus"));
}
}
return(model);
}
/// <summary>
/// 判断微信码是否可用
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Exists(Eyousoft_yhq.Model.Product model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from tbl_Product");
strSql.Append(" where FavourCode=@FavourCode and DATEDIFF(day,@ValidiDate,GETDATE())<0");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "FavourCode", System.Data.DbType.String, model.FavourCode);
this._db.AddInParameter(cmd, "ValidiDate", System.Data.DbType.DateTime, model.ValidiDate);
return(Convert.ToInt32(DbHelper.GetSingle(cmd, this._db)) > 1 ? true : false);
}
/// <summary>
/// 初始化页面
/// </summary>
/// <param name="id">产品编号</param>
protected void pageInit(string id)
{
var model = EyouSoft.Common.Page.HuiyuanPage.GetUserInfo();
if (model != null)
{
hybh = model.UserID;
}
Eyousoft_yhq.BLL.Product bll = new Eyousoft_yhq.BLL.Product();
gModel = new Eyousoft_yhq.Model.Product();
gModel = bll.GetModel(id);
if (gModel != null)
{
lbl_ProName.Text = gModel.ProductName;
shichangjia = gModel.MarketPrice.ToString("C0");
appjia = gModel.AppPrice.ToString("C0");
dianhua = gModel.LinkTel;
descript = Utils.GetText2(gModel.ProductDis, 30, true);
//Lit_chutuan.Text = gModel.SendTourKnow.Replace("\n", "<br/>");
//Lit_conpair.Text = gModel.Scompare.Replace("\n", "<br/>");
//Lit_xingcheng.Text = gModel.TourDis.Replace("\n", "<br/>");
//Lit_jieshao.Text = gModel.ProductDis.Replace("\n", "<br/>");
yhm = gModel.FavourCode;
pinglunshu = new Eyousoft_yhq.BLL.Comment().GetCountNum(gModel.ProductID).ToString();
if (DateTime.Compare(DateTime.Now, Utils.GetDateTime(gModel.ValidiDate.ToString())) > 0 && !gModel.IsEveryDay)
{
spanResult.Visible = false;
}
switch (gModel.PType)
{
case 2:
lit_Menu.Text = string.Format("<div class=\"pro_content\"> <h3><ul class=\"tiaozheng\"><li li_index=\"1\" class=\"active\">产品介绍</li><li li_index=\"2\">使用须知</li></ul></h3><div class=\"contentbox\"><div>{0}</div><div style=\"display: none\">{1}</div> </div><div><img src=\"/images/pro_b.png\" width=\"300\"></div></div>", gModel.ProductDis.Replace("\n", "<br/>"), gModel.SendTourKnow.Replace("\n", "<br/>"));
break;
case 3:
lit_Menu.Text = string.Format("<div class=\"pro_content\"> <h3><ul class=\"tiaozheng\"><li li_index=\"1\" class=\"active\">产品介绍</li><li li_index=\"2\">使用须知</li></ul></h3><div class=\"contentbox\"><div>{0}</div><div style=\"display: none\">{1}</div> </div><div><img src=\"/images/pro_b.png\" width=\"300\"></div></div>", gModel.ProductDis.Replace("\n", "<br/>"), gModel.SendTourKnow.Replace("\n", "<br/>"));
break;
default:
lit_Menu.Text = string.Format("<div class=\"pro_content\"> <h3><ul class=\"tiaozheng\"><li li_index=\"1\" class=\"active\">产品介绍</li><li li_index=\"2\">参考行程</li><li li_index=\"3\">出团须知</li><li li_index=\"4\">同类比较</li></ul></h3><div class=\"contentbox\"><div>{0}</div><div style=\"display: none\">{1}</div> <div style=\"display: none\">{2}</div><div style=\"display: none\">{3}</div></div><div><img src=\"/images/pro_b.png\" width=\"300\"></div></div>", gModel.ProductDis.Replace("\n", "<br/>"), gModel.TourDis.Replace("\n", "<br/>"), gModel.SendTourKnow.Replace("\n", "<br/>"), gModel.Scompare);
break;
}
}
else
{
lit_Menu.Text = string.Format("<div class=\"pro_content\"> <h3><ul class=\"tiaozheng\"><li li_index=\"1\" class=\"active\">产品介绍</li><li li_index=\"2\">参考行程</li><li li_index=\"3\">出团须知</li><li li_index=\"4\">同类比较</li></ul></h3><div class=\"contentbox\"><div></div><div style=\"display: none\"></div> <div style=\"display: none\"></div><div style=\"display: none\"></div></div><div><img src=\"/images/pro_b.png\" width=\"300\"></div></div>");
}
}
/// <summary>
/// 初始化页面
/// </summary>
/// <param name="id">产品编号</param>
protected void pageInit(string id)
{
var model = EyouSoft.Common.Page.HuiyuanPage.GetUserInfo();
if (model != null)
{
hybh = model.UserID;
}
Eyousoft_yhq.BLL.Product bll = new Eyousoft_yhq.BLL.Product();
gModel = new Eyousoft_yhq.Model.Product();
gModel = bll.GetModel(id);
if (gModel != null)
{
lbl_ProName.Text = gModel.ProductName;
shichangjia = gModel.MarketPrice.ToString("C0");
appjia = gModel.AppPrice.ToString("C0");
dianhua = gModel.LinkTel;
descript = Utils.GetText2(gModel.ProductDis, 30, true);
//Lit_chutuan.Text = gModel.SendTourKnow.Replace("\n", "<br/>");
//Lit_conpair.Text = gModel.Scompare.Replace("\n", "<br/>");
//Lit_xingcheng.Text = gModel.TourDis.Replace("\n", "<br/>");
//Lit_jieshao.Text = gModel.ProductDis.Replace("\n", "<br/>");
yhm = gModel.FavourCode;
pinglunshu = new Eyousoft_yhq.BLL.Comment().GetCountNum(gModel.ProductID).ToString();
if (DateTime.Compare(DateTime.Now, Utils.GetDateTime(gModel.ValidiDate.ToString())) > 0 && !gModel.IsEveryDay)
{
spanResult.Visible = false;
}
switch (gModel.PType)
{
case 2:
lit_Menu.Text = string.Format("<div class=\"pro_content\"> <h3><ul class=\"tiaozheng\"><li li_index=\"1\" class=\"active\">产品介绍</li><li li_index=\"2\">使用须知</li></ul></h3><div class=\"contentbox\"><div>{0}</div><div style=\"display: none\">{1}</div> </div><div><img src=\"/images/pro_b.png\" width=\"300\"></div></div>", gModel.ProductDis.Replace("\n", "<br/>"), gModel.SendTourKnow.Replace("\n", "<br/>"));
break;
case 3:
lit_Menu.Text = string.Format("<div class=\"pro_content\"> <h3><ul class=\"tiaozheng\"><li li_index=\"1\" class=\"active\">产品介绍</li><li li_index=\"2\">使用须知</li></ul></h3><div class=\"contentbox\"><div>{0}</div><div style=\"display: none\">{1}</div> </div><div><img src=\"/images/pro_b.png\" width=\"300\"></div></div>", gModel.ProductDis.Replace("\n", "<br/>"), gModel.SendTourKnow.Replace("\n", "<br/>"));
break;
default:
lit_Menu.Text = string.Format("<div class=\"pro_content\"> <h3><ul class=\"tiaozheng\"><li li_index=\"1\" class=\"active\">产品介绍</li><li li_index=\"2\">参考行程</li><li li_index=\"3\">出团须知</li><li li_index=\"4\">同类比较</li></ul></h3><div class=\"contentbox\"><div>{0}</div><div style=\"display: none\">{1}</div> <div style=\"display: none\">{2}</div><div style=\"display: none\">{3}</div></div><div><img src=\"/images/pro_b.png\" width=\"300\"></div></div>", gModel.ProductDis.Replace("\n", "<br/>"), gModel.TourDis.Replace("\n", "<br/>"), gModel.SendTourKnow.Replace("\n", "<br/>"), gModel.Scompare);
break;
}
}
else
{
lit_Menu.Text = string.Format("<div class=\"pro_content\"> <h3><ul class=\"tiaozheng\"><li li_index=\"1\" class=\"active\">产品介绍</li><li li_index=\"2\">参考行程</li><li li_index=\"3\">出团须知</li><li li_index=\"4\">同类比较</li></ul></h3><div class=\"contentbox\"><div></div><div style=\"display: none\"></div> <div style=\"display: none\"></div><div style=\"display: none\"></div></div><div><img src=\"/images/pro_b.png\" width=\"300\"></div></div>");
}
}
/// <summary>
/// 产品添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(Eyousoft_yhq.Model.Product model)
{
DbCommand cmd = this._db.GetStoredProcCommand("Proc_Product_Add");
_db.AddInParameter(cmd, "ProductID", DbType.String, model.ProductID);
_db.AddInParameter(cmd, "ProductName", DbType.String, model.ProductName);
_db.AddInParameter(cmd, "ProductType", DbType.Int32, model.ProductType);
_db.AddInParameter(cmd, "TourDate", DbType.DateTime, model.TourDate);
_db.AddInParameter(cmd, "MarketPrice", DbType.Decimal, model.MarketPrice);
_db.AddInParameter(cmd, "AppPrice", DbType.Decimal, model.AppPrice);
_db.AddInParameter(cmd, "FavourCode", DbType.String, model.FavourCode);
_db.AddInParameter(cmd, "LinkTel", DbType.String, model.LinkTel);
_db.AddInParameter(cmd, "ProductDis", DbType.String, model.ProductDis);
_db.AddInParameter(cmd, "TourDis", DbType.String, model.TourDis);
_db.AddInParameter(cmd, "SendTourKnow", DbType.String, model.SendTourKnow);
_db.AddInParameter(cmd, "ValidiDate", DbType.String, model.ValidiDate);
_db.AddInParameter(cmd, "ProductState", DbType.Byte, model.ProductState);
_db.AddInParameter(cmd, "ComAttachXML", DbType.Xml, CreateComNoticeXML(model.AttachList));
_db.AddInParameter(cmd, "IsEveryDay", DbType.Byte, model.IsEveryDay);
_db.AddInParameter(cmd, "IsHot", DbType.Int32, model.IsHot);
_db.AddInParameter(cmd, "ServiceQQ", DbType.String, model.ServiceQQ);
_db.AddInParameter(cmd, "ContractType", DbType.Byte, (int)model.ContractType);
_db.AddInParameter(cmd, "ControlPeople", DbType.Int32, model.ControlPeople);
_db.AddInParameter(cmd, "Scompare", DbType.String, model.Scompare);
#region 车票 门票修改
_db.AddInParameter(cmd, "ProductOpState", DbType.Byte, model.ProductOpState);
_db.AddInParameter(cmd, "ProductSdate", DbType.DateTime, model.ProductSdate);
_db.AddInParameter(cmd, "ZCodeViaDate", DbType.DateTime, model.ZCodeViaDate);
_db.AddInParameter(cmd, "PType", DbType.Int32, model.PType);
#endregion
this._db.AddOutParameter(cmd, "result", DbType.Int32, 4);
_db.AddInParameter(cmd, "FaBuRenId", DbType.AnsiStringFixedLength, model.FaBuRenId);
_db.AddInParameter(cmd, "ShenHeStatus", DbType.Int32, model.ShenHeStatus);
DbHelper.RunProcedureWithResult(cmd, this._db);
return(Convert.ToInt32(this._db.GetParameterValue(cmd, "Result")) > 0 ? true : false);
}
protected void pageSave(string doType)
{
string id = Utils.GetQueryStringValue("id");
var model = new Eyousoft_yhq.Model.Product();
#region 实体赋值
model.ProductName = Utils.GetFormValue(txtproductName.UniqueID);
model.ProductType = 0;
model.TourDate = Utils.GetDateTimeNullable(Utils.GetFormValue(txtsendDate.UniqueID));
model.MarketPrice = Utils.GetDecimal(Utils.GetFormValue(txtmarkPrice.UniqueID));
model.AppPrice = Utils.GetDecimal(Utils.GetFormValue(txtappPrice.UniqueID));
//model.FavourCode = Utils.GetFormValue(txtcoupons.UniqueID);
model.LinkTel = Utils.GetFormValue(txttel.UniqueID);
model.ProductDis = Utils.GetFormValue(txtdescript.UniqueID);
model.TourDis = Utils.GetFormValue(txtStation.UniqueID);
model.SendTourKnow = Utils.GetFormValue(txtjoury.UniqueID);
model.ValidiDate = Utils.GetDateTime(Utils.GetFormValue(txtValidate.UniqueID));
model.ProductState = 0;
model.AttachList = NewGetAttach();
model.IsEveryDay = false;
model.IsHot = 0;
model.ServiceQQ = Utils.GetFormValue(txtkfqq.UniqueID);
model.ContractType = Model.ContractType.车票;
model.ControlPeople = Utils.GetInt(Utils.GetFormValue(txtPeopleNum.UniqueID));
model.FavourCode = Utils.GetFormValue(txtWXcode.UniqueID);
model.ProductSdate = Utils.GetDateTime(Utils.GetFormValue(txtsendsDate.UniqueID));
model.ProductOpState = (Model.ProductOp)Utils.GetInt(Utils.GetFormValue(ddl_proType.UniqueID));
model.ZCodeViaDate = Utils.GetDateTime(Utils.GetFormValue(txtZxingdate.UniqueID));
model.PType = 3;
#endregion
cn.myvo.smc.Service sms = new cn.myvo.smc.Service();
string IsContact = sms.IsIncludeKeyWord(model.ProductName);
#region 提交保存
bool result = false;
string msg = "";
if (string.IsNullOrEmpty(IsContact))
{
Response.Clear();
Eyousoft_yhq.BLL.Product BLL = new Eyousoft_yhq.BLL.Product();
if (doType == "add")
{
result = BLL.Add(model);
msg = result ? "添加成功！" : "添加失败！";
Response.Write(UtilsCommons.AjaxReturnJson(result ? "1" : "0", msg));
}
else
{
model.ProductID = id;
result = BLL.Update(model);
msg = result ? "修改成功！" : "修改失败！";
Response.Write(UtilsCommons.AjaxReturnJson(result ? "1" : "0", msg));
}
Response.End();
}
else
{
msg = "产品名称包含敏感字符[" + IsContact + "]，请修改后再保存！";
Response.Clear();
Response.Write(UtilsCommons.AjaxReturnJson(result ? "1" : "0", msg));
Response.End();
}
#endregion
}
protected void pageSave(string doType)
{
string id = Utils.GetQueryStringValue("id");
var model = new Eyousoft_yhq.Model.Product();
#region 实体赋值
model.ProductName = Utils.GetFormValue(txtproductName.UniqueID);
model.ProductType = Utils.GetInt(Utils.GetFormValue(ddltype.UniqueID));
model.TourDate = Utils.GetDateTimeNullable(Utils.GetFormValue(txtsendDate.UniqueID));
model.MarketPrice = Utils.GetDecimal(Utils.GetFormValue(txtmarkPrice.UniqueID));
model.AppPrice = Utils.GetDecimal(Utils.GetFormValue(txtappPrice.UniqueID));
model.LinkTel = Utils.GetFormValue(txttel.UniqueID);
model.ProductDis = Utils.GetFormValue(txtdescript.UniqueID);
model.TourDis = Utils.GetFormValue(txtjoury.UniqueID);
model.SendTourKnow = Utils.GetFormValue(txtsendMark.UniqueID);
model.Scompare = Utils.GetFormValue(txtScompare.UniqueID);
model.ValidiDate = Utils.GetDateTime(Utils.GetFormValue(txtValidate.UniqueID));
model.ProductState = 0;
model.AttachList = NewGetAttach();
model.IsEveryDay = Utils.GetFormValue("isEvery") == "1" ? true : false;
model.IsHot = Utils.GetInt(Utils.GetFormValue(ddl_isHot.UniqueID));
model.ServiceQQ = Utils.GetFormValue(txtkfqq.UniqueID);
model.ContractType = (Model.ContractType)Utils.GetInt(Utils.GetFormValue(ddl_contact.UniqueID));
model.ControlPeople = Utils.GetInt(Utils.GetFormValue(txtPeopleNum.UniqueID));
model.ProductOpState = (Model.ProductOp)Utils.GetInt(Utils.GetFormValue(ddl_proType.UniqueID));
model.ZCodeViaDate = Utils.GetDateTime(Utils.GetFormValue(txtZxingdate.UniqueID));
model.PType = 1;
model.ProductSdate = DateTime.Now;
model.FavourCode = Utils.GetFormValue(txtWXcode.UniqueID);
model.FaBuRenId = HuiYuanInfo.UserId;
model.ShenHeStatus = Eyousoft_yhq.Model.ChanPinShenHeStatus.已审核;
if (HuiYuanInfo.LeiXing == Eyousoft_yhq.Model.WebmasterLeiXing.供应商)
{
model.ShenHeStatus = Eyousoft_yhq.Model.ChanPinShenHeStatus.未审核;
}
#endregion
if (new Eyousoft_yhq.BLL.Product().Exists(model))
{
Response.Clear();
Response.Write(UtilsCommons.AjaxReturnJson("0", "此微信码已被使用"));
Response.End();
}
cn.myvo.smc.Service sms = new cn.myvo.smc.Service();
string IsContact = sms.IsIncludeKeyWord(model.ProductName);
#region 提交保存
bool result = false;
string msg = "";
if (string.IsNullOrEmpty(IsContact))
{
Response.Clear();
Eyousoft_yhq.BLL.Product BLL = new Eyousoft_yhq.BLL.Product();
if (doType == "add")
{
result = BLL.Add(model);
msg = result ? "添加成功！" : "添加失败！";
Response.Write(UtilsCommons.AjaxReturnJson(result ? "1" : "0", msg));
}
else
{
model.ProductID = id;
result = BLL.Update(model);
msg = result ? "修改成功！" : "修改失败！";
Response.Write(UtilsCommons.AjaxReturnJson(result ? "1" : "0", msg));
}
Response.End();
}
else
{
msg = "产品名称包含敏感字符[" + IsContact + "]，请修改后再保存！";
Response.Clear();
Response.Write(UtilsCommons.AjaxReturnJson(result ? "1" : "0", msg));
Response.End();
}
#endregion
}
protected void pageSave(string doType)
{
string id = Utils.GetQueryStringValue("id");
var model = new Eyousoft_yhq.Model.Product();
#region 实体赋值
model.ProductName = Utils.GetFormValue(txtproductName.UniqueID);
model.ProductType = Utils.GetInt(Utils.GetFormValue(ddltype.UniqueID));
model.TourDate = Utils.GetDateTimeNullable(Utils.GetFormValue(txtsendDate.UniqueID));
model.MarketPrice = Utils.GetDecimal(Utils.GetFormValue(txtmarkPrice.UniqueID));
model.AppPrice = Utils.GetDecimal(Utils.GetFormValue(txtappPrice.UniqueID));
model.LinkTel = Utils.GetFormValue(txttel.UniqueID);
model.ProductDis = Utils.GetFormValue(txtdescript.UniqueID);
model.TourDis = Utils.GetFormValue(txtjoury.UniqueID);
model.SendTourKnow = Utils.GetFormValue(txtsendMark.UniqueID);
model.Scompare = Utils.GetFormValue(txtScompare.UniqueID);
model.ValidiDate = Utils.GetDateTime(Utils.GetFormValue(txtValidate.UniqueID));
model.ProductState = 0;
model.AttachList = NewGetAttach();
model.IsEveryDay = Utils.GetFormValue("isEvery") == "1" ? true : false;
model.IsHot = Utils.GetInt(Utils.GetFormValue(ddl_isHot.UniqueID));
model.ServiceQQ = Utils.GetFormValue(txtkfqq.UniqueID);
model.ContractType = (Model.ContractType)Utils.GetInt(Utils.GetFormValue(ddl_contact.UniqueID));
model.ControlPeople = Utils.GetInt(Utils.GetFormValue(txtPeopleNum.UniqueID));
model.ProductOpState = (Model.ProductOp)Utils.GetInt(Utils.GetFormValue(ddl_proType.UniqueID));
model.ZCodeViaDate = Utils.GetDateTime(Utils.GetFormValue(txtZxingdate.UniqueID));
model.PType = 1;
model.ProductSdate = DateTime.Now;
model.FavourCode = Utils.GetFormValue(txtWXcode.UniqueID);
model.FaBuRenId = HuiYuanInfo.UserId;
model.ShenHeStatus = Eyousoft_yhq.Model.ChanPinShenHeStatus.已审核;
if (HuiYuanInfo.LeiXing == Eyousoft_yhq.Model.WebmasterLeiXing.供应商)
{
model.ShenHeStatus = Eyousoft_yhq.Model.ChanPinShenHeStatus.未审核;
}
#endregion
if (new Eyousoft_yhq.BLL.Product().Exists(model))
{
Response.Clear();
Response.Write(UtilsCommons.AjaxReturnJson("0", "此微信码已被使用"));
Response.End();
}
cn.myvo.smc.Service sms = new cn.myvo.smc.Service();
string IsContact = sms.IsIncludeKeyWord(model.ProductName);
#region 提交保存
bool result = false;
string msg = "";
if (string.IsNullOrEmpty(IsContact))
{
Response.Clear();
Eyousoft_yhq.BLL.Product BLL = new Eyousoft_yhq.BLL.Product();
if (doType == "add")
{
result = BLL.Add(model);
msg = result ? "添加成功！" : "添加失败！";
Response.Write(UtilsCommons.AjaxReturnJson(result ? "1" : "0", msg));
}
else
{
model.ProductID = id;
result = BLL.Update(model);
msg = result ? "修改成功！" : "修改失败！";
Response.Write(UtilsCommons.AjaxReturnJson(result ? "1" : "0", msg));
}
Response.End();
}
else
{
msg = "产品名称包含敏感字符[" + IsContact + "]，请修改后再保存！";
Response.Clear();
Response.Write(UtilsCommons.AjaxReturnJson(result ? "1" : "0", msg));
Response.End();
}
#endregion
}
protected void pageSave(string doType)
{
string id = Utils.GetQueryStringValue("id");
var model = new Eyousoft_yhq.Model.Product();
#region 实体赋值
model.ProductName = Utils.GetFormValue(txtproductName.UniqueID);
model.ProductType = 0;
model.TourDate = Utils.GetDateTimeNullable(Utils.GetFormValue(txtsendDate.UniqueID));
model.MarketPrice = Utils.GetDecimal(Utils.GetFormValue(txtmarkPrice.UniqueID));
model.AppPrice = Utils.GetDecimal(Utils.GetFormValue(txtappPrice.UniqueID));
//model.FavourCode = Utils.GetFormValue(txtcoupons.UniqueID);
model.FavourCode = Utils.GetFormValue(txtWXcode.UniqueID);
model.LinkTel = Utils.GetFormValue(txttel.UniqueID);
model.ProductDis = Utils.GetFormValue(txtdescript.UniqueID);
model.TourDis = Utils.GetFormValue(txtStation.UniqueID);
model.SendTourKnow = Utils.GetFormValue(txtjoury.UniqueID);
model.ValidiDate = Utils.GetDateTime(Utils.GetFormValue(txtValidate.UniqueID));
model.ProductState = 0;
model.AttachList = NewGetAttach();
model.IsEveryDay = false;
model.IsHot = 0;
model.ServiceQQ = Utils.GetFormValue(txtkfqq.UniqueID);
model.ContractType = Model.ContractType.车票;
model.ControlPeople = Utils.GetInt(Utils.GetFormValue(txtPeopleNum.UniqueID));
model.ProductSdate = Utils.GetDateTime(Utils.GetFormValue(txtsendsDate.UniqueID));
model.ProductOpState = (Model.ProductOp)Utils.GetInt(Utils.GetFormValue(ddl_proType.UniqueID));
model.ZCodeViaDate = Utils.GetDateTime(Utils.GetFormValue(txtZxingdate.UniqueID));
model.PType = 2;
#endregion
cn.myvo.smc.Service sms = new cn.myvo.smc.Service();
string IsContact = sms.IsIncludeKeyWord(model.ProductName);
#region 提交保存
bool result = false;
string msg = "";
if (string.IsNullOrEmpty(IsContact))
{
Response.Clear();
Eyousoft_yhq.BLL.Product BLL = new Eyousoft_yhq.BLL.Product();
if (doType == "add")
{
result = BLL.Add(model);
msg = result ? "添加成功！" : "添加失败！";
Response.Write(UtilsCommons.AjaxReturnJson(result ? "1" : "0", msg));
}
else
{
model.ProductID = id;
result = BLL.Update(model);
msg = result ? "修改成功！" : "修改失败！";
Response.Write(UtilsCommons.AjaxReturnJson(result ? "1" : "0", msg));
}
Response.End();
}
else
{
msg = "产品名称包含敏感字符[" + IsContact + "]，请修改后再保存！";
Response.Clear();
Response.Write(UtilsCommons.AjaxReturnJson(result ? "1" : "0", msg));
Response.End();
}
#endregion
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="serModel"></param>
/// <returns></returns>
public IList <Eyousoft_yhq.Model.Product> GetList(Eyousoft_yhq.Model.SerProduct serModel)
{
IList <Eyousoft_yhq.Model.Product> list = new List <Eyousoft_yhq.Model.Product>();
StringBuilder strSql = new StringBuilder();
strSql.Append("select ProductID,ProductName,ProductType,TourDate,MarketPrice,AppPrice,FavourCode,LinkTel,ProductDis,TourDis,SendTourKnow,ValidiDate,IsEveryDay,IsHot,CreateDate,ServiceQQ, ContractType,ControlPeople,ResidueNum,ProductOpState,ProductSdate,ZCodeViaDate,PType,XianLu ");
strSql.AppendFormat(" from view_Product where 1=1 and ProductState=0 AND datediff(day,'{0}',ValidiDate)>=0 ", DateTime.Now);
if (serModel != null)
{
if (serModel.PType > 0)
{
strSql.AppendFormat(" and PType = {0} ", serModel.PType);
}
if (!string.IsNullOrEmpty(serModel.PurductName))
{
strSql.AppendFormat(" and ProductName like '%{0}%' ", serModel.PurductName);
}
if (!string.IsNullOrEmpty(serModel.FavourCode))
{
strSql.AppendFormat(" and FavourCode = '{0}' ", serModel.FavourCode);
}
}
strSql.Append(" order by IsHot DESC, CreateDate DESC ");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
while (dr.Read())
{
Eyousoft_yhq.Model.Product model = new Eyousoft_yhq.Model.Product();
model.ProductID = dr.GetString(dr.GetOrdinal("ProductID"));;
model.ProductName = dr.GetString(dr.GetOrdinal("ProductName"));
model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType"));
model.TourDate = dr.IsDBNull(dr.GetOrdinal("TourDate")) ? null : Utils.GetDateTimeNullable(dr.GetDateTime(dr.GetOrdinal("TourDate")).ToString());
model.MarketPrice = dr.GetDecimal(dr.GetOrdinal("MarketPrice"));
model.AppPrice = dr.GetDecimal(dr.GetOrdinal("AppPrice"));
model.FavourCode = dr.GetString(dr.GetOrdinal("FavourCode"));
model.LinkTel = dr.GetString(dr.GetOrdinal("LinkTel"));
model.ProductDis = dr.GetString(dr.GetOrdinal("ProductDis"));
model.TourDis = dr.GetString(dr.GetOrdinal("TourDis"));
model.SendTourKnow = dr.GetString(dr.GetOrdinal("SendTourKnow"));
model.ValidiDate = dr.GetDateTime(dr.GetOrdinal("ValidiDate"));
//model.ProductState = dr.GetInt32(dr.GetOrdinal("ProductState"));
model.IsEveryDay = dr.IsDBNull(dr.GetOrdinal("IsEveryDay")) ? false : GetBoolean(dr.GetString(dr.GetOrdinal("IsEveryDay")));
model.IsHot = dr.IsDBNull(dr.GetOrdinal("IsHot")) ? 0 : dr.GetByte(dr.GetOrdinal("IsHot"));
model.CreateDate = dr.GetDateTime(dr.GetOrdinal("CreateDate"));
model.ServiceQQ = dr.IsDBNull(dr.GetOrdinal("ServiceQQ")) ? "" : dr.GetString(dr.GetOrdinal("ServiceQQ"));
model.ContractType = (Eyousoft_yhq.Model.ContractType)dr.GetByte(dr.GetOrdinal("ContractType"));
model.ControlPeople = dr.GetInt32(dr.GetOrdinal("ControlPeople"));
model.ResidueNum = dr.GetInt32(dr.GetOrdinal("ResidueNum"));
model.ProductSdate = dr.IsDBNull(dr.GetOrdinal("ProductSdate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ProductSdate"));
model.ZCodeViaDate = dr.IsDBNull(dr.GetOrdinal("ZCodeViaDate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ZCodeViaDate"));
model.xianlu = (Eyousoft_yhq.Model.XianLu)dr.GetByte(dr.GetOrdinal("XianLu"));
list.Add(model);
}
}
return(list);
}
public IList <Eyousoft_yhq.Model.Product> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.SerProduct serModel)
{
IList <Eyousoft_yhq.Model.Product> list = new List <Eyousoft_yhq.Model.Product>();
string tableName = "view_Product";
string fileds = " * ";
string orderByString = "";
StringBuilder query = new StringBuilder();
query.Append(" 1=1 ");
if (serModel != null)
{
#region 排序
if (serModel.SFTJ == 1)
{
orderByString += " IsHot DESC,";
}
if (serModel.DDXL == 1)
{
orderByString += "SaleNum DESC,";
}
if (serModel.DDXL == 2)
{
orderByString += "SaleNum ASC,";
}
if (serModel.SJPX == 1)
{
orderByString += "CreateDate DESC,";
}
else if (serModel.SJPX == 2)
{
orderByString += "CreateDate ASC,";
}
if (serModel.JGPX == 1)
{
orderByString += "AppPrice DESC,";
}
if (serModel.JGPX == 2)
{
orderByString += "AppPrice ASC,";
}
if (!string.IsNullOrEmpty(orderByString))
{
orderByString = orderByString.TrimEnd(',');
}
else
{
orderByString = "IsHot DESC,CreateDate desc";
}
#endregion
if (!string.IsNullOrEmpty(serModel.FavourCode))
{
query.AppendFormat(" and (FavourCode = '{0}' )", serModel.FavourCode);
}
if (serModel.PType > 0)
{
query.AppendFormat(" and (PType = {0} )", serModel.PType);
}
if (serModel.IsAdmin != "1" && !string.IsNullOrEmpty(serModel.AdminName))
{
query.AppendFormat(" and ( charindex('{0}',[AdminName])>0 or AdminName is null)", serModel.AdminName);
}
if (!string.IsNullOrEmpty(serModel.PurductName))
{
query.AppendFormat(" and ProductName like '%{0}%' ", serModel.PurductName);
}
if (!string.IsNullOrEmpty(serModel.PurductType) && serModel.PurductType != "0")
{
query.AppendFormat(" and ProductType = '{0}' ", serModel.PurductType);
}
if (!string.IsNullOrEmpty(serModel.PurductState) && serModel.PurductState != "2")
{
query.AppendFormat(" and ProductState = '{0}' ", serModel.PurductState);
}
if (serModel.Stime.HasValue)
{
query.AppendFormat(" AND datediff(day,'{0}',ValidiDate)>=0 ", serModel.Stime.Value);
}
if (serModel.Etime.HasValue)
{
query.AppendFormat(" AND datediff(day,'{0}',ValidiDate)< 0 ", serModel.Etime.Value.AddDays(1));
}
if (!serModel.isVisable)
{
query.AppendFormat(" AND ProductState = 0 ");
}
if (serModel.isHot.HasValue && serModel.isHot == 1)
{
query.AppendFormat(" and IsHot = '{0}' ", serModel.isHot);
}
else if (serModel.isHot.HasValue && serModel.isHot == 0)
{
query.AppendFormat(" and (IsHot = '{0}' or IsHot is null) ", serModel.isHot);
}
if (serModel.xianlu != null && serModel.PType == 1)
{
query.AppendFormat(" and XianLu = '{0}' ", (int)serModel.xianlu);
}
if (!string.IsNullOrEmpty(serModel.WeiDianId))
{
query.AppendFormat(" AND EXISTS(SELECT 1 FROM tbl_WeiDianChanPinGuanXi AS A1 WHERE A1.ChanPinId=view_Product.ProductID AND A1.WeiDianId='{0}') ", serModel.WeiDianId);
}
if (!string.IsNullOrEmpty(serModel.FaBuRenId))
{
query.AppendFormat(" AND FaBuRenId='{0}' ", serModel.FaBuRenId);
}
if (serModel.ShenHeStatus.HasValue)
{
query.AppendFormat(" AND ShenHeStatus={0} ", (int)serModel.ShenHeStatus.Value);
}
}
else
{
orderByString = "IsHot DESC,CreateDate desc";
}
using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null))
{
while (dr.Read())
{
Eyousoft_yhq.Model.Product model = new Eyousoft_yhq.Model.Product();
model.ProductID = dr.GetString(dr.GetOrdinal("ProductID"));;
model.ProductName = dr.GetString(dr.GetOrdinal("ProductName"));
model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType"));
model.TourDate = dr.IsDBNull(dr.GetOrdinal("TourDate")) ? null : Utils.GetDateTimeNullable(dr.GetDateTime(dr.GetOrdinal("TourDate")).ToString());
model.MarketPrice = dr.GetDecimal(dr.GetOrdinal("MarketPrice"));
model.AppPrice = dr.GetDecimal(dr.GetOrdinal("AppPrice"));
model.FavourCode = dr.GetString(dr.GetOrdinal("FavourCode"));
model.LinkTel = dr.GetString(dr.GetOrdinal("LinkTel"));
model.ProductDis = dr.GetString(dr.GetOrdinal("ProductDis"));
model.TourDis = dr.GetString(dr.GetOrdinal("TourDis"));
model.SendTourKnow = dr.GetString(dr.GetOrdinal("SendTourKnow"));
model.ValidiDate = dr.GetDateTime(dr.GetOrdinal("ValidiDate"));
model.ProductState = dr.GetByte(dr.GetOrdinal("ProductState"));
model.IsEveryDay = dr.IsDBNull(dr.GetOrdinal("IsEveryDay")) ? false : GetBoolean(dr.GetString(dr.GetOrdinal("IsEveryDay")));
model.IsHot = dr.IsDBNull(dr.GetOrdinal("IsHot")) ? 0 : dr.GetByte(dr.GetOrdinal("IsHot"));
model.CreateDate = dr.GetDateTime(dr.GetOrdinal("CreateDate"));
model.ServiceQQ = dr.IsDBNull(dr.GetOrdinal("ServiceQQ")) ? "" : dr.GetString(dr.GetOrdinal("ServiceQQ"));
model.ContractType = (Eyousoft_yhq.Model.ContractType)dr.GetByte(dr.GetOrdinal("ContractType"));
model.ControlPeople = dr.GetInt32(dr.GetOrdinal("ControlPeople"));
model.ResidueNum = dr.GetInt32(dr.GetOrdinal("ResidueNum"));
model.SaleNum = dr.GetInt32(dr.GetOrdinal("SaleNum"));
model.ProductOpState = (Eyousoft_yhq.Model.ProductOp)dr.GetByte(dr.GetOrdinal("ProductOpState"));
model.ProductSdate = dr.IsDBNull(dr.GetOrdinal("ProductSdate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ProductSdate"));
model.ZCodeViaDate = dr.IsDBNull(dr.GetOrdinal("ZCodeViaDate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ZCodeViaDate"));
model.PType = dr.IsDBNull(dr.GetOrdinal("PType")) ? 1 : dr.GetInt32(dr.GetOrdinal("PType"));
model.xianlu = dr.IsDBNull(dr.GetOrdinal("XianLu")) ? Eyousoft_yhq.Model.XianLu.国内游 : (Eyousoft_yhq.Model.XianLu)dr.GetByte(dr.GetOrdinal("XianLu"));
model.FaBuRenId = dr["FaBuRenId"].ToString();
model.ShenHeStatus = (Eyousoft_yhq.Model.ChanPinShenHeStatus)dr.GetInt32(dr.GetOrdinal("ShenHeStatus"));
model.FaBuRenName = dr["FaBuRenName"].ToString();
list.Add(model);
}
}
return(list);
}
public Eyousoft_yhq.Model.Product GetModel(string ProductID)
{
Eyousoft_yhq.Model.Product model = null;
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat("SELECT *,");
strSql.AppendFormat(" (SELECT Name,FilePath,Size,IsWebImage FROM tbl_Attach WHERE ItemId='{0}' FOR XML RAW,ROOT('ROOT'))AS ComAttachXML ", ProductID);
strSql.Append(" FROM view_Product ");
strSql.Append(" where ProductID=@ProductID ");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "ProductID", System.Data.DbType.AnsiStringFixedLength, ProductID);
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
while (dr.Read())
{
model = new Eyousoft_yhq.Model.Product();
model.ProductID = ProductID;
model.ProductName = dr.GetString(dr.GetOrdinal("ProductName"));
model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType"));
model.TourDate = dr.IsDBNull(dr.GetOrdinal("TourDate")) ? null : Utils.GetDateTimeNullable(dr.GetDateTime(dr.GetOrdinal("TourDate")).ToString());
model.MarketPrice = dr.GetDecimal(dr.GetOrdinal("MarketPrice"));
model.AppPrice = dr.GetDecimal(dr.GetOrdinal("AppPrice"));
model.FavourCode = dr.GetString(dr.GetOrdinal("FavourCode"));
model.LinkTel = dr.GetString(dr.GetOrdinal("LinkTel"));
model.ProductDis = dr.GetString(dr.GetOrdinal("ProductDis"));
model.TourDis = dr.GetString(dr.GetOrdinal("TourDis"));
model.SendTourKnow = dr.GetString(dr.GetOrdinal("SendTourKnow"));
model.ValidiDate = dr.GetDateTime(dr.GetOrdinal("ValidiDate"));
//model.ProductState = dr.GetInt32(dr.GetOrdinal("ProductState"));
model.AttachList = this.GetAttachList(dr["ComAttachXML"].ToString(), ProductID);
model.IsEveryDay = dr.IsDBNull(dr.GetOrdinal("IsEveryDay")) ? false : GetBoolean(dr.GetString(dr.GetOrdinal("IsEveryDay")));
model.IsHot = dr.IsDBNull(dr.GetOrdinal("IsHot")) ? 0 : dr.GetByte(dr.GetOrdinal("IsHot"));
model.ServiceQQ = dr.IsDBNull(dr.GetOrdinal("ServiceQQ")) ? "" : dr.GetString(dr.GetOrdinal("ServiceQQ"));
model.ContractType = (Eyousoft_yhq.Model.ContractType)dr.GetByte(dr.GetOrdinal("ContractType"));
model.ControlPeople = dr.GetInt32(dr.GetOrdinal("ControlPeople"));
model.ResidueNum = dr.GetInt32(dr.GetOrdinal("ResidueNum"));
model.SaleNum = dr.GetInt32(dr.GetOrdinal("SaleNum"));
model.ProductOpState = (Eyousoft_yhq.Model.ProductOp)dr.GetByte(dr.GetOrdinal("ProductOpState"));
model.ProductSdate = dr.IsDBNull(dr.GetOrdinal("ProductSdate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ProductSdate"));
model.ZCodeViaDate = dr.IsDBNull(dr.GetOrdinal("ZCodeViaDate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ZCodeViaDate"));
model.PType = dr.IsDBNull(dr.GetOrdinal("PType")) ? 1 : dr.GetInt32(dr.GetOrdinal("PType"));
model.Scompare = dr.IsDBNull(dr.GetOrdinal("Scompare")) ? "" : dr.GetString(dr.GetOrdinal("Scompare"));
model.FaBuRenId = dr["FaBuRenId"].ToString();
model.ShenHeStatus = (Eyousoft_yhq.Model.ChanPinShenHeStatus)dr.GetInt32(dr.GetOrdinal("ShenHeStatus"));
}
}
return model;
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="serModel"></param>
/// <returns></returns>
public IList<Eyousoft_yhq.Model.Product> GetList(Eyousoft_yhq.Model.SerProduct serModel)
{
IList<Eyousoft_yhq.Model.Product> list = new List<Eyousoft_yhq.Model.Product>();
StringBuilder strSql = new StringBuilder();
strSql.Append("select ProductID,ProductName,ProductType,TourDate,MarketPrice,AppPrice,FavourCode,LinkTel,ProductDis,TourDis,SendTourKnow,ValidiDate,IsEveryDay,IsHot,CreateDate,ServiceQQ, ContractType,ControlPeople,ResidueNum,ProductOpState,ProductSdate,ZCodeViaDate,PType,XianLu ");
strSql.AppendFormat(" from view_Product where 1=1 and ProductState=0 AND datediff(day,'{0}',ValidiDate)>=0 ", DateTime.Now);
if (serModel != null)
{
if (serModel.PType > 0)
{
strSql.AppendFormat(" and PType = {0} ", serModel.PType);
}
if (!string.IsNullOrEmpty(serModel.PurductName))
{
strSql.AppendFormat(" and ProductName like '%{0}%' ", serModel.PurductName);
}
if (!string.IsNullOrEmpty(serModel.FavourCode))
{
strSql.AppendFormat(" and FavourCode = '{0}' ", serModel.FavourCode);
}
}
strSql.Append(" order by IsHot DESC, CreateDate DESC ");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
while (dr.Read())
{
Eyousoft_yhq.Model.Product model = new Eyousoft_yhq.Model.Product();
model.ProductID = dr.GetString(dr.GetOrdinal("ProductID")); ;
model.ProductName = dr.GetString(dr.GetOrdinal("ProductName"));
model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType"));
model.TourDate = dr.IsDBNull(dr.GetOrdinal("TourDate")) ? null : Utils.GetDateTimeNullable(dr.GetDateTime(dr.GetOrdinal("TourDate")).ToString());
model.MarketPrice = dr.GetDecimal(dr.GetOrdinal("MarketPrice"));
model.AppPrice = dr.GetDecimal(dr.GetOrdinal("AppPrice"));
model.FavourCode = dr.GetString(dr.GetOrdinal("FavourCode"));
model.LinkTel = dr.GetString(dr.GetOrdinal("LinkTel"));
model.ProductDis = dr.GetString(dr.GetOrdinal("ProductDis"));
model.TourDis = dr.GetString(dr.GetOrdinal("TourDis"));
model.SendTourKnow = dr.GetString(dr.GetOrdinal("SendTourKnow"));
model.ValidiDate = dr.GetDateTime(dr.GetOrdinal("ValidiDate"));
//model.ProductState = dr.GetInt32(dr.GetOrdinal("ProductState"));
model.IsEveryDay = dr.IsDBNull(dr.GetOrdinal("IsEveryDay")) ? false : GetBoolean(dr.GetString(dr.GetOrdinal("IsEveryDay")));
model.IsHot = dr.IsDBNull(dr.GetOrdinal("IsHot")) ? 0 : dr.GetByte(dr.GetOrdinal("IsHot"));
model.CreateDate = dr.GetDateTime(dr.GetOrdinal("CreateDate"));
model.ServiceQQ = dr.IsDBNull(dr.GetOrdinal("ServiceQQ")) ? "" : dr.GetString(dr.GetOrdinal("ServiceQQ"));
model.ContractType = (Eyousoft_yhq.Model.ContractType)dr.GetByte(dr.GetOrdinal("ContractType"));
model.ControlPeople = dr.GetInt32(dr.GetOrdinal("ControlPeople"));
model.ResidueNum = dr.GetInt32(dr.GetOrdinal("ResidueNum"));
model.ProductSdate = dr.IsDBNull(dr.GetOrdinal("ProductSdate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ProductSdate"));
model.ZCodeViaDate = dr.IsDBNull(dr.GetOrdinal("ZCodeViaDate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ZCodeViaDate"));
model.xianlu = (Eyousoft_yhq.Model.XianLu)dr.GetByte(dr.GetOrdinal("XianLu"));
list.Add(model);
}
}
return list;
}
public IList<Eyousoft_yhq.Model.Product> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.SerProduct serModel)
{
IList<Eyousoft_yhq.Model.Product> list = new List<Eyousoft_yhq.Model.Product>();
string tableName = "view_Product";
string fileds = " * ";
string orderByString = "";
StringBuilder query = new StringBuilder();
query.Append(" 1=1 ");
if (serModel != null)
{
#region 排序
if (serModel.SFTJ == 1) orderByString += " IsHot DESC,";
if (serModel.DDXL == 1) orderByString += "SaleNum DESC,";
if (serModel.DDXL == 2) orderByString += "SaleNum ASC,";
if (serModel.SJPX == 1)
{
orderByString += "CreateDate DESC,";
}
else if (serModel.SJPX == 2)
{
orderByString += "CreateDate ASC,";
}
if (serModel.JGPX == 1) orderByString += "AppPrice DESC,";
if (serModel.JGPX == 2) orderByString += "AppPrice ASC,";
if (!string.IsNullOrEmpty(orderByString))
{
orderByString = orderByString.TrimEnd(',');
}
else
{
orderByString = "IsHot DESC,CreateDate desc";
}
#endregion
if (!string.IsNullOrEmpty(serModel.FavourCode))
{
query.AppendFormat(" and (FavourCode = '{0}' )", serModel.FavourCode);
}
if (serModel.PType > 0)
{
query.AppendFormat(" and (PType = {0} )", serModel.PType);
}
if (serModel.IsAdmin != "1" && !string.IsNullOrEmpty(serModel.AdminName))
{
query.AppendFormat(" and ( charindex('{0}',[AdminName])>0 or AdminName is null)", serModel.AdminName);
}
if (!string.IsNullOrEmpty(serModel.PurductName))
{
query.AppendFormat(" and ProductName like '%{0}%' ", serModel.PurductName);
}
if (!string.IsNullOrEmpty(serModel.PurductType) && serModel.PurductType != "0")
{
query.AppendFormat(" and ProductType = '{0}' ", serModel.PurductType);
}
if (!string.IsNullOrEmpty(serModel.PurductState) && serModel.PurductState != "2")
{
query.AppendFormat(" and ProductState = '{0}' ", serModel.PurductState);
}
if (serModel.Stime.HasValue)
{
query.AppendFormat(" AND datediff(day,'{0}',ValidiDate)>=0 ", serModel.Stime.Value);
}
if (serModel.Etime.HasValue)
{
query.AppendFormat(" AND datediff(day,'{0}',ValidiDate)< 0 ", serModel.Etime.Value.AddDays(1));
}
if (!serModel.isVisable)
{
query.AppendFormat(" AND ProductState = 0 ");
}
if (serModel.isHot.HasValue && serModel.isHot == 1)
{
query.AppendFormat(" and IsHot = '{0}' ", serModel.isHot);
}
else if (serModel.isHot.HasValue && serModel.isHot == 0)
{
query.AppendFormat(" and (IsHot = '{0}' or IsHot is null) ", serModel.isHot);
}
if (serModel.xianlu != null && serModel.PType == 1)
{
query.AppendFormat(" and XianLu = '{0}' ", (int)serModel.xianlu);
}
if (!string.IsNullOrEmpty(serModel.WeiDianId))
{
query.AppendFormat(" AND EXISTS(SELECT 1 FROM tbl_WeiDianChanPinGuanXi AS A1 WHERE A1.ChanPinId=view_Product.ProductID AND A1.WeiDianId='{0}') ", serModel.WeiDianId);
}
if (!string.IsNullOrEmpty(serModel.FaBuRenId))
{
query.AppendFormat(" AND FaBuRenId='{0}' ", serModel.FaBuRenId);
}
if (serModel.ShenHeStatus.HasValue)
{
query.AppendFormat(" AND ShenHeStatus={0} ", (int)serModel.ShenHeStatus.Value);
}
}
else
{
orderByString = "IsHot DESC,CreateDate desc";
}
using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null))
{
while (dr.Read())
{
Eyousoft_yhq.Model.Product model = new Eyousoft_yhq.Model.Product();
model.ProductID = dr.GetString(dr.GetOrdinal("ProductID")); ;
model.ProductName = dr.GetString(dr.GetOrdinal("ProductName"));
model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType"));
model.TourDate = dr.IsDBNull(dr.GetOrdinal("TourDate")) ? null : Utils.GetDateTimeNullable(dr.GetDateTime(dr.GetOrdinal("TourDate")).ToString());
model.MarketPrice = dr.GetDecimal(dr.GetOrdinal("MarketPrice"));
model.AppPrice = dr.GetDecimal(dr.GetOrdinal("AppPrice"));
model.FavourCode = dr.GetString(dr.GetOrdinal("FavourCode"));
model.LinkTel = dr.GetString(dr.GetOrdinal("LinkTel"));
model.ProductDis = dr.GetString(dr.GetOrdinal("ProductDis"));
model.TourDis = dr.GetString(dr.GetOrdinal("TourDis"));
model.SendTourKnow = dr.GetString(dr.GetOrdinal("SendTourKnow"));
model.ValidiDate = dr.GetDateTime(dr.GetOrdinal("ValidiDate"));
model.ProductState = dr.GetByte(dr.GetOrdinal("ProductState"));
model.IsEveryDay = dr.IsDBNull(dr.GetOrdinal("IsEveryDay")) ? false : GetBoolean(dr.GetString(dr.GetOrdinal("IsEveryDay")));
model.IsHot = dr.IsDBNull(dr.GetOrdinal("IsHot")) ? 0 : dr.GetByte(dr.GetOrdinal("IsHot"));
model.CreateDate = dr.GetDateTime(dr.GetOrdinal("CreateDate"));
model.ServiceQQ = dr.IsDBNull(dr.GetOrdinal("ServiceQQ")) ? "" : dr.GetString(dr.GetOrdinal("ServiceQQ"));
model.ContractType = (Eyousoft_yhq.Model.ContractType)dr.GetByte(dr.GetOrdinal("ContractType"));
model.ControlPeople = dr.GetInt32(dr.GetOrdinal("ControlPeople"));
model.ResidueNum = dr.GetInt32(dr.GetOrdinal("ResidueNum"));
model.SaleNum = dr.GetInt32(dr.GetOrdinal("SaleNum"));
model.ProductOpState = (Eyousoft_yhq.Model.ProductOp)dr.GetByte(dr.GetOrdinal("ProductOpState"));
model.ProductSdate = dr.IsDBNull(dr.GetOrdinal("ProductSdate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ProductSdate"));
model.ZCodeViaDate = dr.IsDBNull(dr.GetOrdinal("ZCodeViaDate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ZCodeViaDate"));
model.PType = dr.IsDBNull(dr.GetOrdinal("PType")) ? 1 : dr.GetInt32(dr.GetOrdinal("PType"));
model.xianlu = dr.IsDBNull(dr.GetOrdinal("XianLu")) ? Eyousoft_yhq.Model.XianLu.国内游 : (Eyousoft_yhq.Model.XianLu)dr.GetByte(dr.GetOrdinal("XianLu"));
model.FaBuRenId = dr["FaBuRenId"].ToString();
model.ShenHeStatus = (Eyousoft_yhq.Model.ChanPinShenHeStatus)dr.GetInt32(dr.GetOrdinal("ShenHeStatus"));
model.FaBuRenName = dr["FaBuRenName"].ToString();
list.Add(model);
}
}
return list;
}
