/// <summary>
/// 查询条件
/// </summary>
protected void Query()
{
StringBuilder strWhere = new StringBuilder();
strWhere.Append(" 1=1 ");
if (txtLoginName.Text != "")
{
strWhere.Append(" and LoginName='" + CommonManage.TrimSQL(txtLoginName.Text.Trim()) + "'");
}
if (mCompany.RoleType != 1 && mCompany.RoleType != 2)
{
strWhere.Append(" and UninCode = '" + mCompany.UninCode + "'");
}
else if (mCompany.RoleType == 2)
{
strWhere.Append(" and UninCode like '" + mCompany.UninCode + "%'");
}
strWhere.Append(" and len(unincode)<>12 ");
if (txtUninAllNAME.Text != "")
{
strWhere.Append(" and uninAllNAME like '%" + CommonManage.TrimSQL(txtUninAllNAME.Text.Trim()) + "%'");
}
Con = strWhere.ToString();
Curr = 1;
}
/// <summary>
/// 获取查询字符串
/// </summary>
/// <returns></returns>
public string Query()
{
StringBuilder sbWhere = new StringBuilder();
sbWhere.Append(string.Format(" OwnerCpyNo='{0}' and OrderSourceType=4 ", mCompany.UninCode));
//订单号
if (CommonManage.TrimSQL(txtOrderId.Text.Trim()) != "")
{
sbWhere.AppendFormat(" and OrderId='{0}' ", CommonManage.TrimSQL(txtOrderId.Text.Trim()));
}
//航空公司
if (SelectAirCode1.Value != "" && SelectAirCode1.Value != "0")
{
sbWhere.AppendFormat(" and CarryCode like'%{0}%' ", CommonManage.TrimSQL(SelectAirCode1.Value.Trim()));
}
//航班号
if (CommonManage.TrimSQL(txtFlightCode.Text.Trim()) != "")
{
sbWhere.AppendFormat(" and FlightCode like'%{0}%' ", CommonManage.TrimSQL(txtFlightCode.Text.Trim()));
}
//编码
if (CommonManage.TrimSQL(txtPNR.Text.Trim()) != "")
{
sbWhere.AppendFormat(" and PNR='{0}' ", txtPNR.Text.Trim());
}
//出发城市
if (Hid_fromCode.Value != "0" && Hid_fromCode.Value != "")
{
sbWhere.Append(string.Format(" and TravelCode like '%{0}%' ", Hid_fromCode.Value.Trim()));
}
//到达城市
if (Hid_toCode.Value != "0" && Hid_toCode.Value != "")
{
sbWhere.Append(string.Format(" and TravelCode like '%{0}%' ", Hid_toCode.Value.Trim()));
}
//订单状态
if (ddlStatus.SelectedValue != "" && ddlStatus.SelectedValue != "0")
{
sbWhere.Append(string.Format(" and OrderStatusCode = '{0}' ", ddlStatus.SelectedValue.Trim()));
}
//乘机人姓名
if (CommonManage.TrimSQL(txtPassengerName.Text.Trim()) != "")
{
sbWhere.AppendFormat(" and PassengerName like '%{0}%' ", txtPassengerName.Text.Trim().Replace("\'", ""));
}
//乘机日期
if (CommonManage.TrimSQL(txtFromDate1.Value.Trim()) != "" && CommonManage.TrimSQL(txtFromDate2.Value.Trim()) != "")
{
sbWhere.Append(string.Format(" and (AirTime>='{0} 00:00:00' and AirTime<='{1} 23:59:59') ", CommonManage.TrimSQL(txtFromDate1.Value.Trim()), CommonManage.TrimSQL(txtFromDate2.Value.Trim())));
}
//创建日期
if (CommonManage.TrimSQL(txtCreateTime1.Value.Trim()) != "" && CommonManage.TrimSQL(txtCreateTime2.Value.Trim()) != "")
{
sbWhere.Append(string.Format(" and (CreateTime>='{0} 00:00:00' and CreateTime<= '{1} 23:59:59') ", CommonManage.TrimSQL(txtCreateTime1.Value.Trim()), CommonManage.TrimSQL(txtCreateTime2.Value.Trim())));
}
return(sbWhere.ToString());
}
/// <summary>
/// 获取查询字符串
/// </summary>
/// <returns></returns>
public string Query()
{
StringBuilder sbWhere = new StringBuilder();
sbWhere.Append(" (OwnerCpyNo='" + mCompany.UninCode + "' or CPCpyNo='" + mCompany.UninCode + "') and DebtsPayFlag=1 and OrderStatusCode=4 and PayWay=14 ");
//订单号
if (CommonManage.TrimSQL(txtOrderId.Text.Trim()) != "")
{
sbWhere.AppendFormat(" and OrderId='{0}' ", CommonManage.TrimSQL(txtOrderId.Text.Trim()));
}
//航空公司
if (!string.IsNullOrEmpty(SelectAirCode1.Value))
{
sbWhere.AppendFormat(" and CarryCode like '%{0}%' ", CommonManage.TrimSQL(SelectAirCode1.Value.Trim()));
}
//航班号
if (CommonManage.TrimSQL(txtFlightCode.Text.Trim()) != "")
{
sbWhere.AppendFormat(" and FlightCode like '%{0}%' ", CommonManage.TrimSQL(txtFlightCode.Text.Trim()));
}
//编码
if (CommonManage.TrimSQL(txtPNR.Text.Trim()) != "")
{
sbWhere.AppendFormat(" and PNR='{0}' ", txtPNR.Text.Trim());
}
//出发城市
if (Hid_fromCode.Value != "0" && Hid_fromCode.Value != "")
{
sbWhere.Append(string.Format(" and TravelCode like '{0}%' ", Hid_fromCode.Value.Trim()));
}
//到达城市
if (Hid_toCode.Value != "0" && Hid_toCode.Value != "")
{
sbWhere.Append(string.Format(" and TravelCode like '%{0}' ", Hid_toCode.Value.Trim()));
}
//乘机人姓名
if (CommonManage.TrimSQL(txtPassengerName.Text.Trim()) != "")
{
sbWhere.AppendFormat(" and PassengerName like '%{0}%' ", txtPassengerName.Text.Trim().Replace("\'", ""));
}
//创建人公司
if (CommonManage.TrimSQL(txtcreatecpy.Text.Trim()) != "")
{
sbWhere.AppendFormat(" and CreateCpyName like '%{0}%' ", CommonManage.TrimSQL(txtcreatecpy.Text.Trim()));
}
//乘机日期
if (CommonManage.TrimSQL(txtFromDate1.Value.Trim()) != "" && CommonManage.TrimSQL(txtFromDate2.Value.Trim()) != "")
{
sbWhere.Append(string.Format(" and (AirTime>='{0} 00:00:00' and AirTime<='{1} 23:59:59') ", CommonManage.TrimSQL(txtFromDate1.Value.Trim()), CommonManage.TrimSQL(txtFromDate2.Value.Trim())));
}
//创建日期
if (CommonManage.TrimSQL(txtCreateTime1.Value.Trim()) != "" && CommonManage.TrimSQL(txtCreateTime2.Value.Trim()) != "")
{
sbWhere.Append(string.Format(" and (CreateTime>='{0} 00:00:00' and CreateTime<= '{1} 23:59:59') ", CommonManage.TrimSQL(txtCreateTime1.Value.Trim()), CommonManage.TrimSQL(txtCreateTime2.Value.Trim())));
}
return(sbWhere.ToString());
}
/// <summary>
/// 导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnOut_Click(object sender, EventArgs e)
{
Hparams.Add("CpyNo", mUser.CpyNo.Trim());
Hparams.Add("LoginName", CommonManage.TrimSQL(txtUserAccount.Text.Trim()));
Hparams.Add("TimeStart", txtTimeBegin.Value);
Hparams.Add("TimeEnd", txtTimeEnd.Value + " 23:59:59");
dsSalesInfoCollect = base.baseDataManage.MulExecProc("pro_AirChangeStatistics", Hparams);
ExcelRender.RenderToExcel(dsSalesInfoCollect[0], Context, "航变统计报表" + DateTime.Now.ToString("yyyy_MM_dd_hh_mm_ss") + ".xls");
}
/// <summary>
/// 页面显示
/// </summary>
/// <param name="type"></param>
/// <param name="obj"></param>
/// <returns></returns>
public string ShowText(int type, params object[] obj)
{
string result = "";
if (type == 0)
{
//显示下载附件
if (obj != null && obj.Length == 3)
{
string FileName = obj[0].ToString().Split('|')[0];
byte[] b = obj[1] as byte[];
if (b != null && b.Length > 10)
{
result = FileName + "【<a href='Manager/Sys/DownLoadFile.aspx?did=" + obj[2].ToString() + "¤tuserid=" + this.currentuserid.Value.ToString() + "'>下载附件</a>】";
}
}
}
else if (type == 1)//是否紧急公告
{
if (obj != null && obj.Length == 1)
{
if (obj[0] != null && obj[0].ToString() == "1")
{
result = "<font class=\"red\">紧急公告</font>";
}
else
{
result = "<font>普通公告</font>";
}
}
}
else if (type == 2)//紧急公告标题加红
{
if (obj != null && obj.Length == 3)
{
if (obj[0].ToString() == "1")
{
result = "<a target=\"_blank\" href=\"Manager/Sys/LookBulletin.aspx?id=" + obj[2].ToString() + "¤tuserid=" + this.currentuserid.Value.ToString() + "\"><font class=\"red\">" + obj[1].ToString() + "</font></a>";
}
else
{
result = "<a target=\"_blank\" href=\"Manager/Sys/LookBulletin.aspx?id=" + obj[2].ToString() + "¤tuserid=" + this.currentuserid.Value.ToString() + "\">" + obj[1].ToString() + "</a>";
}
}
}
else if (type == 3)//公告内容特殊字符处理
{
if (obj != null && obj.Length == 1)
{
result = CommonManage.StripHTML(CommonManage.ReplaceCharToXML(obj[0].ToString()));
}
}
return(result);
}
/// <summary>
/// 查询条件
/// </summary>
protected void Query()
{
StringBuilder strWhere = new StringBuilder();
strWhere.Append(mCompany.RoleType == 1 ? "1=1" : "CpyNo='" + mCompany.UninCode + "'");
if (txtGroupName.Text != "")
{
strWhere.Append(" and GroupName like '%" + CommonManage.TrimSQL(txtGroupName.Text.Trim()) + "%'");
}
Con = strWhere.ToString();
}
/// <summary>
/// 绑定数据
/// </summary>
protected void PageDataBind()
{
Hparams.Add("CpyNo", mUser.CpyNo.Trim());
Hparams.Add("LoginName", CommonManage.TrimSQL(txtUserAccount.Text.Trim()));
Hparams.Add("TimeStart", txtTimeBegin.Value);
Hparams.Add("TimeEnd", txtTimeEnd.Value + " 23:59:59");
dsSalesInfoCollect = base.baseDataManage.MulExecProc("pro_AirChangeStatistics", Hparams);
gvinfo.DataSource = dsSalesInfoCollect[0];
gvinfo.DataBind();
}
public void DeleteMessageFile(string xxbh, Action action)
{
string path = HttpContext.Current.Server.MapPath(CommonManage.GetLocalMessagePath(xxbh));
if (Directory.Exists(path))
{
Directory.Delete(path, true);
}
if (action != null)
{
action();
}
}
public bool SaveItem(Xm_Ysxx ysxx, List <Item_File> itemFile)
{
ArrayList strSql = new ArrayList();
string tmpSql = string.Empty;
////预算信息
strSql.Add(SqlBuilder.BuildDeleteSql <Xm_Ysxx>(CommonManage.delWhere(ysxx.ITEMCODE)));
strSql.Add(SqlBuilder.BuildInsertSql(ysxx));
////文件
new BusiItemManage().SaveItemFile(ysxx.ITEMCODE, WorkFlowNode.JunGong, itemFile, ref strSql);
return(OracleHelper.ExecuteCommand(strSql));
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void lbsave_Click(object sender, EventArgs e)
{
string msg = "";
IHashObject parameter = new HashObject();
try
{
if (mCompany.RoleType != 1)
{
msg = "此用户无权限操作";
}
else
{
if (Convert.ToDateTime(txtBeginTime.Value) > Convert.ToDateTime(txtEndTime.Value))
{
msg = "生效日期不能大于失效日期";
}
else
{
parameter.Add("Cabin", CommonManage.TrimSQL(txtCabin.Text.Trim()));
parameter.Add("CabinName", CommonManage.TrimSQL(txtCabinName.Text.Trim()));
parameter.Add("AirCode", CommonManage.TrimSQL(txtAirCode.Text.Trim()));
parameter.Add("AirShortName", CommonManage.TrimSQL(txtAirSPortName.Text.Trim()));
parameter.Add("StartTime", Convert.ToDateTime(txtBeginTime.Value));
parameter.Add("EndTime", Convert.ToDateTime(CommonManage.TrimSQL(txtEndTime.Value.Trim())));
parameter.Add("Rebate", decimal.Parse(txtDiscountRate.Text));
if (Request.QueryString["Id"] != null && Request.QueryString["Id"].ToString().Length != 0)
{
#region 修改
parameter.Add("id", Guid.Parse(Request["Id"]));
msg = (bool)baseDataManage.CallMethod("Bd_Air_BaseCabin", "Update", null, new object[] { parameter }) == true ? "更新成功" : "更新失败";
#endregion
}
else
{
#region 添加
parameter.Add("AddTime", Convert.ToDateTime(DateTime.Now));
msg = (bool)baseDataManage.CallMethod("Bd_Air_BaseCabin", "Insert", null, new Object[] { parameter }) == true ? "添加成功" : "添加失败";
#endregion
}
}
}
}
catch (Exception)
{
msg = "操作异常";
}
ScriptManager.RegisterStartupScript(this, GetType(), "", "showdialog('" + msg + "');", true);
}
/// <summary>
/// 查询条件
/// </summary>
public void SelWhere()
{
try
{
Curr = 1;
StringBuilder strWhere = new StringBuilder();
strWhere.Append(" IsAdmin <> 0 and id <> '" + mUser.id + "' and CpyNo='" + mCompany.UninCode + "'");
if (WorkNum.Text != "")
{
strWhere.Append(" and WorkNum like '%" + CommonManage.TrimSQL(WorkNum.Text) + "%'");
}
if (UserName.Text != "")
{
strWhere.Append(" and UserName like '%" + CommonManage.TrimSQL(UserName.Text) + "%'");
}
if (Tel.Text != "")
{
strWhere.Append(" and Tel like '%" + CommonManage.TrimSQL(Tel.Text) + "%'");
}
if (CertificateNum.Text != "")
{
strWhere.Append(" and CertificateNum like '%" + CommonManage.TrimSQL(CertificateNum.Text) + "%'");
}
if (Sex.SelectedValue != "ALL")
{
strWhere.Append(" and Sex =" + Sex.SelectedValue);
}
if (Phone.Text != "")
{
strWhere.Append(" and Phone like '%" + CommonManage.TrimSQL(Phone.Text) + "%'");
}
//部门
if (ddlBM.SelectedValue != "0")
{
strWhere.Append(" and DeptId = '" + ddlBM.SelectedValue + "'");
}
//状态
if (ddlStatus.SelectedValue != "-1")
{
strWhere.Append(" and State = " + ddlStatus.SelectedValue);
}
Con = strWhere.ToString();
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 查询条件
/// </summary>
protected void Query()
{
StringBuilder strWhere = new StringBuilder();
strWhere.Append(mCompany.RoleType == 1 ? " 1=1 " : " (CpyNo='" + mCompany.UninCode + "' or OperCpyNo='" + mCompany.UninCode + "')");
if (txtCopName.Text != "")
{
strWhere.Append(" and CpyName like '%" + CommonManage.TrimSQL(txtCopName.Text.Trim()) + "%'");
}
if (txtTerminalNo.Text != "")
{
strWhere.Append(" and PosNo like '%" + CommonManage.TrimSQL(txtTerminalNo.Text.Trim()) + "%'");
}
Con = strWhere.ToString();
Curr = 1;
}
/// <summary>
/// 查询条件
/// </summary>
/// <returns></returns>
private string Query()
{
StringBuilder sb = new StringBuilder("OrderStatusCode in (4,16,17)");
if (mCompany.RoleType != 1 && mCompany.RoleType != 2)
{
sb.Append(" and UninCode = '" + mCompany.UninCode + "'");
}
else if (mCompany.RoleType == 2)
{
sb.Append(" and UninCode like '" + mCompany.UninCode + "%'");
}
if (txtCPTimeBegin.Value.Trim() != "")
{
sb.Append(" and _order.CPTime >= convert(DateTime, '" + txtCPTimeBegin.Value + "')");
}
if (txtCPTimeEnd.Value.Trim() != "")
{
sb.Append(" and _order.CPTime <= convert(DateTime, '" + txtCPTimeEnd.Value + " 23:59:59')");
}
if (txtTo.Text.Trim() != "")
{
sb.Append(" and _cpy.UninAllName like'%" + CommonManage.TrimSQL(txtTo.Text.Trim()) + "%'");
}
if (txtUserAccount.Text.Trim() != "")
{
sb.Append(" and _user.LoginName like'%" + CommonManage.TrimSQL(txtUserAccount.Text.Trim()) + "%'");
}
if (ddlCarrier.Value != "0" && ddlCarrier.Value != "")
{
sb.Append(" and _order.CarryCode = '" + ddlCarrier.Value + "'");
}
if (ddlpaytype.SelectedValue != "")
{
sb.Append(" and _order.PayWay = '" + ddlpaytype.SelectedValue + "'");
}
if (txtStartCity.Text != "")
{
sb.Append(" and _order.Travel like '" + CommonManage.TrimSQL(txtStartCity.Text.Trim()) + "%'");
}
return(sb.ToString());
}
/// <summary>
/// 收回项目
/// </summary>
/// <param name="itemCode">项目编号</param>
/// <param name="userid">收回用户</param>
/// <returns></returns>
public string UndoInstance(string itemCode, string userid)
{
string tmpSql = string.Empty;
tmpSql = "select * from ("
+ " select * from wf_instance where flowid = '{0}' and itemcode = '{1}' "
+ " and userId = {2} and state = 1 order by orderno desc) where rownum = 1";
tmpSql = string.Format(tmpSql, strFlowId, itemCode, userid);
DataTable dt = OracleHelper.ExecuteDataTable(tmpSql);
if (dt.Rows.Count != 1)
{
return(string.Empty);
}
string orderno = dt.Rows[0]["orderno"].ToString();
string nodeid = dt.Rows[0]["nodeid"].ToString();
ArrayList strSql = new ArrayList();
tmpSql = "delete from wf_instance where flowid = {0} and itemCode = {1} and state = 0";
tmpSql = string.Format(tmpSql, strFlowId, itemCode);
strSql.Add(tmpSql);
tmpSql = "update wf_instance set state = 0 where flowid = {0} and itemCode = {1} and orderno = {2}";
tmpSql = string.Format(tmpSql, strFlowId, itemCode, orderno);
strSql.Add(tmpSql);
tmpSql = "update xm_xmxx set nodeid = {1},itemStage = {2} where itemCode = {0}";
tmpSql = string.Format(tmpSql, itemCode, nodeid,
((int)CommonManage.nodeToStage((WorkFlowNode)EnumHelper.StringValueToEnum(typeof(WorkFlowNode), nodeid))).ToString());
strSql.Add(tmpSql);
if (nodeid == ((int)WorkFlowNode.TB).ToString())
{
//tmpSql = "update xm_xmxx set ItemState = 0,flowId ='',itemstage ='',sbsj ='' where itemCode = {0}";
tmpSql = "update xm_xmxx set ItemState = 0 where itemCode = {0}";
tmpSql = string.Format(tmpSql, itemCode);
strSql.Add(tmpSql);
}
if (OracleHelper.ExecuteCommand(strSql))
{
return(nodeid);
}
return(string.Empty);
}
/// <summary>
/// 查询条件
/// </summary>
/// <returns></returns>
private string Query()
{
StringBuilder sb = new StringBuilder("");
switch (ViewState["paytype"].ToString())
{
case "zh":
sb.Append("(_logmd.PayType in (13,14) or (_logmd.PayType not in (13,14) and (_logmd.Remark like '%充值%' or _logmd.OperReason like '%充值%'))) and _logmd.Remark not like '%欠款明细记录%' and _logmd.OperReason not like '%欠款明细记录%'");
break;
case "zx":
sb.Append("_logmd.PayType not in (13,14,15,20,21)");
break;
case "qkxz":
sb.Append("PayType = 21");
break;
}
if (mCompany.RoleType != 1 && mCompany.RoleType != 2)
{
sb.Append(" and _cpy.UninCode = '" + mCompany.UninCode + "'");
}
else if (mCompany.RoleType == 2)
{
sb.Append(" and _cpy.UninCode like '" + mCompany.UninCode + "%' and len(unincode)<>12");
}
if (txtTo.Text.Trim() != "")
{
sb.Append(" and _cpy.UninAllName like '%" + CommonManage.TrimSQL(txtTo.Text.Trim()) + "%'");
}
if (txtUserAccount.Text.Trim() != "")
{
sb.Append(" and _user.LoginName like '%" + CommonManage.TrimSQL(txtUserAccount.Text.Trim()) + "%'");
}
if (txtGoAlongTime1.Value.Trim() != "")
{
sb.Append(" and _logmd.OperTime >= convert(DateTime, '" + txtGoAlongTime1.Value + "')");
}
if (txtGoAlongTime2.Value.Trim() != "")
{
sb.Append(" and _logmd.OperTime <= convert(DateTime, '" + txtGoAlongTime2.Value + " 23:59:59')");
}
return(sb.ToString());
}
/// <summary>
/// 支付
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnPay_Click(object sender, EventArgs e)
{
string pwd = CommonManage.TrimSQL(txtAccountPayPwd.Text.Trim());
string payWay = hidPayWay.Value.ToString();
pwd = PbProject.WebCommon.Web.Cookie.SiteCookie.GetMD5(pwd);//原支付密码
//账户余额
if (payWay == "14" && mCompany.AccountPwd != pwd)
{
Page.ClientScript.RegisterStartupScript(GetType(), Guid.NewGuid().ToString(), "showdialogOne('支付失败!支付密码错误！');", true);
}
else
{
CreateOrder();
}
DataBindInfo();
}
public bool SaveItem(Xm_GhsjYsxx itemGhys, List <Item_File> itemFile,
Xm_Xmzj itemZj, Xm_Gcxx itemGcxx, Xm_Xmdw itemDw)
{
ArrayList strSql = new ArrayList();
string tmpSql = string.Empty;
////项目规划设计信息
strSql.Add(SqlBuilder.BuildDeleteSql <Xm_GhsjYsxx>(CommonManage.delWhere(itemGhys.ItemCode)));
strSql.Add(SqlBuilder.BuildInsertSql(itemGhys));
////文件
new BusiItemManage().SaveItemFile(itemGhys.ItemCode, WorkFlowNode.GHSJYS, itemFile, ref strSql);
////资金
new BusiItemManage().SaveItemMoney(itemGhys.ItemCode, WorkFlowNode.GHSJYS, itemZj, ref strSql);
////工程
new BusiItemManage().SaveItemGcxx(itemGhys.ItemCode, itemGcxx, ref strSql);
////单位
new BusiItemManage().SaveItemCompany(itemGhys.ItemCode, ItemCompanyType.GH, itemDw, ref strSql);
return(OracleHelper.ExecuteCommand(strSql));
}
/// <summary>
/// 查询条件
/// </summary>
protected void Query()
{
try
{
Curr = 1;
StringBuilder WhereStr = new StringBuilder(" 1=1");
if (mCompany.UninCode.Length == 6)
{
WhereStr.Append(" and (ReleaseCpyNo='" + mCompany.UninCode + "' or (len(ReleaseCpyNo)=12 and ReleaseCpyNo like '" + mCompany.UninCode + "%'))");
}
else
{
WhereStr.Append(" and ReleaseCpyNo='" + mCompany.UninCode + "'");
}
if (NoticeTitle.Text != "")
{
WhereStr.Append(" and Title like'%" + CommonManage.TrimSQL(NoticeTitle.Text.Trim()) + "%'");
}
if (ReleaseName.Text != "")
{
WhereStr.Append(" and ReleaseName like'%" + CommonManage.TrimSQL(ReleaseName.Text.Trim()) + "%'");
}
if (CallboardType.SelectedValue != "==请选择状态==")
{
WhereStr.Append(" and CallboardType =" + CallboardType.SelectedValue + "");
}
if (ReleaseDateSta.Text != "")
{
WhereStr.Append(" and ReleaseTime >='" + CommonManage.TrimSQL(ReleaseDateSta.Text.Trim()) + "'");
}
if (ReleaseDateStp.Text != "")
{
WhereStr.Append(" and ReleaseTime <='" + CommonManage.TrimSQL(ReleaseDateStp.Text.Trim()) + "'");
}
Con = WhereStr.ToString();
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 绑定数据
/// </summary>
protected void PageDataBind()
{
Hparams.Add("CpyName", CommonManage.TrimSQL(txtCpyName.Text.Trim()));
Hparams.Add("CpyNo", mUser.CpyNo.Trim());
Hparams.Add("LoginName", CommonManage.TrimSQL(txtUserAccount.Text.Trim()));
Hparams.Add("TimeStart", txtTimeBegin.Value);
Hparams.Add("TimeEnd", txtTimeEnd.Value + " 23:59:59");
DataTable[] dsSalesInfoCollect = null;
dsSalesInfoCollect = base.baseDataManage.MulExecProc("pro_TrafficStatistics", Hparams);
DataView dview = new DataView(dsSalesInfoCollect[0]);
this.AspNetPager1.RecordCount = dview.Count;
PagedDataSource pds = new PagedDataSource();
pds.DataSource = dview;
pds.AllowPaging = true;
pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
pds.PageSize = AspNetPager1.PageSize;
gvinfo.DataSource = pds;
gvinfo.DataBind();
}
public override void Sync()
{
MessageManage messageManage = new MessageManage();
Action <DataRow> actionAddLocalMessageFile = new Action <DataRow>((dr) =>
{
string xxbh = dr["xxbh"].ToString();
string messageFtpPath = CommonManage.GetFtpMessagePath();
LogOperation.Append(sbLog, "从" + targetCode + "到" + localCode + "同步系统消息（" + xxbh + "）的文件。");
targetFtp.CopyDirectory(messageFtpPath, xxbh, localFtp, messageFtpPath, xxbh, null);
});
Action <DataRow> actionAddTargetMessageFile = new Action <DataRow>((dr) =>
{
string xxbh = dr["xxbh"].ToString();
string messageFtpPath = CommonManage.GetFtpMessagePath();
LogOperation.Append(sbLog, "从" + localCode + "到" + targetCode + "同步系统消息（" + xxbh + "）的文件。");
localFtp.CopyDirectory(messageFtpPath, xxbh, targetFtp, messageFtpPath, xxbh, null);
});
Action <DataRow> actionDeleteLocalMessageFile = new Action <DataRow>((dr) =>
{
string xxbh = dr["xxbh"].ToString();
LogOperation.Append(sbLog, "删除" + localCode + "的系统消息（" + xxbh + "）的文件。");
localFtp.DeleteDirectory(CommonManage.GetFtpMessagePath(xxbh));
});
Action <DataRow> actionDeleteTargetMessageFile = new Action <DataRow>((dr) =>
{
string xxbh = dr["xxbh"].ToString();
LogOperation.Append(sbLog, "删除" + targetCode + "的系统消息（" + xxbh + "）的文件。");
targetFtp.DeleteDirectory(CommonManage.GetFtpMessagePath(xxbh));
});
LogOperation.WriteTitle(sbLog, "同步系统消息开始（从" + targetCode + "到" + localCode + "）。");
SyncXxbh(targetDb, localDb, localCode, actionAddLocalMessageFile,
actionDeleteTargetMessageFile, actionDeleteLocalMessageFile);
LogOperation.WriteTitle(sbLog, "同步系统消息结束（从" + targetCode + "到" + localCode + "）。");
LogOperation.WriteTitle(sbLog, "同步系统消息开始（从" + localCode + "到" + targetCode + "）。");
SyncXxbh(localDb, targetDb, targetCode, actionAddTargetMessageFile,
actionDeleteLocalMessageFile, actionDeleteTargetMessageFile);
LogOperation.WriteTitle(sbLog, "同步系统消息结束（从" + localCode + "到" + targetCode + "）。");
}
public bool SaveItem(Xm_Jsxx jsxx, Xm_Xmzj itemZj, List <Item_File> itemFile)
{
ArrayList strSql = new ArrayList();
string tmpSql = string.Empty;
////项目决算
strSql.Add(SqlBuilder.BuildDeleteSql <Xm_Jsxx>(CommonManage.delWhere(jsxx.ITEMCODE)));
strSql.Add(SqlBuilder.BuildInsertSql(jsxx));
////资金
new BusiItemManage().SaveItemMoney(jsxx.ITEMCODE, WorkFlowNode.JueSuan, itemZj, ref strSql);
////文件
new BusiItemManage().SaveItemFile(jsxx.ITEMCODE, WorkFlowNode.JueSuan, itemFile, ref strSql);
////更新主表
if (jsxx.SCDASJ.HasValue)
{
tmpSql = "update xm_xmxx set JSSJ = to_date('{0}','yyyy-mm-dd') where ITEMCODE = '{1}'";
tmpSql = string.Format(tmpSql, jsxx.SCDASJ.Value.ToString("yyyy-MM-dd"), jsxx.ITEMCODE);
strSql.Add(tmpSql);
}
return(OracleHelper.ExecuteCommand(strSql));
}
public bool SaveItem(Xm_Xmxx itemInfo, Xm_Sb_Jbxx itemSb,
List <Item_File> itemFile, Xm_Xmzj itemZj, Xm_Gcxx itemGcxx)
{
ArrayList strSql = new ArrayList();
string tmpSql = string.Empty;
//// 项目主表
strSql.Add(SqlBuilder.BuildDeleteSql <Xm_Xmxx>(CommonManage.delWhere(itemInfo.ItemCode)));
strSql.Add(SqlBuilder.BuildInsertSql(itemInfo));
////项目申报信息
strSql.Add(SqlBuilder.BuildDeleteSql <Xm_Sb_Jbxx>(CommonManage.delWhere(itemSb.ItemCode)));
strSql.Add(SqlBuilder.BuildInsertSql(itemSb));
////文件
new BusiItemManage().SaveItemFile(itemInfo.ItemCode, WorkFlowNode.TB, itemFile, ref strSql);
////资金
new BusiItemManage().SaveItemMoney(itemInfo.ItemCode, WorkFlowNode.TB, itemZj, ref strSql);
////工程
new BusiItemManage().SaveItemGcxx(itemInfo.ItemCode, itemGcxx, ref strSql);
////GIS信息
return(OracleHelper.ExecuteCommand(strSql));
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btsave_Click(object sender, EventArgs e)
{
try
{
IHashObject parameter = new HashObject();
parameter.Add("OrderId", Request["orderid"].ToString());
parameter.Add("OperType", "协调");
parameter.Add("OperTime", DateTime.Now);
parameter.Add("OperLoginName", mUser.LoginName);
parameter.Add("OperUserName", mUser.UserName);
parameter.Add("CpyNo", mUser.CpyNo);
parameter.Add("CpyType", mCompany.RoleType);
parameter.Add("CpyName", mCompany.UninAllName);
parameter.Add("OperContent", CommonManage.TrimSQL(ddltype.SelectedValue + "|" + txtRemark.Text.Trim()).TrimEnd('|'));
parameter.Add("WatchType", mCompany.RoleType == 1 ? "1" : "2");//判断登录用户是否是平台（只有平台和运营可以进此页面）
if ((bool)baseDataManage.CallMethod("Log_Tb_AirOrder", "Insert", null, new Object[] { parameter }) == true)
{
DataBind(Request["orderid"].ToString());
Log_Operation logoper = new Log_Operation();
logoper.ModuleName = "协调";
logoper.LoginName = mUser.LoginName;
logoper.UserName = mUser.UserName;
logoper.CreateTime = Convert.ToDateTime(DateTime.Now);
logoper.CpyNo = mCompany.UninCode;
logoper.OperateType = ddltype.SelectedValue;
logoper.OptContent = CommonManage.TrimSQL(ddltype.SelectedValue + "|" + txtRemark.Text.Trim()).TrimEnd('|');
new PbProject.Logic.Log.Log_OperationBLL().InsertLog_Operation(logoper);//添加日志
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('失败');", true);
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 显示部分字符
/// </summary>
/// <param name="Str"></param>
/// <param name="Len"></param>
/// <returns></returns>
public string SubChar(object Str, int Len, string replaceSchar)
{
string reStr = "";
if (Str == null)
{
return(reStr);
}
reStr = CommonManage.StripHTML(CommonManage.ReplaceCharToXML(Str.ToString()));
if (!string.IsNullOrEmpty(reStr))
{
if (reStr.Length > Len)
{
reStr = reStr.Substring(0, Len) + " " + replaceSchar;
}
}
else
{
reStr = "";
}
return(reStr);
}
public bool SaveItem(Xm_Xmxx itemInfo, Xm_Ky_Jbxx itemKy,
List <Item_File> itemFile, Xm_Xmzj itemZj, Xm_Gcxx itemGcxx, Xm_Xmdw itemDw)
{
ArrayList strSql = new ArrayList();
string tmpSql = string.Empty;
//// 项目主表
strSql.Add(SqlBuilder.BuildUpdateSql(itemInfo));
////项目可研信息
strSql.Add(SqlBuilder.BuildDeleteSql <Xm_Ky_Jbxx>(CommonManage.delWhere(itemKy.ItemCode)));
strSql.Add(SqlBuilder.BuildInsertSql(itemKy));
////文件
new BusiItemManage().SaveItemFile(itemInfo.ItemCode, WorkFlowNode.KY, itemFile, ref strSql);
////资金
new BusiItemManage().SaveItemMoney(itemInfo.ItemCode, WorkFlowNode.KY, itemZj, ref strSql);
////工程
new BusiItemManage().SaveItemGcxx(itemInfo.ItemCode, itemGcxx, ref strSql);
////单位
new BusiItemManage().SaveItemCompany(itemInfo.ItemCode, ItemCompanyType.KY, itemDw, ref strSql);
////GIS信息
return(OracleHelper.ExecuteCommand(strSql));
}
/// <summary>
/// 查询条件
/// </summary>
/// <returns></returns>
private string Query()
{
StringBuilder sb = new StringBuilder();
if (mCompany.RoleType == 1)
{
sb.Append(" 1=1");
}
else if (mCompany.RoleType == 2)
{
sb.Append(" (_order.OwnerCpyNo like '" + mCompany.UninCode + "%' or _order.CPCpyNo like '" + mCompany.UninCode + "%')");
}
else
{
sb.Append(" (_order.OwnerCpyNo = '" + mCompany.UninCode + "' or _order.CPCpyNo = '" + mCompany.UninCode + "')");
}
//政策来源
if (ViewState["BillType"].ToString() == "local")
{
sb.Append(" and (_order.PolicySource in (1,2) or (_order.PolicySource=9 and _order.CPCpyNo='" + mCompany.UninCode + "'))");
}
else
{
sb.Append(" and (_order.PolicySource in (3,4,5,6,7,8,10) or (_order.PolicySource=9 and _order.CPCpyNo <> '" + mCompany.UninCode + "'))");
}
//支付时间
if (txtPayTime1.Value.Trim() != "")
{
sb.Append(" and _order.PayTime >= convert(DateTime, '" + txtPayTime1.Value + " 00:00:00')");
}//支付时间
if (txtPayTime2.Value.Trim() != "")
{
sb.Append(" and _order.PayTime <= convert(DateTime, '" + txtPayTime2.Value + " 23:59:59')");
}
//出退费票时间
if (cptimestart.Value.Trim() != "" && cptimeend.Value.Trim() != "")
{
sb.Append(" and _order.CPTime >= convert(DateTime, '" + cptimestart.Value + " 00:00:00') and _order.CPTime <= convert(DateTime, '" + cptimeend.Value + " 23:59:59')");
}
//创建时间
if (txtCreateTime1.Value.Trim() != "")
{
sb.Append(" and _order.CreateTime >= convert(DateTime, '" + txtCreateTime1.Value + " 00:00:00')");
}
//创建时间
if (txtCreateTime2.Value.Trim() != "")
{
sb.Append(" and _order.CreateTime <= convert(DateTime, '" + txtCreateTime2.Value + " 23:59:59')");
}
//是否做过退费
if (showtf.Checked == false)
{
if (ddlTicketState.SelectedValue == "2")
{
sb.Append(" and _passenger.IsBack != 'true'");
}
}
//支付方式
if (ddlPayWay.SelectedValue != "")
{
sb.Append(" and _order.PayWay=" + ddlPayWay.SelectedValue);
}
//订单状态
if (ddlTicketState.SelectedValue != "")
{
sb.Append(" and OrderStatusCode = " + ddlTicketState.SelectedValue);
}
//城市对
if (hiStart.Value.Trim() != "" && txtStart.Text != "中文/拼音")
{
sb.Append(" and TravelCode like '" + hiStart.Value.Trim() + "%'");
}
if (hiTarget.Value.Trim() != "" && txtTarget.Text != "中文/拼音")
{
sb.Append(" and TravelCode like '%" + hiTarget.Value.Trim() + "'");
}
//航空公司
if (ddlCarrier.Value != "")
{
sb.Append(" and _order.CarryCode like '%" + ddlCarrier.Value + "%'");
}
//订单号
if (txtOrderId.Text.Trim() != "")
{
sb.Append(" and _order.Orderid like '%" + CommonManage.TrimSQL(txtOrderId.Text.Trim()) + "%'");
}
//编码
if (txtPNR.Text.Trim() != "")
{
sb.Append(" and PNR like '%" + CommonManage.TrimSQL(txtPNR.Text.Trim()) + "%'");
}
//操作人
if (txtCPUser.Text.Trim() != "")
{
sb.Append(" and CPName like '%" + CommonManage.TrimSQL(txtCPUser.Text.Trim()) + "%'");
}
//客户名称
if (txtCustomer.Text.Trim() != "")
{
sb.Append(" and _cpy.UninAllName like '%" + CommonManage.TrimSQL(txtCustomer.Text.Trim()) + "%'");
}
//客户帐号
if (txtLoginName.Text.Trim() != "")
{
sb.Append(" and _user.LoginName like '%" + CommonManage.TrimSQL(txtLoginName.Text.Trim()) + "%'");
}
return(sb.ToString());
}
/// <summary>
/// 查询条件
/// </summary>
/// <returns></returns>
private string SelWhere(bool IsTKZ)
{
StringBuilder StrWhere = new StringBuilder(" A1=1 ");
if (mCompany.RoleType == 1)
{
if (ddlGYList.Value != "")
{
StrWhere.AppendFormat(" and (CPCpyNo='{0}' or left(OwnerCpyNo,12)= '{0}' ) ", ddlGYList.Value); //可查询共享
}
}
else if (mCompany.RoleType == 2)
{
StrWhere.Append(" and (CPCpyNo='" + mUser.CpyNo + "' or left(OwnerCpyNo,12)= '" + mUser.CpyNo + "' ) "); //可查询共享
}
else if (mCompany.RoleType == 3)
{
StrWhere.Append(" and CPCpyNo='" + mUser.CpyNo + "' ");
}
else if (mCompany.RoleType == 4 || mCompany.RoleType == 5)
{
StrWhere.Append(" and OwnerCpyNo='" + mUser.CpyNo + "' ");
}
try
{
//订单号或者票号
if (!string.IsNullOrEmpty(CommonManage.TrimSQL(txtOrderId.Text.Trim())))
{
string OrderIdAndTicketNumber = CommonManage.TrimSQL(txtOrderId.Text.Replace("-", "").Trim());
//string pattern = @"^\d{3,4}(\-?|\s+)\d{10}$";
//if (Regex.Match(OrderIdAndTicketNumber, pattern, RegexOptions.IgnoreCase).Success)
//{
//票号
//StrWhere.AppendFormat(" and dbo.GetTicketNumber(OrderId) like '%|{0}|%' ", OrderIdAndTicketNumber);
//Kevin 2013-06-05 Edit 解决条件查询慢的问题
//StrWhere.AppendFormat(" and (OrderId in(select distinct OrderId from Tb_Ticket_Passenger where TicketNumber like '%{0}%') or OrderId='{0}') ", OrderIdAndTicketNumber);
//}
//else
//{
// //订单号
// StrWhere.AppendFormat(" and OrderId='{0}' ", OrderIdAndTicketNumber);
//}
//解决条件查询慢的问题 2013-6-14
if (OrderIdAndTicketNumber.Length == 19)
{
StrWhere.AppendFormat(" and OrderId='{0}' ", OrderIdAndTicketNumber);
}
else if (OrderIdAndTicketNumber.Length == 13 || OrderIdAndTicketNumber.Length == 14 || OrderIdAndTicketNumber.Length == 10)
{
StrWhere.AppendFormat(" and OrderId in(select distinct OrderId from Tb_Ticket_Passenger where replace(TicketNumber,'-','') ='{0}') ", OrderIdAndTicketNumber);
}
else
{
StrWhere.AppendFormat(" and OrderId like '%{0}%' ", OrderIdAndTicketNumber);
}
}
//pnr
if (!string.IsNullOrEmpty(CommonManage.TrimSQL(txtPNR.Text.Trim())))
{
StrWhere.Append(" and PNR='" + CommonManage.TrimSQL(txtPNR.Text.Trim()) + "' ");
}
//乘机人
if (!string.IsNullOrEmpty(txtPassengerName.Text.Trim()))
{
StrWhere.Append(" and PassengerName like'%" + CommonManage.TrimSQL(txtPassengerName.Text.Trim()) + "%' ");
}
//客户名称
if (!string.IsNullOrEmpty(CommonManage.TrimSQL(txtCorporationName.Text.Trim())))
{
StrWhere.Append(" and OwnerCpyName like'%" + CommonManage.TrimSQL(txtCorporationName.Text.Trim()) + "%' ");
}
//航班号
if (!string.IsNullOrEmpty(CommonManage.TrimSQL(txtFlightCode.Text.Trim())))
{
StrWhere.Append(" and FlightCode ='" + CommonManage.TrimSQL(txtFlightCode.Text.Trim()) + "' ");
}
//航空公司
if (!string.IsNullOrEmpty(CommonManage.TrimSQL(SelectAirCode1.Value.Trim())))
{
StrWhere.Append(" and CarryCode ='" + CommonManage.TrimSQL(SelectAirCode1.Value.Trim()) + "' ");
}
if (IsTKZ)
{
StrWhere.Append(" and OrderStatusCode in(20,21,22,23) ");
}
else
{
//订单状态
if (ddlStatus.SelectedValue != "" && ddlStatus.SelectedValue != "0")
{
StrWhere.Append(" and OrderStatusCode= " + CommonManage.TrimSQL(ddlStatus.SelectedValue));
}
}
//乘机日期
if (!string.IsNullOrEmpty(CommonManage.TrimSQL(txtFromDate1.Value.Trim())))
{
StrWhere.Append(" and AirTime >'" + CommonManage.TrimSQL(txtFromDate1.Value.Trim()) + " 00:00:00'");
}
//乘机日期
if (!string.IsNullOrEmpty(CommonManage.TrimSQL(txtFromDate2.Value.Trim())))
{
StrWhere.Append(" and AirTime <'" + CommonManage.TrimSQL(txtFromDate2.Value.Trim()) + " 23:59:59'");
}
//创建日期
if (!string.IsNullOrEmpty(CommonManage.TrimSQL(txtCreateTime1.Value.Trim())))
{
StrWhere.Append(" and CreateTime >'" + CommonManage.TrimSQL(txtCreateTime1.Value.Trim()) + " 00:00:00'");
}
//创建日期
if (!string.IsNullOrEmpty(CommonManage.TrimSQL(txtCreateTime2.Value.Trim())))
{
StrWhere.Append(" and CreateTime <'" + CommonManage.TrimSQL(txtCreateTime2.Value.Trim()) + " 23:59:59'");
}
////城市控件
//if (txtFromCity.Value.Trim() != "" && txtFromCity.Value.Trim() != "中文/拼音" && txtFromCity.Value.Trim() != "中文/英文")
// StrWhere.Append(" and Travel like '" + CommonManage.TrimSQL(txtFromCity.Value.Trim()) + "%'");
//if (txtToCity.Value.Trim() != "" && txtToCity.Value.Trim() != "中文/拼音" && txtToCity.Value.Trim() != "中文/英文")
// StrWhere.Append(" and Travel like '%" + CommonManage.TrimSQL(txtToCity.Value.Trim()) + "'");
////城市控件
if (hidFromCity.Value.Trim() != "" && txtFromCity.Value.Trim() != "" && txtFromCity.Value.Trim() != "中文/拼音" && txtFromCity.Value.Trim() != "中文/英文")
{
StrWhere.Append(" and TravelCode like '" + CommonManage.TrimSQL(hidFromCity.Value.Trim()) + "%'");
}
if (hidToCity.Value.Trim() != "" && txtToCity.Value.Trim() != "" && txtToCity.Value.Trim() != "中文/拼音" && txtToCity.Value.Trim() != "中文/英文")
{
StrWhere.Append(" and TravelCode like '%" + CommonManage.TrimSQL(hidToCity.Value.Trim()) + "'");
}
}
catch (Exception)
{
}
return(StrWhere.ToString());
}
/// <summary>
/// 查询条件拼接
/// </summary>
/// <returns>返回拼接好的字符串</returns>
private string Query()
{
//本地和共享 已经出票
StringBuilder sb = new StringBuilder();
try
{
sb.Append(" policysource in(1,2,9) and OrderStatusCode=4 ");
if (mCompany.RoleType == 1)
{
sb.AppendFormat(" and left(OwnerCpyNo,6)='{0}'", mCompany.UninCode);
}
else
{
sb.AppendFormat(" and left(OwnerCpyNo,12)='{0}'", mCompany.UninCode);
}
if (CommonManage.TrimSQL(txtOrderId.Text.Trim()) != "")
{
sb.Append(" and OrderId like '%" + CommonManage.TrimSQL(txtOrderId.Text.Trim()) + "%'");
}
//航空公司
if (SelectAirCode1.Value != "" && SelectAirCode1.Value != "0")
{
sb.Append(" and CarryCode = '" + CommonManage.TrimSQL(SelectAirCode1.Value) + "'");
}
//乘客
if (CommonManage.TrimSQL(txtPassengerName.Text.Trim()) != "")
{
sb.Append(" and PassengerName like '%" + CommonManage.TrimSQL(txtPassengerName.Text.Trim()) + "%'");
}
//编码
if (CommonManage.TrimSQL(txtPNR.Text.Trim()) != "")
{
sb.Append(" and PNR like '%" + CommonManage.TrimSQL(txtPNR.Text.Trim()) + "%'");
}
//订单生成时间
if (CommonManage.TrimSQL(txtCreateTime1.Value.Trim()) != "")
{
sb.Append(" and CreateTime >= '" + CommonManage.TrimSQL(txtCreateTime1.Value.Trim()) + " 00:00:00'");
}
if (CommonManage.TrimSQL(txtCreateTime2.Value.Trim()) != "")
{
sb.Append(" and CreateTime <= '" + CommonManage.TrimSQL(txtCreateTime2.Value.Trim()) + " 23:59:59'");
}
//乘机时间
if (CommonManage.TrimSQL(txtFromDate1.Value.Trim()) != "")
{
sb.Append(" and AirTime <= '" + CommonManage.TrimSQL(txtFromDate1.Value.Trim()) + " 00:00:00'");
}
if (CommonManage.TrimSQL(txtFromDate2.Value.Trim()) != "")
{
sb.Append(" and AirTime >= '" + CommonManage.TrimSQL(txtFromDate2.Value.Trim()) + " 23:59:59'");
}
//行程类型
if (rbtlTravelType.SelectedValue != "0" && rbtlTravelType.SelectedValue != "")
{
sb.Append(" and TravelType = " + rbtlTravelType.SelectedValue.ToString());
}
if (txtFromCity.Value.Trim() != "" && txtFromCity.Value.Trim() != "中文/拼音" && txtFromCity.Value.Trim() != "中文/英文")
{
sb.Append(" and Travel like '" + txtFromCity.Value.Trim() + "%'");
}
if (txtToCity.Value.Trim() != "" && txtToCity.Value.Trim() != "中文/拼音" && txtToCity.Value.Trim() != "中文/英文")
{
sb.Append(" and Travel like '%" + txtToCity.Value.Trim() + "'");
}
if (CommonManage.TrimSQL(txtFlightCode.Text.Trim()) != "")
{
sb.Append(" and FlightCode like '%" + CommonManage.TrimSQL(txtFlightCode.Text.Trim()) + "%'");
}
}
catch
{
return(sb.ToString());
}
return(sb.ToString());
}
/// <summary>
/// 查询条件
/// </summary>
/// <returns></returns>
private string SelWhere()
{
StringBuilder StrWhere = new StringBuilder(" PayStatus=1 ");
StrWhere.Append(" and CPCpyNo='" + mUser.CpyNo + "' ");
try
{
//订单号
if (!string.IsNullOrEmpty(CommonManage.TrimSQL(txtOrderId.Text.Trim())))
{
StrWhere.Append(" and OrderId='" + CommonManage.TrimSQL(txtOrderId.Text.Trim()) + "' ");
}
//pnr
if (!string.IsNullOrEmpty(CommonManage.TrimSQL(txtPNR.Text.Trim())))
{
StrWhere.Append(" and PNR='" + CommonManage.TrimSQL(txtPNR.Text.Trim()) + "' ");
}
//乘机人
if (!string.IsNullOrEmpty(CommonManage.TrimSQL(txtPassengerName.Text.Trim())))
{
StrWhere.Append(" and PassengerName like'%" + CommonManage.TrimSQL(txtPassengerName.Text.Trim()) + "%' ");
}
//航班号
if (!string.IsNullOrEmpty(CommonManage.TrimSQL(txtFlightCode.Text.Trim())))
{
StrWhere.Append(" and FlightCode ='" + CommonManage.TrimSQL(txtFlightCode.Text.Trim()) + "' ");
}
//乘机日期
if (!string.IsNullOrEmpty(CommonManage.TrimSQL(txtFromDate1.Value.Trim())))
{
StrWhere.Append(" and AirTime >'" + CommonManage.TrimSQL(txtFromDate1.Value.Trim()) + " 00:00:00'");
}
//乘机日期
if (!string.IsNullOrEmpty(CommonManage.TrimSQL(txtFromDate2.Value.Trim())))
{
StrWhere.Append(" and AirTime <'" + CommonManage.TrimSQL(txtFromDate2.Value.Trim()) + " 23:59:59'");
}
//创建日期
if (!string.IsNullOrEmpty(CommonManage.TrimSQL(txtCreateTime1.Value.Trim())))
{
StrWhere.Append(" and CreateTime >'" + CommonManage.TrimSQL(txtCreateTime1.Value.Trim()) + " 00:00:00'");
}
//创建日期
if (!string.IsNullOrEmpty(CommonManage.TrimSQL(txtCreateTime2.Value.Trim())))
{
StrWhere.Append(" and CreateTime <'" + CommonManage.TrimSQL(txtCreateTime2.Value.Trim()) + " 23:59:59'");
}
////城市控件
//if (txtFromCity.Value.Trim() != "" && txtFromCity.Value.Trim() != "中文/拼音" && txtFromCity.Value.Trim() != "中文/英文")
// StrWhere.Append(" and Travel like '" + CommonManage.TrimSQL(txtFromCity.Value.Trim()) + "%'");
//if (txtToCity.Value.Trim() != "" && txtToCity.Value.Trim() != "中文/拼音" && txtToCity.Value.Trim() != "中文/英文")
// StrWhere.Append(" and Travel like '%" + CommonManage.TrimSQL(txtToCity.Value.Trim()) + "'");
////城市控件
if (hidFromCity.Value.Trim() != "" && txtFromCity.Value.Trim() != "" && txtFromCity.Value.Trim() != "中文/拼音" && txtFromCity.Value.Trim() != "中文/英文")
{
StrWhere.Append(" and TravelCode like '" + CommonManage.TrimSQL(hidFromCity.Value.Trim()) + "%'");
}
if (hidToCity.Value.Trim() != "" && txtToCity.Value.Trim() != "" && txtToCity.Value.Trim() != "中文/拼音" && txtToCity.Value.Trim() != "中文/英文")
{
StrWhere.Append(" and TravelCode like '%" + CommonManage.TrimSQL(hidToCity.Value.Trim()) + "'");
}
if (!string.IsNullOrEmpty(CommonManage.TrimSQL(txtCpyName.Text.Trim())))
{
StrWhere.Append(" and OwnerCpyName like '%" + CommonManage.TrimSQL(txtCpyName.Text.Trim()) + "%'");
}
}
catch (Exception)
{
}
#region 查询订单状态
//<asp:ListItem Text="全部" Value="1"></asp:ListItem> 6,7,8,9,10,11,12,13,14,15,16,17,19,20,21,22
//<asp:ListItem Text="进行中的退票" Value="2"></asp:ListItem> 7,
//<asp:ListItem Text="进行中的废票" Value="3"></asp:ListItem>8,
//<asp:ListItem Text="改签订单" Value="4"></asp:ListItem>6,9,15
//<asp:ListItem Text="审核通过" Value="5"></asp:ListItem>9,11,13
//<asp:ListItem Text="拒绝申请的订单" Value="6"></asp:ListItem>10,12,14,18
//<asp:ListItem Text="交易结束" Value="7"></asp:ListItem> 16,17,19
//<asp:ListItem Text="异地待退废改签订单" Value="8"></asp:ListItem> PolicySource>1 and OrderStatusCode in(6,7,8,9,10,11,12,13,14,15,16,17,19,20,21,22
//<asp:ListItem Text="退款中的订单" Value="9"></asp:ListItem> 20,21,22
//<asp:ListItem Text="审核中" Value="10"></asp:ListItem> 20,21,22
if (Hid_num.Value == "1") //全部
{
StrWhere.Append(" and OrderStatusCode in(6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,29,30,31) ");
}
else if (Hid_num.Value == "2")
{
StrWhere.Append(" and OrderStatusCode=7 ");
}
else if (Hid_num.Value == "3")
{
StrWhere.Append(" and OrderStatusCode=8 ");
}
else if (Hid_num.Value == "4")
{
StrWhere.Append(" and OrderStatusCode in(6,9,15,23,24) ");
}
else if (Hid_num.Value == "5")
{
StrWhere.Append(" and OrderStatusCode in(11,13) ");
}
else if (Hid_num.Value == "6")
{
StrWhere.Append(" and OrderStatusCode in(10,12,14,18,23,24) ");
}
else if (Hid_num.Value == "7")
{
StrWhere.Append(" and OrderStatusCode in(16,17,19,26) ");
}
else if (Hid_num.Value == "8")
{
StrWhere.Append(" and PolicySource>1 and OrderStatusCode in(6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,29,30,31) ");
}
else if (Hid_num.Value == "9")
{
StrWhere.Append(" and OrderStatusCode in(20,21,22,23) ");
}
else if (Hid_num.Value == "10")
{
StrWhere.Append(" and OrderStatusCode in(29,30,31) "); //审核中
}
#endregion
return(StrWhere.ToString());
}
/// <summary>
/// 查询条件
/// </summary>
/// <returns></returns>
private string Query()
{
StringBuilder sb = new StringBuilder();
if (mCompany.RoleType == 4)
{
if (mCompany.UninCode.Length == 18)
{
sb.Append(" _tpay.CpyNo like '" + mCompany.UninCode + "%' and len(_tpay.CpyNo)=24");
}
else
{
sb.Append(" _tpay.CpyNo like '" + mCompany.UninCode + "%' and len(_tpay.CpyNo)=30");
}
}
else
{
sb.Append(" _tpay.CpyNo = '" + mCompany.UninCode + "'");
}
//支付时间
if (txtPayTime1.Value.Trim() != "")
{
sb.Append(" and _order.PayTime >= convert(DateTime, '" + txtPayTime1.Value + " 00:00:00')");
}//支付时间
if (txtPayTime2.Value.Trim() != "")
{
sb.Append(" and _order.PayTime <= convert(DateTime, '" + txtPayTime2.Value + " 23:59:59')");
}
//出退费票时间
if (cptimestart.Value.Trim() != "" && cptimeend.Value.Trim() != "")
{
sb.Append(" and _order.CPTime >= convert(DateTime, '" + cptimestart.Value + " 00:00:00') and _order.CPTime <= convert(DateTime, '" + cptimeend.Value + " 23:59:59')");
}
//创建时间
if (txtCreateTime1.Value.Trim() != "")
{
sb.Append(" and _order.CreateTime >= convert(DateTime, '" + txtCreateTime1.Value + " 00:00:00')");
}
//创建时间
if (txtCreateTime2.Value.Trim() != "")
{
sb.Append(" and _order.CreateTime <= convert(DateTime, '" + txtCreateTime2.Value + " 23:59:59')");
}
//政策类型
if (rbtlOrderS.SelectedValue.ToString() != "0")
{
if (rbtlOrderS.SelectedValue.ToString() == "1")
{
sb.Append(" and _order.PolicyType = 1");
}
else
{
sb.Append(" and _order.PolicyType = 2");
}
}
//支付方式
if (ddlPayWay.SelectedValue != "")
{
sb.Append(" and _order.PayWay=" + ddlPayWay.SelectedValue);
}
//机票状态
if (ddlTicketState.SelectedValue != "")
{
sb.Append(" and _passenger.TicketStatus = " + ddlTicketState.SelectedValue);
}
else
{
sb.Append(" and _passenger.TicketStatus in(2,3,4,5,6) ");
}
//城市对
if (hiStart.Value.Trim() != "" && txtStart.Text != "中文/拼音")
{
sb.Append(" and TravelCode like '" + hiStart.Value.Trim() + "%'");
}
if (hiTarget.Value.Trim() != "" && txtTarget.Text != "中文/拼音")
{
sb.Append(" and TravelCode like '%" + hiTarget.Value.Trim() + "'");
}
//航空公司
if (ddlCarrier.Value != "")
{
sb.Append(" and _order.CarryCode like '%" + CommonManage.TrimSQL(ddlCarrier.Value.Trim()) + "%'");
}
//订单号
if (txtOrderId.Text.Trim() != "")
{
sb.Append(" and _order.Orderid like '%" + CommonManage.TrimSQL(txtOrderId.Text.Trim()) + "%'");
}
//编码
if (txtPNR.Text.Trim() != "")
{
sb.Append(" and PNR like '%" + CommonManage.TrimSQL(txtPNR.Text.Trim()) + "%'");
}
//操作人
if (txtCPUser.Text.Trim() != "")
{
sb.Append(" and CPName like '%" + CommonManage.TrimSQL(txtCPUser.Text.Trim()) + "%'");
}
//客户名称
if (txtCustomer.Text.Trim() != "")
{
sb.Append(" and _cpy.UninAllName like '%" + CommonManage.TrimSQL(txtCustomer.Text.Trim()) + "%'");
}
//客户帐号
if (txtLoginName.Text.Trim() != "")
{
sb.Append(" and _user.LoginName like '%" + CommonManage.TrimSQL(txtLoginName.Text.Trim()) + "%'");
}
//政策来源
if (ddlPolicySource.SelectedValue.ToString() != "")
{
sb.Append(" and PolicySource in (" + ddlPolicySource.SelectedValue.ToString() + ")");
}
return(sb.ToString());
}
