//发放渠道
public void BindInvoiceListGrid(string Type)
{
_invoiceEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_invoiceEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_invoiceEntity.LogMessages.Username = UserSession.Current.UserDspName;
_invoiceEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_invoiceEntity.InvoiceDBEntity = new List<InvoiceDBEntity>();
InvoiceDBEntity invoiceDBEntity = new InvoiceDBEntity();
//invoiceDBEntity.CityID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["CityID"].ToString())) ? null : ViewState["CityID"].ToString();
invoiceDBEntity.USERID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["USERID"].ToString())) ? null : ViewState["USERID"].ToString();
invoiceDBEntity.CNFNUM = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["CNFNUM"].ToString())) ? null : ViewState["CNFNUM"].ToString();
invoiceDBEntity.SENDCODE = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["SENDCODE"].ToString())) ? null : ViewState["SENDCODE"].ToString();
invoiceDBEntity.Status = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["INVSTATUS"].ToString())) ? null : ViewState["INVSTATUS"].ToString();
invoiceDBEntity.APPLYCHANEL = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["APPLYCHANEL"].ToString())) ? null : ViewState["APPLYCHANEL"].ToString();
invoiceDBEntity.APPLYBEGINDATE = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["APPLYBEGINDATE"].ToString())) ? null : ViewState["APPLYBEGINDATE"].ToString();
invoiceDBEntity.APPLYENDDATE = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["APPLYENDDATE"].ToString())) ? null : ViewState["APPLYENDDATE"].ToString();
invoiceDBEntity.SENDBEGINDATE = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["SENDBEGINDATE"].ToString())) ? null : ViewState["SENDBEGINDATE"].ToString();
invoiceDBEntity.SENDENDDATE = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["SENDENDDATE"].ToString())) ? null : ViewState["SENDENDDATE"].ToString();
invoiceDBEntity.SelectType = Type;
_invoiceEntity.InvoiceDBEntity.Add(invoiceDBEntity);
DataSet dsResult = InvoiceBP.InvoiceListSelect(_invoiceEntity).QueryResult;
gridViewCSList.DataSource = dsResult.Tables[0].DefaultView;
gridViewCSList.DataKeyNames = new string[] { "ID" };//主键
gridViewCSList.DataBind();
if (!String.IsNullOrEmpty(refushFlag.Value))
{
messageContent.InnerHtml = GetLocalResourceObject("UpdateSuccess").ToString();
refushFlag.Value = "";
}
}
//发放渠道
public void BindInvoiceDetail()
{
_invoiceEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_invoiceEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_invoiceEntity.LogMessages.Username = UserSession.Current.UserDspName;
_invoiceEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_invoiceEntity.InvoiceDBEntity = new List<InvoiceDBEntity>();
InvoiceDBEntity invoiceDBEntity = new InvoiceDBEntity();
invoiceDBEntity.InvoiceID = hidInvoiceID.Value;
_invoiceEntity.InvoiceDBEntity.Add(invoiceDBEntity);
DataSet dsMainResult = InvoiceBP.InvoiceDetailSelect(_invoiceEntity).QueryResult;
if (dsMainResult.Tables.Count > 0 && dsMainResult.Tables[0].Rows.Count > 0)
{
lbCNFNUM.Text = dsMainResult.Tables[0].Rows[0]["CNFNUM"].ToString();
lbStatus.Text = dsMainResult.Tables[0].Rows[0]["ONLINEDIS"].ToString();
lbUSERID.Text = dsMainResult.Tables[0].Rows[0]["USERID"].ToString();
lbCONTRACTTEL.Text = dsMainResult.Tables[0].Rows[0]["CONTRACTTEL"].ToString();
lbAPPLYCHANEL.Text = dsMainResult.Tables[0].Rows[0]["APPLYCHANELNM"].ToString();
lbAPPLYTIME.Text = dsMainResult.Tables[0].Rows[0]["APPLYTIME"].ToString();
lbRECEIVERNAME.Text = dsMainResult.Tables[0].Rows[0]["RECEIVERNAME"].ToString();
lbINVOICEHEAD.Text = dsMainResult.Tables[0].Rows[0]["INVOICEHEAD"].ToString();
lbINVOICEADDR.Text = dsMainResult.Tables[0].Rows[0]["INVOICEADDR"].ToString();
lbSENDTIME.Text = dsMainResult.Tables[0].Rows[0]["SENDTIME"].ToString();
lbZIPCODE.Text = dsMainResult.Tables[0].Rows[0]["ZIPCODE"].ToString();
lbINVOICEAMOUNT.Text = dsMainResult.Tables[0].Rows[0]["INVOICEAMOUNT"].ToString();
lbSENDNAME.Text = dsMainResult.Tables[0].Rows[0]["SENDNAME"].ToString();
lbSENDCODE.Text = dsMainResult.Tables[0].Rows[0]["SENDCODE"].ToString();
lbINVOICENUM.Text = dsMainResult.Tables[0].Rows[0]["INVOICENUM"].ToString();
lbOPERATOR.Text = dsMainResult.Tables[0].Rows[0]["OPERATOR"].ToString();
hidOnlineStatus.Value = dsMainResult.Tables[0].Rows[0]["ONLINESTATUS"].ToString();
lbINVOICEBODY.Text = dsMainResult.Tables[0].Rows[0]["INVOICEBODY"].ToString();
txtOPERATORMEMO.Text = dsMainResult.Tables[0].Rows[0]["OPERATORMEMO"].ToString();
if ("1".Equals(hidOnlineStatus.Value))
{
txtINVOICENUM.Visible = true;
btnBack.Visible = false;
}
else if ("2".Equals(hidOnlineStatus.Value))
{
txtSENDCODE.Visible = true;
txtSENDNAME.Visible = true;
}
else if ("3".Equals(hidOnlineStatus.Value))
{
btnBack.Visible = true;
btnUpdate.Visible = false;
}
else
{
btnBack.Visible = false;
btnUpdate.Visible = false;
}
}
else
{
detailMessageContent.InnerHtml = GetLocalResourceObject("WarningMessage").ToString();
}
}
protected void btnExport_Click(object sender, EventArgs e)
{
messageContent.InnerHtml = "";
_invoiceEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_invoiceEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_invoiceEntity.LogMessages.Username = UserSession.Current.UserDspName;
_invoiceEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_invoiceEntity.InvoiceDBEntity = new List<InvoiceDBEntity>();
InvoiceDBEntity invoiceDBEntity = new InvoiceDBEntity();
//invoiceDBEntity.CityID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["CityID"].ToString())) ? null : ViewState["CityID"].ToString();
invoiceDBEntity.USERID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["USERID"].ToString())) ? null : ViewState["USERID"].ToString();
invoiceDBEntity.CNFNUM = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["CNFNUM"].ToString())) ? null : ViewState["CNFNUM"].ToString();
invoiceDBEntity.SENDCODE = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["SENDCODE"].ToString())) ? null : ViewState["SENDCODE"].ToString();
invoiceDBEntity.Status = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["INVSTATUS"].ToString())) ? null : ViewState["INVSTATUS"].ToString();
invoiceDBEntity.APPLYCHANEL = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["APPLYCHANEL"].ToString())) ? null : ViewState["APPLYCHANEL"].ToString();
invoiceDBEntity.APPLYBEGINDATE = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["APPLYBEGINDATE"].ToString())) ? null : ViewState["APPLYBEGINDATE"].ToString();
invoiceDBEntity.APPLYENDDATE = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["APPLYENDDATE"].ToString())) ? null : ViewState["APPLYENDDATE"].ToString();
invoiceDBEntity.SENDBEGINDATE = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["SENDBEGINDATE"].ToString())) ? null : ViewState["SENDBEGINDATE"].ToString();
invoiceDBEntity.SENDENDDATE = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["SENDENDDATE"].ToString())) ? null : ViewState["SENDENDDATE"].ToString();
invoiceDBEntity.SelectType = hidType.Value;
_invoiceEntity.InvoiceDBEntity.Add(invoiceDBEntity);
DataSet dsResult = InvoiceBP.InvoiceListExcelSelect(_invoiceEntity).QueryResult;
if (dsResult.Tables.Count == 0 && dsResult.Tables[0].Rows.Count == 0)
{
return;
}
CommonFunction.ExportExcelForLM(dsResult);
}
private void SaveAction(string ActionType)
{
_invoiceEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_commonEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_invoiceEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_invoiceEntity.LogMessages.Username = UserSession.Current.UserDspName;
_invoiceEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_invoiceEntity.InvoiceDBEntity = new List<InvoiceDBEntity>();
InvoiceDBEntity invoiceDBEntity = new InvoiceDBEntity();
invoiceDBEntity.InvoiceID = hidInvoiceID.Value;
invoiceDBEntity.INVOICENUM = txtINVOICENUM.Value.Trim();
invoiceDBEntity.SENDCODE = txtSENDCODE.Value.Trim();
invoiceDBEntity.SENDNAME = txtSENDNAME.Value.Trim();
invoiceDBEntity.OnlineStatus = hidOnlineStatus.Value;
invoiceDBEntity.Remark = txtOPERATORMEMO.Text;
invoiceDBEntity.ActionType = ActionType;
_invoiceEntity.InvoiceDBEntity.Add(invoiceDBEntity);
int iResult = InvoiceBP.InvoiceUpdate(_invoiceEntity);
_commonEntity.LogMessages = _invoiceEntity.LogMessages;
_commonEntity.CommonDBEntity = new List<CommonDBEntity>();
CommonDBEntity commonDBEntity = new CommonDBEntity();
commonDBEntity.Event_Type = "发票管理-保存";
commonDBEntity.Event_ID = hidInvoiceID.Value;
string conTent = GetLocalResourceObject("EventUpdateMessage").ToString();
conTent = string.Format(conTent, invoiceDBEntity.InvoiceID, (String.IsNullOrEmpty(txtINVOICENUM.Value.ToString().Trim()) ? lbINVOICENUM.Text : txtINVOICENUM.Value.ToString().Trim()), (String.IsNullOrEmpty(txtSENDNAME.Value.ToString().Trim()) ? lbSENDNAME.Text : txtSENDNAME.Value.ToString().Trim()), (String.IsNullOrEmpty(txtSENDCODE.Value.ToString().Trim()) ? lbSENDCODE.Text : txtSENDCODE.Value.ToString().Trim()));
commonDBEntity.Event_Content = conTent;
if (iResult == 1)
{
Response.Write("<script>window.returnValue=true;window.opener = null;window.close();</script>");
}
else if (iResult == 2)
{
commonDBEntity.Event_Result = GetLocalResourceObject("UpdateError7").ToString();
detailMessageContent.InnerHtml = GetLocalResourceObject("UpdateError7").ToString();
}
else
{
commonDBEntity.Event_Result = GetLocalResourceObject("UpdateError").ToString();
detailMessageContent.InnerHtml = GetLocalResourceObject("UpdateError").ToString();
}
_commonEntity.CommonDBEntity.Add(commonDBEntity);
CommonBP.InsertEventHistory(_commonEntity);
}