/// <summary>
/// 页面初始化
/// </summary>
/// <param name="id">编号ID</param>
private void DataInit(int id)
{
//声明上传报价实体
EyouSoft.Model.TourStructure.QuoteAttach model = bll.GetQuoteInfo(id);
if (model != null)
{
//标题
this.txtTitle.Text = model.FileName;
//添加日期
this.txtPeriod.Text = model.AddTime == null?"":Convert.ToDateTime(model.AddTime).ToString("yyyy-MM-dd");
//开始有效期
this.txtValidityBegin.Text = model.ValidityStart == null ? "" : Convert.ToDateTime(model.ValidityStart).ToString("yyyy-MM-dd");
//结束有效期
this.txtValidityEnd.Text = model.ValidityEnd == null ? "" : Convert.ToDateTime(model.ValidityEnd).ToString("yyyy-MM-dd");
this.selectOperator1.OperId = model.OperatorId.ToString();
this.selectOperator1.OperName = model.OperatorName;
if (model.FilePath.Trim() != "")
{
this.lblFileName.Text = "<a href=\"" + model.FilePath + "\" target=\"_blank\">查看报价单</a>";
this.hideFilePath.Value = model.FilePath;
this.pnlFile.Visible = true;
}
else
{
this.pnlFile.Visible = false;
}
}
else
{
this.pnlFile.Visible = false;
}
}
/// <summary>
/// 根据报价编号,获得报价附件信息
/// </summary>
/// <param name="QuoteId">报价编号</param>
/// <returns></returns>
public EyouSoft.Model.TourStructure.QuoteAttach GetQuoteInfo(int QuoteId)
{
EyouSoft.Model.TourStructure.QuoteAttach QuoteAttach = null;
StringBuilder SQL = new StringBuilder();
SQL.AppendFormat("SELECT tbl_Quote.*,(SELECT ContactName FROM [tbl_CompanyUser] where Id=tbl_Quote.OperatorId) as OperatorName FROM [tbl_Quote] WHERE [Id]={0}", QuoteId);
DbCommand cmd = this.DB.GetSqlStringCommand(SQL.ToString());
using (IDataReader rdr = DbHelper.ExecuteReader(cmd, this.DB))
{
while (rdr.Read())
{
QuoteAttach = new EyouSoft.Model.TourStructure.QuoteAttach()
{
Id = rdr.GetInt32(rdr.GetOrdinal("Id")),
CompanyId = rdr.IsDBNull(rdr.GetOrdinal("CompanyId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("CompanyId")),
OperatorId = rdr.IsDBNull(rdr.GetOrdinal("OperatorId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("OperatorId")),
ValidityStart = rdr.IsDBNull(rdr.GetOrdinal("ValidityStart")) ? System.DateTime.Now : rdr.GetDateTime(rdr.GetOrdinal("ValidityStart")),
ValidityEnd = rdr.IsDBNull(rdr.GetOrdinal("ValidityEnd")) ? System.DateTime.Now : rdr.GetDateTime(rdr.GetOrdinal("ValidityEnd")),
FileName = rdr["FileName"].ToString(),
FilePath = rdr["FilePath"].ToString(),
AddTime = rdr.IsDBNull(rdr.GetOrdinal("AddTime")) ? System.DateTime.Now : rdr.GetDateTime(rdr.GetOrdinal("AddTime")),
OperatorName = rdr["OperatorName"].ToString()
};
}
}
return(QuoteAttach);
}
/// <summary>
/// 页面初始化
/// </summary>
protected void DataInit(string fileTitle, DateTime?addTime)
{
//查询model
EyouSoft.Model.TourStructure.QuoteAttach searchModel = new EyouSoft.Model.TourStructure.QuoteAttach();
searchModel.FileName = fileTitle;
searchModel.AddTime = addTime;
searchModel.CompanyId = SiteUserInfo.CompanyID;
//声明list
IList <EyouSoft.Model.TourStructure.QuoteAttach> list = bll.GetQuoteList(SiteUserInfo.CompanyID, pageSize, pageIndex, ref recordCount, searchModel);
//判断list
if (list != null && list.Count > 0)
{
this.rptList.DataSource = list;
this.rptList.DataBind();
//设置分页
BindPage();
//隐藏提示
lblMsg.Visible = false;
}
else
{
//没有数据隐藏分页控件
this.ExportPageInfo1.Visible = false;
lblMsg.Visible = true;
}
//释放服务器资源
list = null;
}
/// <summary>
/// 获得报价附件列表
/// </summary>
/// <param name="companyId">专线公司编号</param>
/// <param name="pageSize">每页显示的记录数</param>
/// <param name="pageIndex">返回第几页</param>
/// <param name="recordCount">返回的记录数</param>
/// <param name="QuoteAttach">报价搜索实体</param>
/// <returns></returns>
public IList <EyouSoft.Model.TourStructure.QuoteAttach> GetQuoteList(int companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.TourStructure.QuoteAttach QuoteAttach)
{
IList <EyouSoft.Model.TourStructure.QuoteAttach> items = new List <EyouSoft.Model.TourStructure.QuoteAttach>();
EyouSoft.Model.TourStructure.QuoteAttach item = null;
StringBuilder cmdQuery = new StringBuilder();
string tableName = "tbl_Quote";
string primaryKey = "Id";
string orderByString = "AddTime DESC";
StringBuilder fields = new StringBuilder();
#region 要查询的字段
fields.Append("Id,CompanyId,FilePath,FileName,OperatorId,(select contactname from dbo.tbl_CompanyUser where id =tbl_Quote.OperatorId) as OperatorName,ValidityStart,ValidityEnd,AddTime");
#endregion
#region 拼接查询条件
cmdQuery.AppendFormat(" CompanyId={0}", companyId);
if (QuoteAttach != null)
{
if (!String.IsNullOrEmpty(QuoteAttach.FileName))
{
cmdQuery.AppendFormat(" and FileName like '%{0}%'", QuoteAttach.FileName);
}
if (QuoteAttach.AddTime.HasValue && QuoteAttach.AddTime != DateTime.MinValue)
{
cmdQuery.AppendFormat(" and DATEDIFF(DAY,'{0}',AddTime)=0", QuoteAttach.AddTime);
}
}
#endregion
using (IDataReader rdr = DbHelper.ExecuteReader(this.DB, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields.ToString(), cmdQuery.ToString(), orderByString))
{
//EyouSoft.DAL.CompanyStructure.CompanyUser CompanyUser = new EyouSoft.DAL.CompanyStructure.CompanyUser();
while (rdr.Read())
{
item = new EyouSoft.Model.TourStructure.QuoteAttach()
{
Id = rdr.GetInt32(rdr.GetOrdinal("Id")),
CompanyId = rdr.IsDBNull(rdr.GetOrdinal("CompanyId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("CompanyId")),
OperatorId = rdr.IsDBNull(rdr.GetOrdinal("OperatorId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("OperatorId")),
OperatorName = rdr["OperatorName"].ToString(),
//ContactPersonInfo=CompanyUser.GetUserBasicInfo(item.OperatorId),
ValidityStart = rdr.IsDBNull(rdr.GetOrdinal("ValidityStart")) ? System.DateTime.Now : rdr.GetDateTime(rdr.GetOrdinal("ValidityStart")),
ValidityEnd = rdr.IsDBNull(rdr.GetOrdinal("ValidityEnd")) ? System.DateTime.Now : rdr.GetDateTime(rdr.GetOrdinal("ValidityEnd")),
FileName = rdr["FileName"].ToString(),
FilePath = rdr["FilePath"].ToString(),
AddTime = rdr.IsDBNull(rdr.GetOrdinal("AddTime")) ? System.DateTime.Now : rdr.GetDateTime(rdr.GetOrdinal("AddTime"))
};
items.Add(item);
}
}
return(items);
}
protected void bind()
{
pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1); //第几页
EyouSoft.BLL.TourStructure.QuoteAttach tsBLL = new EyouSoft.BLL.TourStructure.QuoteAttach(); //初始化bll
EyouSoft.Model.TourStructure.QuoteAttach SearchInfo = null; //初始化model
IList <EyouSoft.Model.TourStructure.QuoteAttach> GetInquireList; //初始化list
GetInquireList = tsBLL.GetQuoteList(SiteUserInfo.CompanyID, pageSize, pageIndex, ref recordCount, SearchInfo); //绑定列表
//绑定
retList.DataSource = GetInquireList;
retList.DataBind();
//分页
BindPage();
}
/// <summary>
/// 更新报价附件信息
/// </summary>
/// <param name="QuoteAttach"></param>
/// <returns></returns>
public bool UpdateQuote(EyouSoft.Model.TourStructure.QuoteAttach QuoteAttach)
{
string SQL = String.Format("UPDATE [tbl_Quote] set CompanyId=@CompanyId,FilePath=@FilePath,FileName=@FileName,OperatorId=@OperatorId,ValidityStart=@ValidityStart,ValidityEnd=@ValidityEnd,AddTime=@AddTime WHERE [Id]={0}", QuoteAttach.Id);
DbCommand dc = this.DB.GetSqlStringCommand(SQL);
this.DB.AddInParameter(dc, "CompanyId", DbType.Int32, QuoteAttach.CompanyId);
this.DB.AddInParameter(dc, "FilePath", DbType.String, QuoteAttach.FilePath);
this.DB.AddInParameter(dc, "FileName", DbType.String, QuoteAttach.FileName);
this.DB.AddInParameter(dc, "OperatorId", DbType.Int32, QuoteAttach.OperatorId);
this.DB.AddInParameter(dc, "ValidityStart", DbType.DateTime, QuoteAttach.ValidityStart);
this.DB.AddInParameter(dc, "ValidityEnd", DbType.DateTime, QuoteAttach.ValidityEnd);
this.DB.AddInParameter(dc, "AddTime", DbType.DateTime, QuoteAttach.AddTime);
return(DbHelper.ExecuteSql(dc, this.DB) > 0 ? true : false);
}
/// <summary>
/// 添加报价附件信息
/// </summary>
/// <param name="QuoteAttach"></param>
/// <returns></returns>
public bool AddQuote(EyouSoft.Model.TourStructure.QuoteAttach QuoteAttach)
{
string SQL = "INSERT INTO [tbl_Quote](CompanyId,FilePath,FileName,OperatorId,ValidityStart,ValidityEnd,AddTime) VALUES(@CompanyId,@FilePath,@FileName,@OperatorId,@ValidityStart,@ValidityEnd,@AddTime)";
DbCommand dc = this.DB.GetSqlStringCommand(SQL);
this.DB.AddInParameter(dc, "CompanyId", DbType.Int32, QuoteAttach.CompanyId);
this.DB.AddInParameter(dc, "FilePath", DbType.String, QuoteAttach.FilePath);
this.DB.AddInParameter(dc, "FileName", DbType.String, QuoteAttach.FileName);
this.DB.AddInParameter(dc, "OperatorId", DbType.Int32, QuoteAttach.OperatorId);
this.DB.AddInParameter(dc, "ValidityStart", DbType.DateTime, QuoteAttach.ValidityStart);
this.DB.AddInParameter(dc, "ValidityEnd", DbType.DateTime, QuoteAttach.ValidityEnd);
this.DB.AddInParameter(dc, "AddTime", DbType.DateTime, QuoteAttach.AddTime);
return(DbHelper.ExecuteSql(dc, this.DB) > 0 ? true : false);
}
/// <summary>
/// 添加报价附件信息
/// </summary>
/// <param name="QuoteAttach"></param>
/// <returns></returns>
public bool AddQuote(EyouSoft.Model.TourStructure.QuoteAttach QuoteAttach)
{
if (dal.AddQuote(QuoteAttach))
{
#region LGWR
EyouSoft.Model.CompanyStructure.SysHandleLogs logInfo = new EyouSoft.Model.CompanyStructure.SysHandleLogs();
logInfo.CompanyId = 0;
logInfo.DepatId = 0;
logInfo.EventCode = EyouSoft.Model.CompanyStructure.SysHandleLogsNO.EventCode;
logInfo.EventIp = string.Empty;
logInfo.EventMessage = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "{0}在" + EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.团队计划_上传报价.ToString() + "上传了一个报价，上传标题：" + QuoteAttach.FileName;
logInfo.EventTime = DateTime.Now;
logInfo.EventTitle = "上传报价";
logInfo.ModuleId = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.团队计划_上传报价;
logInfo.OperatorId = 0;
this.Logwr(logInfo);
return(true);
#endregion
}
return(false);
}
protected void btnSave_Click(object sender, EventArgs e)
{
//标题
string txtTitle = Utils.GetFormValue(this.txtTitle.UniqueID);
//添加日期
string txtPeriod = Utils.GetFormValue(this.txtPeriod.UniqueID);
//有效期 开始
DateTime?validityBegin = Utils.GetDateTimeNullable(Utils.GetFormValue(this.txtValidityBegin.UniqueID));
//有效期 结束
DateTime?validityEnd = Utils.GetDateTimeNullable(Utils.GetFormValue(this.txtValidityEnd.UniqueID));
#region 验证上传文件的格式是否正确
string msg = "";
if (!EyouSoft.Common.Function.UploadFile.CheckFileType(Request.Files, "fileField", new[] { ".gif", ".jpeg", ".jpg", ".png", ".xls", ".doc", ".docx", ".rar", ".txt" }, null, out msg))
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, "javascript:alert('" + msg + "');");
return;
}
#endregion
#region 单文件
//文件路径
string filePath = "";
//文件名
string fileName = "";
//文件上传
if (!EyouSoft.Common.Function.UploadFile.FileUpLoad(Request.Files["fileField"], "TeamPlanFile", out filePath, out fileName))
{
//上传失败提示
EyouSoft.Common.Function.MessageBox.ResponseScript(this, "javascript:alert('保存失败!');");
return;
}
#endregion
//声明对象
EyouSoft.Model.TourStructure.QuoteAttach model = new EyouSoft.Model.TourStructure.QuoteAttach();
model.CompanyId = SiteUserInfo.CompanyID;
model.FileName = txtTitle;
model.OperatorId = Utils.GetInt(this.selectOperator1.OperId);
model.OperatorName = this.selectOperator1.OperName;
model.ValidityStart = validityBegin;
model.ValidityEnd = validityEnd;
model.AddTime = Utils.GetDateTime(txtPeriod);
if (filePath.Trim() != "")
{
model.FilePath = filePath;
}
else
{
model.FilePath = Utils.GetFormValue(this.hideFilePath.UniqueID);
}
//判断是否为修改
if (Utils.GetQueryStringValue("type") == "update")
{
model.Id = Utils.GetInt(Utils.GetQueryStringValue("id"));
bll.UpdateQuote(model);
EyouSoft.Common.Function.MessageBox.ResponseScript(this, "javascript:alert('修改成功!');parent.Boxy.getIframeDialog('" + Request.QueryString["iframeid"] + "').hide();parent.window.location.reload();");
}
else
{
//新增加
model.AddTime = DateTime.Now;
bll.AddQuote(model);
EyouSoft.Common.Function.MessageBox.ResponseScript(this, "javascript:alert('添加成功!');parent.Boxy.getIframeDialog('" + Request.QueryString["iframeid"] + "').hide();parent.window.location.reload();");
}
}
protected void Page_Load(object sender, EventArgs e)
{
tsModel = new EyouSoft.Model.TourStructure.QuoteAttach(); //初始化model
bind(); //绑定
}
/// <summary>
/// 获得报价附件列表
/// </summary>
/// <param name="companyId">专线公司编号</param>
/// <param name="pageSize">每页显示的记录数</param>
/// <param name="pageIndex">返回第几页</param>
/// <param name="recordCount">返回的记录数</param>
/// <param name="QuoteAttach">搜索实体</param>
/// <returns></returns>
public IList <EyouSoft.Model.TourStructure.QuoteAttach> GetQuoteList(int companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.TourStructure.QuoteAttach QuoteAttach)
{
return(dal.GetQuoteList(companyId, pageSize, pageIndex, ref recordCount, QuoteAttach));
}
