/// <summary>
/// 修改门票(价格一修改，则状态改为待审核)
/// </summary>
/// <param name="item"></param>
/// <param name="isGn"></param>
/// <returns></returns>
public virtual bool Update(MScenicTickets item, bool isGn)
{
DbCommand comm = this._db.GetStoredProcCommand("proc_ScenicTickets_Update");
this._db.AddInParameter(comm, "@TicketsId", DbType.AnsiStringFixedLength, item.TicketsId);
this._db.AddInParameter(comm, "@ScenicId", DbType.AnsiStringFixedLength, item.ScenicId);
this._db.AddInParameter(comm, "@TypeName", DbType.String, item.TypeName);
this._db.AddInParameter(comm, "@RetailPrice", DbType.Currency, item.RetailPrice);
this._db.AddInParameter(comm, "@WebsitePrices", DbType.Currency, item.WebsitePrices);
this._db.AddInParameter(comm, "@MarketPrice", DbType.Currency, item.MarketPrice);
this._db.AddInParameter(comm, "@DistributionPrice", DbType.Currency, item.DistributionPrice);
this._db.AddInParameter(comm, "@Limit", DbType.Int32, item.Limit);
this._db.AddInParameter(comm, "@Payment", DbType.Byte, (int)item.Payment);
this._db.AddInParameter(comm, "@StartTime", DbType.DateTime, item.StartTime);
this._db.AddInParameter(comm, "@EndTime", DbType.DateTime, item.EndTime);
this._db.AddInParameter(comm, "@Description", DbType.String, item.Description);
this._db.AddInParameter(comm, "@SaleDescription", DbType.String, item.SaleDescription);
this._db.AddInParameter(comm, "@Status", DbType.Byte, (int)item.Status);
this._db.AddInParameter(comm, "@CustomOrder", DbType.Int32, item.CustomOrder);
this._db.AddInParameter(comm, "@B2B", DbType.Byte, (int)item.B2B);
this._db.AddInParameter(comm, "@B2BOrder", DbType.Int32, item.B2BOrder);
this._db.AddInParameter(comm, "@B2C", DbType.Byte, (int)item.B2C);
this._db.AddInParameter(comm, "@B2COrder", DbType.Int32, item.B2COrder);
this._db.AddInParameter(comm, "@EnName", DbType.String, item.EnName);
this._db.AddInParameter(comm, "@ExamineStatus", DbType.Byte, (int)ExamineStatus.待审核);
if (isGn)
{
this._db.AddInParameter(comm, "@ExamineStatus1", DbType.Byte, (int)item.ExamineStatus);
}
return(DbHelper.ExecuteSql(comm, this._db) > 0 ? true : false);
}
/// <summary>
/// 获取门票实体
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="ticketsId">门票编号</param>
/// <returns>门票实体</returns>
public virtual MScenicTickets GetModel(string ticketsId, string companyId)
{
StringBuilder sql = new StringBuilder();
sql.Append("SELECT [TicketsId],[ScenicId],[TypeName],[EnName],[RetailPrice]");
sql.Append(",[WebsitePrices],[MarketPrice],[DistributionPrice]");
sql.Append(",[Limit],[Payment],[StartTime],[EndTime],[Description],[SaleDescription],[Status]");
sql.Append(",[ExamineStatus],[CustomOrder],[B2B],[B2BOrder],[B2C]");
sql.Append(",[B2COrder],[IssueTime] ,[Operator],[CompanyId]");
sql.Append(" FROM [dbo].[tbl_ScenicTickets] WHERE TicketsId = @id AND CompanyId = @cid");
DbCommand comm = this._db.GetSqlStringCommand(sql.ToString());
this._db.AddInParameter(comm, "@id", DbType.AnsiStringFixedLength, ticketsId);
this._db.AddInParameter(comm, "@cid", DbType.AnsiStringFixedLength, companyId);
MScenicTickets item = null;
using (IDataReader reader = DbHelper.ExecuteReader(comm, this._db))
{
if (reader.Read())
{
item = new MScenicTickets()
{
TicketsId = reader["TicketsId"].ToString(),
ScenicId = reader["ScenicId"].ToString(),
TypeName = reader["TypeName"].ToString(),
EnName = reader.IsDBNull(reader.GetOrdinal("EnName")) ? string.Empty : reader["EnName"].ToString(),
RetailPrice = reader.IsDBNull(reader.GetOrdinal("RetailPrice")) ? 0 : (decimal)reader["RetailPrice"],
WebsitePrices = reader.IsDBNull(reader.GetOrdinal("WebsitePrices")) ? 0 : (decimal)reader["WebsitePrices"],
MarketPrice = reader.IsDBNull(reader.GetOrdinal("MarketPrice")) ? 0 : (decimal)reader["MarketPrice"],
DistributionPrice = reader.IsDBNull(reader.GetOrdinal("DistributionPrice")) ? 0 : (decimal)reader["DistributionPrice"],
Limit = (int)reader["Limit"],
Payment = (ScenicPayment)Enum.Parse(typeof(ScenicPayment), reader["Payment"].ToString()),
Description = reader.IsDBNull(reader.GetOrdinal("Description")) ? string.Empty : reader["Description"].ToString(),
SaleDescription = reader.IsDBNull(reader.GetOrdinal("SaleDescription")) ? string.Empty : reader["SaleDescription"].ToString(),
Status = (ScenicTicketsStatus)Enum.Parse(typeof(ScenicTicketsStatus), reader["Status"].ToString()),
ExamineStatus = (ExamineStatus)Enum.Parse(typeof(ExamineStatus), reader["ExamineStatus"].ToString()),
CustomOrder = (int)reader["CustomOrder"],
B2B = (ScenicB2BDisplay)Enum.Parse(typeof(ScenicB2BDisplay), reader["B2B"].ToString()),
B2BOrder = (int)reader["B2BOrder"],
B2C = (ScenicB2CDisplay)Enum.Parse(typeof(ScenicB2CDisplay), reader["B2C"].ToString()),
B2COrder = (int)reader["B2COrder"],
IssueTime = (DateTime)reader["IssueTime"],
Operator = reader["Operator"].ToString(),
CompanyId = reader["CompanyId"].ToString()
};
if (!reader.IsDBNull(reader.GetOrdinal("StartTime")))
{
item.StartTime = (DateTime)reader["StartTime"];
}
if (!reader.IsDBNull(reader.GetOrdinal("EndTime")))
{
item.EndTime = (DateTime)reader["EndTime"];
}
}
}
return(item);
}
protected void Page_Load(object sender, EventArgs e)
{
ScenicB2BDisplay? b2b = null;
ScenicB2CDisplay? b2c = null;
ScenicPayment? payment = null;
ScenicTicketsStatus?status = null;
string scenicId = string.Empty;
string companyId = this.SiteUserInfo.CompanyID;
if (!IsPostBack)
{
scenicId = Request.QueryString["scenic"];
string ticketsId = Request.QueryString["tickets"];
MScenicTickets item = new MScenicTickets();
#region
if (!string.IsNullOrEmpty(scenicId))
{
item = BScenicTickets.CreateInstance().GetModel(ticketsId, companyId);
if (item != null)
{
txtTypeName.Value = item.TypeName;
txtRetailPrice.Value = item.RetailPrice == 0 ? string.Empty : item.RetailPrice.ToString("F2");
txtMarketPrice.Value = item.MarketPrice == 0 ? string.Empty : item.MarketPrice.ToString("F2");
txtWebsitePrices.Value = item.WebsitePrices == 0 ? string.Empty : item.WebsitePrices.ToString("F2");
txtDistributionPrice.Value = item.DistributionPrice == 0 ? string.Empty : item.DistributionPrice.ToString("F2");
txtEnName.Value = item.EnName;
hidMSPrice.Value = item.RetailPrice == 0 ? string.Empty : item.RetailPrice.ToString("F2");
hidWZPrice.Value = item.MarketPrice == 0 ? string.Empty : item.MarketPrice.ToString("F2");
hidSCPrice.Value = item.WebsitePrices == 0 ? string.Empty : item.WebsitePrices.ToString("F2");
hidTHPrice.Value = item.DistributionPrice == 0 ? string.Empty : item.DistributionPrice.ToString("F2");
txtLimit.Value = item.Limit.ToString();
txtStartTime.Value = item.StartTime == null ? string.Empty : Convert.ToDateTime(item.StartTime).ToString("yyyy-MM-dd");
txtEndTime.Value = item.EndTime == null ? string.Empty : Convert.ToDateTime(item.EndTime).ToString("yyyy-MM-dd");
txtDescription.Value = item.Description;
txtSaleDescription.Value = item.SaleDescription;
lblExamineStatus.Text = item.ExamineStatus.ToString();
txtCustomOrder.Value = item.CustomOrder.ToString();
//txtB2BOrder.Value = item.B2BOrder.ToString();
//txtB2COrder.Value = item.B2COrder.ToString();
//支付方式
payment = item.Payment;
status = item.Status;
b2b = item.B2B;
b2c = item.B2C;
//景区编号
hfId.Value = ticketsId;
}
}
#endregion
//景区
DropScenic(companyId, scenicId);
RidaoPayment(payment);
DropStatus(status);
//DropB2B(b2b);
//DropB2C(b2c);
}
}
/// <summary>
/// 修改门票(运营后台)
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public bool OperateUpdate(MScenicTickets item)
{
bool result = false;
if (item != null)
{
result = dal.Update(item, true);
}
return(result);
}
/// <summary>
/// 添加门票(运营后台)
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public bool OperateAdd(MScenicTickets item)
{
bool result = false;
if (item != null)
{
item.TicketsId = Guid.NewGuid().ToString();
result = dal.Add(item);
}
return(result);
}
/// <summary>
/// 获取门票实体
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="ticketsId">门票编号</param>
/// <returns>门票实体</returns>
public MScenicTickets GetModel(string ticketsId, string companyId)
{
MScenicTickets item = null;
if (!string.IsNullOrEmpty(ticketsId) && !string.IsNullOrEmpty(companyId))
{
item = dal.GetModel(ticketsId, companyId);
}
return(item);
}
/// <summary>
/// 添加门票(用户后台)
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public bool Add(MScenicTickets item)
{
bool result = false;
if (item != null)
{
item.TicketsId = Guid.NewGuid().ToString();
//默认待审核
item.ExamineStatus = ExamineStatus.待审核;
//B2B,B2C排序默认50
item.B2BOrder = 50;
item.B2COrder = 50;
result = dal.Add(item);
}
return(result);
}
/// <summary>
/// 添加门票
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public virtual bool Add(MScenicTickets item)
{
StringBuilder sql = new StringBuilder();
sql.Append("INSERT INTO tbl_ScenicTickets(TicketsId,ScenicId,TypeName,RetailPrice,WebsitePrices,MarketPrice,DistributionPrice");
sql.Append(",Limit,Payment,StartTime,EndTime,Description,SaleDescription,Status,CustomOrder,B2B,B2BOrder,B2C,B2COrder");
sql.Append(",Operator,CompanyId,ExamineStatus,EnName,ExamineOperator) VALUES(@TicketsId,@ScenicId,@TypeName,@RetailPrice,@WebsitePrices,@MarketPrice,@DistributionPrice");
sql.Append(",@Limit,@Payment,@StartTime,@EndTime,@Description,@SaleDescription,@Status,@CustomOrder,@B2B,@B2BOrder,@B2C");
sql.Append(",@B2COrder,@Operator,@CompanyId,@ExamineStatus,@EnName,@ExamineOperator)");
DbCommand comm = this._db.GetSqlStringCommand(sql.ToString());
this._db.AddInParameter(comm, "@TicketsId", DbType.AnsiStringFixedLength, item.TicketsId);
this._db.AddInParameter(comm, "@ScenicId", DbType.AnsiStringFixedLength, item.ScenicId);
this._db.AddInParameter(comm, "@TypeName", DbType.String, item.TypeName);
this._db.AddInParameter(comm, "@RetailPrice", DbType.Currency, item.RetailPrice);
this._db.AddInParameter(comm, "@WebsitePrices", DbType.Currency, item.WebsitePrices);
this._db.AddInParameter(comm, "@MarketPrice", DbType.Currency, item.MarketPrice);
this._db.AddInParameter(comm, "@DistributionPrice", DbType.Currency, item.DistributionPrice);
this._db.AddInParameter(comm, "@Limit", DbType.Int32, item.Limit);
this._db.AddInParameter(comm, "@Payment", DbType.Byte, (int)item.Payment);
this._db.AddInParameter(comm, "@StartTime", DbType.DateTime, item.StartTime);
this._db.AddInParameter(comm, "@EndTime", DbType.DateTime, item.EndTime);
this._db.AddInParameter(comm, "@Description", DbType.String, item.Description);
this._db.AddInParameter(comm, "@SaleDescription", DbType.String, item.SaleDescription);
this._db.AddInParameter(comm, "@Status", DbType.Byte, (int)item.Status);
this._db.AddInParameter(comm, "@CustomOrder", DbType.Int32, item.CustomOrder);
this._db.AddInParameter(comm, "@B2B", DbType.Byte, (int)item.B2B);
this._db.AddInParameter(comm, "@B2BOrder", DbType.Int32, item.B2BOrder);
this._db.AddInParameter(comm, "@B2C", DbType.Byte, (int)item.B2C);
this._db.AddInParameter(comm, "@B2COrder", DbType.Int32, item.B2COrder);
this._db.AddInParameter(comm, "@Operator", DbType.AnsiStringFixedLength, item.Operator);
this._db.AddInParameter(comm, "@CompanyId", DbType.AnsiStringFixedLength, item.CompanyId);
this._db.AddInParameter(comm, "@ExamineStatus", DbType.Byte, (int)item.ExamineStatus);
this._db.AddInParameter(comm, "@EnName", DbType.String, item.EnName);
this._db.AddInParameter(comm, "@ExamineOperator", DbType.Int32,
item.ExamineStatus == ExamineStatus.已审核 ? (int?)item.ExamineOperator : null);
return(DbHelper.ExecuteSql(comm, this._db) > 0 ? true : false);
}
/// <summary>
/// 门票列表
/// </summary>
/// <param name="pageSize">每页显示记录数</param>
/// <param name="pageIndex">当前页</param>
/// <param name="recordCount">总记录数</param>
/// <param name="search">查询条件</param>
/// <returns>门票列表</returns>
public virtual IList <MScenicTickets> GetList(int pageSize, int pageIndex, ref int recordCount, MSearchScenicTickets search)
{
string tableName = "view_ScenicTickets_Select";
string primaryKey = "TicketsId";
string fields = "CompanyId,TicketsId,ScenicId,TypeName,RetailPrice,WebsitePrices,StartTime,EndTime,Payment,ExamineStatus,Status,B2B,B2C,ScenicName,IssueTime";
string orderBy = "ExamineStatus ASC,LastUpdateTime Desc"; //按照待审核，已审核，最后修改时间排序
#region 查询条件
StringBuilder query = new StringBuilder();
query.Append(" 1=1");
if (search != null)
{
if (search.ExamineStatus != null)
{
query.AppendFormat(" and ExamineStatus = {0}", (int)search.ExamineStatus);
}
if (search.Status != null)
{
query.AppendFormat(" and Status = {0}", (int)search.Status);
}
if (!string.IsNullOrEmpty(search.ScenicName))
{
query.AppendFormat(" and ScenicName like '%{0}%'", search.ScenicName);
}
if (!string.IsNullOrEmpty(search.TypeName))
{
query.AppendFormat(" and TypeName like '%{0}%'", search.TypeName);
}
if (!string.IsNullOrEmpty(search.ScenicId))
{
query.AppendFormat(" and ScenicId = '{0}'", search.ScenicId);
}
if (search.B2B != null)
{
query.AppendFormat(" and B2B = {0}", (int)search.B2B);
}
if (search.B2C != null)
{
query.AppendFormat(" and B2C = {0}", (int)search.B2C);
}
if (!string.IsNullOrEmpty(search.TicketsName))
{
query.AppendFormat(" and TypeName = '{0}'", search.TicketsName);
}
}
#endregion
IList <MScenicTickets> list = new List <MScenicTickets>();
MScenicTickets item = null;
using (IDataReader reader = DbHelper.ExecuteReader(this._db, pageSize, pageIndex, ref recordCount,
tableName, primaryKey, fields, query.ToString(), orderBy))
{
while (reader.Read())
{
item = new MScenicTickets()
{
CompanyId = reader["CompanyId"].ToString(),
TicketsId = reader["TicketsId"].ToString(),
ScenicId = reader["ScenicId"].ToString(),
ScenicName = reader["ScenicName"].ToString(),
TypeName = reader["TypeName"].ToString(),
RetailPrice = reader.IsDBNull(reader.GetOrdinal("RetailPrice")) ? 0 : (decimal)reader["RetailPrice"],
WebsitePrices = reader.IsDBNull(reader.GetOrdinal("WebsitePrices")) ? 0 : (decimal)reader["WebsitePrices"],
Payment = (ScenicPayment)Enum.Parse(typeof(ScenicPayment), reader["Payment"].ToString()),
Status = (ScenicTicketsStatus)Enum.Parse(typeof(ScenicTicketsStatus), reader["Status"].ToString()),
ExamineStatus = (ExamineStatus)Enum.Parse(typeof(ExamineStatus), reader["ExamineStatus"].ToString()),
B2B = (ScenicB2BDisplay)Enum.Parse(typeof(ScenicB2BDisplay), reader["B2B"].ToString()),
B2C = (ScenicB2CDisplay)Enum.Parse(typeof(ScenicB2CDisplay), reader["B2C"].ToString()),
IssueTime = (DateTime)reader["IssueTime"],
};
if (!reader.IsDBNull(reader.GetOrdinal("StartTime")))
{
item.StartTime = (DateTime)reader["StartTime"];
}
if (!reader.IsDBNull(reader.GetOrdinal("EndTime")))
{
item.EndTime = (DateTime)reader["EndTime"];
}
list.Add(item);
}
}
return(list);
}
/// <summary>
/// 修改保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnCommit_Click(object sender, EventArgs e)
{
MScenicTickets item = new MScenicTickets()
{
ScenicId = Utils.GetFormValue(ddlScenic.UniqueID),
Status = (ScenicTicketsStatus)Enum.Parse(typeof(ScenicTicketsStatus), Utils.GetFormValue(ddlStatus.UniqueID)),
//B2B = (ScenicB2BDisplay)Enum.Parse(typeof(ScenicB2BDisplay), Utils.GetFormValue(ddlB2B.UniqueID)),
//B2C = (ScenicB2CDisplay)Enum.Parse(typeof(ScenicB2CDisplay), Utils.GetFormValue(ddlB2C.UniqueID)),
Description = Utils.GetFormValue(txtDescription.UniqueID),
CustomOrder = Utils.GetInt(Utils.GetFormValue(txtCustomOrder.UniqueID)),
CompanyId = SiteUserInfo.CompanyID,
SaleDescription = Utils.GetFormValue(txtSaleDescription.UniqueID),
StartTime = Utils.GetDateTimeNullable(Utils.GetFormValue(txtStartTime.UniqueID)),
EndTime = Utils.GetDateTimeNullable(Utils.GetFormValue(txtEndTime.UniqueID)),
EnName = Utils.GetFormValue(txtEnName.UniqueID),
DistributionPrice = Utils.GetDecimal(Utils.GetFormValue(txtDistributionPrice.UniqueID)),
//B2BOrder = Utils.GetInt(Utils.GetFormValue(txtB2BOrder.UniqueID)),
//B2COrder = Utils.GetInt(Utils.GetFormValue(txtB2COrder.UniqueID)),
Operator = SiteUserInfo.ID,
Payment = (ScenicPayment)Enum.Parse(typeof(ScenicPayment), Utils.GetFormValue(rdoPayment.UniqueID)),
Limit = Utils.GetInt(Utils.GetFormValue(txtLimit.UniqueID)),
TypeName = Utils.GetFormValue(txtTypeName.UniqueID),
WebsitePrices = Utils.GetDecimal(Utils.GetFormValue(txtWebsitePrices.UniqueID)),
RetailPrice = Utils.GetDecimal(Utils.GetFormValue(txtRetailPrice.UniqueID)),
MarketPrice = Utils.GetDecimal(Utils.GetFormValue(txtMarketPrice.UniqueID))
};
bool result;
//添加
if (string.IsNullOrEmpty(hfId.Value.Trim()) && !Utils.GetFormValue(ddlScenic.UniqueID).Equals(hfId.Value.Trim()))
{
result = BScenicTickets.CreateInstance().Add(item);
}
else //修改
{
item.TicketsId = hfId.Value.Trim();
MScenicTickets ticketsItem = BScenicTickets.CreateInstance().GetModel(item.TicketsId, item.CompanyId);
item.B2B = ticketsItem.B2B;
item.B2C = ticketsItem.B2C;
item.B2BOrder = ticketsItem.B2BOrder;
item.B2COrder = ticketsItem.B2COrder;
result = BScenicTickets.CreateInstance().Update(item);
//if (result)
//{
// //已审核的情况下，修改了价格则要提示
// if ((item.DistributionPrice != ticketsItem.DistributionPrice ||
// item.WebsitePrices != ticketsItem.WebsitePrices ||
// item.RetailPrice != ticketsItem.RetailPrice ||
// item.MarketPrice != ticketsItem.MarketPrice) && ticketsItem.ExamineStatus == ExamineStatus.已审核)
// {
// msg = "修改价格后，请等待网站审核，方可显示";
// }
//}
}
if (result)
{
Response.Write("");
EyouSoft.Common.Function.MessageBox.ResponseScript(this.Page, "alert('操作成功');parent.Boxy.getIframeDialog('" + Request.QueryString["iframeid"] + "').hide();parent.topTab.url(parent.topTab.activeTabIndex,'/ScenicManage/MyScenice.aspx');");
}
else
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this.Page, "alert('操作失败!');;parent.Boxy.getIframeDialog('" + Request.QueryString["iframeid"] + "').hide();parent.topTab.url(parent.topTab.activeTabIndex,'/ScenicManage/MyScenice.aspx');");
}
}
