/// <summary>
/// 获得当前公司的机票政策
/// </summary>
/// <param name="companyId">专线公司编号</param>
/// <param name="pageSize"></param>
/// <param name="pageIndex"></param>
/// <param name="recordCount"></param>
/// <returns></returns>
public IList <EyouSoft.Model.SiteStructure.TicketPolicy> GetTicketPolicy(int CompanyId, int pageSize, int pageIndex, ref int recordCount)
{
IList <EyouSoft.Model.SiteStructure.TicketPolicy> items = new List <EyouSoft.Model.SiteStructure.TicketPolicy>();
EyouSoft.Model.SiteStructure.TicketPolicy item = null;
StringBuilder cmdQuery = new StringBuilder();
string tableName = "tbl_SiteTicketPolicy";
string primaryKey = "PolicyId";
string orderByString = "PolicyId ASC";
StringBuilder fields = new StringBuilder();
#region 要查询的字段
fields.Append("*");
#endregion
#region 拼接查询条件
cmdQuery.AppendFormat(" CompanyId={0}", CompanyId);
#endregion
using (IDataReader rdr = DbHelper.ExecuteReader(this.DB, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields.ToString(), cmdQuery.ToString(), orderByString))
{
while (rdr.Read())
{
item = new EyouSoft.Model.SiteStructure.TicketPolicy()
{
Id = rdr.GetInt32(rdr.GetOrdinal("PolicyId")),
CompanyId = rdr.IsDBNull(rdr.GetOrdinal("CompanyId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("CompanyId")),
Content = rdr["Content"].ToString(),
FilePath = rdr["FilePath"].ToString(),
Title = rdr["Title"].ToString()
};
items.Add(item);
}
}
return(items);
}
protected void Page_Load(object sender, EventArgs e)
{
EyouSoft.Model.SiteStructure.TicketPolicy ssModel = new EyouSoft.Model.SiteStructure.TicketPolicy();
EyouSoft.BLL.SiteStructure.TicketPolicy ssBLL = new EyouSoft.BLL.SiteStructure.TicketPolicy();
//判断权限
if (!CheckGrant(global::Common.Enum.TravelPermission.系统设置_同行平台栏目))
{
Utils.ResponseNoPermit(global::Common.Enum.TravelPermission.系统设置_同行平台栏目, false);
return;
}
if (!IsPostBack)
{
//修改时加载原有数据
if (Utils.GetQueryStringValue("type") == "modify")
{
//获取id
id = Utils.GetInt(Utils.GetQueryStringValue("tid"));
//获取model
ssModel = ssBLL.GetTicketPolicy(id, SiteUserInfo.CompanyID);
//机票政策内容
txt_Contert.Text = ssModel.Content;
//机票政策Title
txt_Title.Text = ssModel.Title;
//附件路劲
filePath = ssModel.FilePath;
}
}
}
/// <summary>
/// 初始化列表
/// </summary>
private void Content()
{
//判断 当前域名是否是专线系统为组团配置的域名
EyouSoft.Model.SysStructure.SystemDomain domain = new EyouSoft.BLL.SysStructure.SystemDomain().GetDomain(Request.Url.Host.ToLower());
//获取机票政策id
int id = Utils.GetInt(Utils.GetQueryStringValue("id"));
//机票政策BLL
EyouSoft.BLL.SiteStructure.TicketPolicy ssBLL = new EyouSoft.BLL.SiteStructure.TicketPolicy();
//机票政策Model
EyouSoft.Model.SiteStructure.TicketPolicy ssModel = new EyouSoft.Model.SiteStructure.TicketPolicy();
//获取机票政策实体
ssModel = ssBLL.GetTicketPolicy(id, domain.CompanyId);
if (ssModel != null)
{
//显示机票政策
lblContent.Text = ssModel.Content;
//显示标题
lblTitle.Text = ssModel.Title;
//显示时间
//lblDate.Text=ssModel.
//获取附件
if (ssModel.FilePath.Trim() != "")
{
linkFilePath.NavigateUrl = ssModel.FilePath;
linkFilePath.Visible = true;
}
}
}
/// <summary>
/// 修改机票政策
/// </summary>
/// <param name="TicketPolicy"></param>
/// <returns></returns>
public bool UpdateTicketPolicy(EyouSoft.Model.SiteStructure.TicketPolicy TicketPolicy)
{
if (TicketPolicy == null || TicketPolicy.CompanyId == 0 || TicketPolicy.Id == 0)
{
return(false);
}
return(idal.UpdateTicketPolicy(TicketPolicy));
}
/// <summary>
/// 添加机票政策
/// </summary>
/// <param name="TicketPolicy"></param>
/// <returns></returns>
public bool AddTicketPolicy(EyouSoft.Model.SiteStructure.TicketPolicy TicketPolicy)
{
string SQL = "INSERT INTO [tbl_SiteTicketPolicy]([CompanyId],[Content],[FilePath],[Title]) VALUES(@CompanyId,@Content,@FilePath,@Title)";
DbCommand dc = this.DB.GetSqlStringCommand(SQL);
this.DB.AddInParameter(dc, "CompanyId", DbType.Int32, TicketPolicy.CompanyId);
this.DB.AddInParameter(dc, "Content", DbType.String, TicketPolicy.Content);
this.DB.AddInParameter(dc, "FilePath", DbType.String, TicketPolicy.FilePath);
this.DB.AddInParameter(dc, "Title", DbType.String, TicketPolicy.Title);
return(DbHelper.ExecuteSql(dc, this.DB) > 0 ? true : false);
}
/// <summary>
/// 修改机票政策
/// </summary>
/// <param name="TicketPolicy"></param>
/// <returns></returns>
public bool UpdateTicketPolicy(EyouSoft.Model.SiteStructure.TicketPolicy TicketPolicy)
{
string SQL = "UPDATE [tbl_SiteTicketPolicy] SET [Content]=@Content,[FilePath]=@FilePath,[Title]=@Title WHERE [PolicyId]=@PolicyId AND [CompanyId]=@CompanyId";
DbCommand dc = this.DB.GetSqlStringCommand(SQL);
this.DB.AddInParameter(dc, "PolicyId", DbType.Int32, TicketPolicy.Id);
this.DB.AddInParameter(dc, "CompanyId", DbType.Int32, TicketPolicy.CompanyId);
this.DB.AddInParameter(dc, "Content", DbType.String, TicketPolicy.Content);
this.DB.AddInParameter(dc, "FilePath", DbType.String, TicketPolicy.FilePath);
this.DB.AddInParameter(dc, "Title", DbType.String, TicketPolicy.Title);
return(DbHelper.ExecuteSql(dc, this.DB) > 0 ? true : false);
}
/// <summary>
/// 获得机票政策实体信息
/// </summary>
/// <param name="companyId"></param>
/// <param name="Id"></param>
/// <returns></returns>
public EyouSoft.Model.SiteStructure.TicketPolicy GetTicketPolicy(int Id, int CompanyId)
{
EyouSoft.Model.SiteStructure.TicketPolicy TicketPolicy = null;
DbCommand dc = this.DB.GetSqlStringCommand(String.Format("SELECT * FROM [tbl_SiteTicketPolicy] WHERE [PolicyId]={0} AND [CompanyId]={1}", Id, CompanyId));
using (IDataReader rdr = DbHelper.ExecuteReader(dc, this.DB))
{
while (rdr.Read())
{
TicketPolicy = new EyouSoft.Model.SiteStructure.TicketPolicy()
{
Id = rdr.GetInt32(rdr.GetOrdinal("PolicyId")),
CompanyId = rdr.IsDBNull(rdr.GetOrdinal("CompanyId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("CompanyId")),
Content = rdr["Content"].ToString(),
FilePath = rdr["FilePath"].ToString(),
Title = rdr["Title"].ToString()
};
}
}
return(TicketPolicy);
}
/// <summary>
/// 保存操作
/// </summary>
/// <param name="Y">bool 保存or保存并继续添加 </param>
private void Save()
{
//初始化Model
EyouSoft.Model.SiteStructure.TicketPolicy ssModel = new EyouSoft.Model.SiteStructure.TicketPolicy();
//初始化BLL
EyouSoft.BLL.SiteStructure.TicketPolicy ssBLL = new EyouSoft.BLL.SiteStructure.TicketPolicy();
if (txt_Title.Text.Trim() == "")//验证标题不能为空
{
MessageBox.ResponseScript(this, Utils.ShowMsg("标题不能为空！"));
lit_Title.Text = "标题不能为空！";
return;
}
///////////修改状态填充原有数据
//判断操作
if (Utils.GetQueryStringValue("type") == "modify")//修改操作
{
//获取id
id = Utils.GetInt(Utils.GetFormValue("tid"));
//获取Model
ssModel = ssBLL.GetTicketPolicy(id, SiteUserInfo.CompanyID);
}
/////////////////////
////////////////////model赋值
ssModel.CompanyId = SiteUserInfo.CompanyID;
//内容
ssModel.Content = txt_Contert.Text;
//判断上传控件个数
if (Request.Files.Count > 0)
{
//上传文件名
string oldfilename = string.Empty;
//上传文件路劲
string filepath = string.Empty;
//上传文件
bool result = EyouSoft.Common.Function.UploadFile.FileUpLoad(Request.Files["workAgree"], "SupplierControlFile", out filepath, out oldfilename);
if (result)
{
//附件路径赋值
ssModel.FilePath = filepath;
}
}
ssModel.Title = Utils.GetFormValue("txt_Title");
bool res = false;//数据 保存是否成功，默认保存失败
if (id > 0)
{
res = ssBLL.UpdateTicketPolicy(ssModel);//修改
}
else
{
res = ssBLL.AddTicketPolicy(ssModel);//添加
}
if (res)
{
/////////////////////////保存成功
MessageBox.ResponseScript(this, string.Format(";alert('{0}');window.parent.Boxy.getIframeDialog('{1}').hide();{2}", "保存成功!", Utils.GetQueryStringValue("iframeId"), id > 0 ? "window.parent.location.reload();" : "window.parent.location.href='/systemset/ToGoTerrace/TickePoliyList.aspx';"));
////////////////////////////////////////////
}
else
{
MessageBox.ResponseScript(this, ";alert('保存失败!');");
}
}
