|
|
using System;
|
|
|
using System.Collections.Generic;
|
|
|
using System.Data;
|
|
|
using System.Linq;
|
|
|
using System.Web;
|
|
|
using System.Web.UI;
|
|
|
using System.Web.UI.WebControls;
|
|
|
using BLL.CardBill;
|
|
|
using BLL.Sys;
|
|
|
using CPCBILLSYS.Common;
|
|
|
using Ext.Net;
|
|
|
using Model;
|
|
|
using Newtonsoft.Json.Linq;
|
|
|
|
|
|
namespace CPCBILLSYS
|
|
|
{
|
|
|
public partial class BillBalanceMg : System.Web.UI.Page
|
|
|
{
|
|
|
LogClass log = new LogClass();
|
|
|
/// <summary>
|
|
|
/// 基础
|
|
|
/// </summary>
|
|
|
DictionaryBLL dicbll = new DictionaryBLL(CommonHelper._dbType, CommonHelper.DbConStr);
|
|
|
/// <summary>
|
|
|
/// cpc
|
|
|
/// </summary>
|
|
|
BILLBLL bbll = new BILLBLL(CommonHelper._dbType, CommonHelper.DbConStr);
|
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
|
{
|
|
|
if (!IsPostBack)
|
|
|
{
|
|
|
if (CommonHelper._userType == "3")
|
|
|
{
|
|
|
if (string.IsNullOrEmpty(Request.QueryString["userId"]) || string.IsNullOrEmpty(Request.QueryString["userName"]))
|
|
|
{
|
|
|
Response.Write("<script>alert('错误的访问！');window.location.href='http://10.15.0.36:9996'</script>");
|
|
|
return;
|
|
|
}
|
|
|
try
|
|
|
{
|
|
|
hdUserId.Value = Request.QueryString["userId"].ToString();
|
|
|
hdMan.Value = HttpUtility.UrlDecode(Request.QueryString["userName"].ToString());
|
|
|
}
|
|
|
catch
|
|
|
{
|
|
|
Response.Write("<script>alert('数据库访问异常！');window.location.href='http://10.15.0.36:9996'</script>");
|
|
|
return;
|
|
|
}
|
|
|
|
|
|
//hdUserId.Value = "1";
|
|
|
//hdMan.Value = "武俊涛";
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
if (Session["UserID"] == null || Session["SysID"] == null || Session["MAN"] == null)
|
|
|
{
|
|
|
Response.Write("<script>alert('错误的访问！');window.location.href='../Default.aspx'</script>");
|
|
|
return;
|
|
|
}
|
|
|
hdUserId.Value = Session["UserID"].ToString();
|
|
|
hdMan.Value = Session["MAN"].ToString();
|
|
|
}
|
|
|
s_txtStartDt.Value = DateTime.Now.AddDays(-1);
|
|
|
s_txtStartDt.MaxDate = DateTime.Now.AddDays(-1);
|
|
|
|
|
|
s_txtStDt.Value = DateTime.Now.AddDays(-1);
|
|
|
s_txtStDt.MaxDate = DateTime.Now.AddDays(-1);
|
|
|
|
|
|
s_txtEndDt.Value = DateTime.Now.AddDays(1);
|
|
|
s_txtEndDt.MaxDate = DateTime.Now.AddDays(1);
|
|
|
StCardInfo.AutoLoadParams.Add(new Ext.Net.Parameter("Start", "0"));
|
|
|
StCardInfo.AutoLoadParams.Add(new Ext.Net.Parameter("Limit", Paging.PageSize.ToString()));
|
|
|
|
|
|
stBillName.AutoLoadParams.Add(new Ext.Net.Parameter("Start", "0"));
|
|
|
stBillName.AutoLoadParams.Add(new Ext.Net.Parameter("Limit", ptbar.PageSize.ToString()));
|
|
|
|
|
|
BindSub();
|
|
|
BindClassNo();
|
|
|
BindBillKind();
|
|
|
BindKind();
|
|
|
BindBillName();
|
|
|
BindSeqNO();
|
|
|
if (CommonHelper._userType != "1")
|
|
|
{
|
|
|
s_txtStartDt.Hide();
|
|
|
Button1.Hide();
|
|
|
btnBalance.Hide();
|
|
|
btnFzBalance.Hide();
|
|
|
}
|
|
|
if (CommonHelper._userType == "1" || CommonHelper._userType == "2")
|
|
|
{
|
|
|
s_btnAdd.Hide();
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
s_btnAdd.Show();
|
|
|
}
|
|
|
}
|
|
|
}
|
|
|
|
|
|
#region 绑定数据
|
|
|
public void BindKind()
|
|
|
{
|
|
|
DataTable dt = dicbll.GetCBKind(" and VALUE in(1,2)");
|
|
|
djstKind.DataSource = dt;
|
|
|
djstKind.DataBind();
|
|
|
stEBillType.DataSource = dt;
|
|
|
stEBillType.DataBind();
|
|
|
}
|
|
|
public void BindBillKind()
|
|
|
{
|
|
|
DataTable dt = dicbll.GetCBBillKind("");
|
|
|
djstBillKind.DataSource = dt;
|
|
|
djstBillKind.DataBind();
|
|
|
stEBillKind.DataSource = dt;
|
|
|
stEBillKind.DataBind();
|
|
|
}
|
|
|
public void BindBillName()
|
|
|
{
|
|
|
djstBillName.DataSource = dicbll.GetCBBillName(" and type=1 and flag=" + CommonHelper._ishighway + " and kind=" + CommonHelper._billKind + "");
|
|
|
djstBillName.DataBind();
|
|
|
}
|
|
|
protected void CmbDJBillKind_Select(object sender, Ext.Net.DirectEventArgs e)
|
|
|
{
|
|
|
string sqlwhere = string.Empty;
|
|
|
if (!string.IsNullOrEmpty(CmbDJBillType.SelectedItem.Value))
|
|
|
{
|
|
|
sqlwhere += " and TYPE='" + CmbDJBillType.SelectedItem.Value + "'";
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("请选择票类型");
|
|
|
return;
|
|
|
}
|
|
|
if (!string.IsNullOrEmpty(CmbDJBillKind.SelectedItem.Value))
|
|
|
{
|
|
|
sqlwhere += " and KIND='" + CmbDJBillKind.SelectedItem.Value + "'";
|
|
|
}
|
|
|
djstBillName.DataSource = dicbll.GetCBBillName(sqlwhere);
|
|
|
djstBillName.DataBind();
|
|
|
}
|
|
|
protected void cmbDJBillName_Select(object sender, Ext.Net.DirectEventArgs e)
|
|
|
{
|
|
|
txtDJBillName.Text = cmbDJBillName.SelectedItem.Text;
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 绑定站
|
|
|
/// </summary>
|
|
|
public void BindSub()
|
|
|
{
|
|
|
if (CommonHelper._userType == "1")
|
|
|
{
|
|
|
//s_cmbSubcom.Disabled = true;
|
|
|
//s_cmbSta.Disabled = true;
|
|
|
s_cmbSubcom.Hidden = true;
|
|
|
s_cmbSta.Hidden = true;
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
storeSubCompany.DataSource = dicbll.GetSubCompany("");
|
|
|
}
|
|
|
storeSubCompany.DataBind();
|
|
|
}
|
|
|
public void BindClassNo()
|
|
|
{
|
|
|
stClassNo.DataSource = dicbll.GetClass("");
|
|
|
stClassNo.DataBind();
|
|
|
}
|
|
|
|
|
|
protected void s_cmbSubcom_Select(object sender, Ext.Net.DirectEventArgs e)
|
|
|
{
|
|
|
stSta.DataSource = dicbll.GetStaAllInfo(" and SUBCOMNO='" + s_cmbSubcom.SelectedItem.Value + "'");
|
|
|
stSta.DataBind();
|
|
|
}
|
|
|
|
|
|
public void BindSeqNO()
|
|
|
{
|
|
|
DataTable dt = null;
|
|
|
try
|
|
|
{
|
|
|
string sqlwhere = " and BILLKIND='" + CommonHelper._billKind + "' and kind=1 and bak1='" + CommonHelper._ishighway + "'";
|
|
|
//获取今年的发票代码
|
|
|
dt = dicbll.GetBillSeqNO(sqlwhere);
|
|
|
}
|
|
|
catch
|
|
|
{
|
|
|
dt = new DataTable();
|
|
|
}
|
|
|
stBillSeqNo.DataSource = dt;
|
|
|
stBillSeqNo.DataBind();
|
|
|
}
|
|
|
|
|
|
protected void cmbDJBIllSerialNO_Select(object sender, Ext.Net.DirectEventArgs e)
|
|
|
{
|
|
|
txtDJBillSerialNO.Text = cmbDJBIllSerialNO.SelectedItem.Value;
|
|
|
}
|
|
|
#endregion 绑定数据
|
|
|
|
|
|
/// <summary>
|
|
|
/// 查询
|
|
|
/// </summary>
|
|
|
/// <param name="sender"></param>
|
|
|
/// <param name="e"></param>
|
|
|
protected void btnSearch_Click(object sender, Ext.Net.DirectEventArgs e)
|
|
|
{
|
|
|
string sqlwhere = string.Empty;
|
|
|
try
|
|
|
{
|
|
|
if (s_txtStartDt.Value != null || !string.IsNullOrEmpty(s_txtStartDt.Value.ToString()))
|
|
|
{
|
|
|
if (CommonHelper._dbType == "1")
|
|
|
{
|
|
|
sqlwhere += "and classdate>='" + Convert.ToDateTime(s_txtStDt.Value).ToString("yyyy-MM-dd") + "' and classdate<='" + Convert.ToDateTime(s_txtEndDt.Value).ToString("yyyy-MM-dd") + "'";
|
|
|
}
|
|
|
else if (CommonHelper._dbType == "4")
|
|
|
{
|
|
|
sqlwhere += " and classdate>=DATE_FORMAT('" + Convert.ToDateTime(s_txtStDt.Value).ToString("yyyy-MM-dd") + "','%Y-%m-%d') and classdate<=DATE_FORMAT('" + Convert.ToDateTime(s_txtEndDt.Value).ToString("yyyy-MM-dd") + "','%Y-%m-%d')";
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
sqlwhere += "and classdate>=to_date('" + Convert.ToDateTime(s_txtStDt.Value).ToString("yyyy-MM-dd") + "','yyyy-MM-dd') and classdate<=to_date('" + Convert.ToDateTime(s_txtEndDt.Value).ToString("yyyy-MM-dd") + "','yyyy-MM-dd')";
|
|
|
}
|
|
|
}
|
|
|
|
|
|
if (CommonHelper._userType == "1")
|
|
|
{
|
|
|
sqlwhere += " and stano='" + CommonHelper._userStaNo + "'";
|
|
|
DataTable dt = bbll.GetBillBalanceSum(sqlwhere);
|
|
|
string fpct = dt.Rows[0]["FPCT"].ToString();
|
|
|
lbShow.Text = "【发票总量】：" + fpct + "";
|
|
|
}
|
|
|
}
|
|
|
catch
|
|
|
{
|
|
|
lbShow.Text = "【发票总量】：0";
|
|
|
}
|
|
|
wdSearch.Hide();
|
|
|
Paging.SetPageIndex(1);
|
|
|
StCardInfo.DataBind();
|
|
|
|
|
|
}
|
|
|
/// <summary>
|
|
|
///
|
|
|
/// </summary>
|
|
|
/// <param name="sender"></param>
|
|
|
/// <param name="e"></param>
|
|
|
protected void StCardInfo_RefreshData(object sender, Ext.Net.StoreRefreshDataEventArgs e)
|
|
|
{
|
|
|
int start; int limit;
|
|
|
if (!string.IsNullOrEmpty(e.Parameters["Start"]) && !string.IsNullOrEmpty(e.Parameters["Limit"]))
|
|
|
{
|
|
|
start = int.Parse(e.Parameters["Start"]);
|
|
|
limit = int.Parse(e.Parameters["Limit"]);
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
start = e.Start;
|
|
|
limit = e.Limit;
|
|
|
}
|
|
|
if (s_txtStDt.Value == null || string.IsNullOrEmpty(s_txtEndDt.Value.ToString()))
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("请选择查询日期！");
|
|
|
return;
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
if (Convert.ToDateTime(s_txtStDt.Value.ToString()) > Convert.ToDateTime(s_txtEndDt.Value.ToString()))
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("起始日期不大于结束日期！");
|
|
|
return;
|
|
|
}
|
|
|
}
|
|
|
string sqlwhere = string.Empty;
|
|
|
if (CommonHelper._dbType == "1")
|
|
|
{
|
|
|
sqlwhere += "and classdate>='" + Convert.ToDateTime(s_txtStDt.Value).ToString("yyyy-MM-dd") + "' and classdate<='" + Convert.ToDateTime(s_txtEndDt.Value).ToString("yyyy-MM-dd") + "'";
|
|
|
}
|
|
|
else if (CommonHelper._dbType == "4")
|
|
|
{
|
|
|
sqlwhere += " and classdate>=DATE_FORMAT('" + Convert.ToDateTime(s_txtStDt.Value).ToString("yyyy-MM-dd") + "','%Y-%m-%d') and classdate<=DATE_FORMAT('" + Convert.ToDateTime(s_txtEndDt.Value).ToString("yyyy-MM-dd") + "','%Y-%m-%d')";
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
sqlwhere += "and classdate>=to_date('" + Convert.ToDateTime(s_txtStDt.Value).ToString("yyyy-MM-dd") + "','yyyy-MM-dd HH24:mi:ss') and classdate<=to_date('" + Convert.ToDateTime(s_txtEndDt.Value).ToString("yyyy-MM-dd") + "','yyyy-MM-dd HH24:mi:ss')";
|
|
|
}
|
|
|
if (s_cmbClassNo.SelectedItem.Value != null && !string.IsNullOrEmpty(s_cmbClassNo.SelectedItem.Value))
|
|
|
{
|
|
|
sqlwhere += " and CLASSNO='" + s_cmbClassNo.SelectedItem.Value + "'";
|
|
|
}
|
|
|
if (s_cmbSubcom.SelectedItem.Value != null && !string.IsNullOrEmpty(s_cmbSubcom.SelectedItem.Value))
|
|
|
{
|
|
|
sqlwhere += " and SUBCOMNO='" + s_cmbSubcom.SelectedItem.Value + "'";
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
if (CommonHelper._userType == "2" && CommonHelper._ishighway == "2")
|
|
|
{
|
|
|
sqlwhere += " and SUBCOMNO=" + CommonHelper._userStaNo + "";
|
|
|
}
|
|
|
}
|
|
|
if (s_cmbSta.SelectedItem.Value != null && !string.IsNullOrEmpty(s_cmbSta.SelectedItem.Value))
|
|
|
{
|
|
|
sqlwhere += " and STANO='" + s_cmbSta.SelectedItem.Value + "'";
|
|
|
}
|
|
|
|
|
|
int ct = 0;
|
|
|
DataTable dt = bbll.GetBalanceLst(sqlwhere, start + 1, start + limit, out ct);
|
|
|
string returnMsg = string.Empty;
|
|
|
if (dt.Rows.Count > 0)
|
|
|
{
|
|
|
e.Total = ct;
|
|
|
List<BILLBalanceModel> lst = bbll.GetBlanceLstByFlag(dt, out returnMsg);
|
|
|
StCardInfo.DataSource = lst;
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
if (CommonHelper._userType == "1")
|
|
|
{
|
|
|
//CommonHelper.MsgShowInfo("请先生成平衡数据！");
|
|
|
}
|
|
|
}
|
|
|
if (!string.IsNullOrEmpty(returnMsg))
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("<font color='red'>" + returnMsg + "</font></br>发票代码未填写");
|
|
|
}
|
|
|
StCardInfo.DataBind();
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 生成平衡单
|
|
|
/// </summary>
|
|
|
/// <param name="sender"></param>
|
|
|
/// <param name="e"></param>
|
|
|
protected void btnBalance_Click(object sender, Ext.Net.DirectEventArgs e)
|
|
|
{
|
|
|
string sqlwhere = string.Empty;
|
|
|
if (string.IsNullOrEmpty(hdUserId.Value.ToString()) || hdMan.Value.ToString().ToLower() == "admin")
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("该用户无生成平衡单权限，请用该站监控或者票管账户登录");
|
|
|
return;
|
|
|
}
|
|
|
if (!string.IsNullOrEmpty(s_txtStartDt.Value.ToString()))
|
|
|
{
|
|
|
if (CommonHelper._dbType == "1")
|
|
|
{
|
|
|
sqlwhere += "and classdate='" + Convert.ToDateTime(s_txtStartDt.Value).ToString("yyyy-MM-dd") + "'";
|
|
|
}
|
|
|
else if (CommonHelper._dbType == "4")
|
|
|
{
|
|
|
sqlwhere += " and classdate=DATE_FORMAT('" + Convert.ToDateTime(s_txtStartDt.Value).ToString("yyyy-MM-dd") + "','%Y-%m-%d')";
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
sqlwhere += "and classdate=to_date('" + Convert.ToDateTime(s_txtStartDt.Value).ToString("yyyy-MM-dd") + "','yyyy-MM-dd HH24:mi:ss')";
|
|
|
}
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("请选择统计日");
|
|
|
return;
|
|
|
}
|
|
|
if (s_cmbClassNo.SelectedItem.Value != null && string.IsNullOrEmpty(s_cmbClassNo.SelectedItem.Value))
|
|
|
{
|
|
|
sqlwhere += " and CLASSNO='" + s_cmbClassNo.SelectedItem.Value + "'";
|
|
|
}
|
|
|
if (CommonHelper._userType == "1")
|
|
|
{
|
|
|
sqlwhere += " and stano=" + CommonHelper._userStaNo + "";
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
if (!string.IsNullOrEmpty(s_cmbSta.SelectedItem.Value.ToString()))
|
|
|
{
|
|
|
sqlwhere += " and stano='" + s_cmbSta.SelectedItem.Value + "'";
|
|
|
}
|
|
|
}
|
|
|
try
|
|
|
{
|
|
|
bool f = false;
|
|
|
if (CommonHelper._isAuotPay == "1")
|
|
|
{
|
|
|
f = bbll.CreatePreBlance(sqlwhere, hdUserId.Value.ToString(), hdMan.Value.ToString(), CommonHelper._userType, CommonHelper._ishighway, CommonHelper._billKind);
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
if (CommonHelper._ishighway == "1")
|
|
|
{
|
|
|
f = bbll.CreatePreBlanceForHighwayAutoPay(sqlwhere, hdUserId.Value.ToString(), hdMan.Value.ToString(), CommonHelper._userType, CommonHelper._ishighway, CommonHelper._billKind);
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
f = bbll.CreatePreBlanceForAutoPay(sqlwhere, hdUserId.Value.ToString(), hdMan.Value.ToString(), CommonHelper._userType, CommonHelper._ishighway, CommonHelper._billKind);
|
|
|
}
|
|
|
}
|
|
|
if (f)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("生成预交易平衡信息生成成功");
|
|
|
log.Info("btnBalance_Click", "生成预交易平衡信息生成成功");
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("生成预交易平衡信息生成失败，请重新点击生成");
|
|
|
log.Info("btnBalance_Click", "生成预交易平衡信息生成失败，请重新点击生成");
|
|
|
}
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("生成预交易平衡信息异常:<font color='red'>" + ex.Message + "</font>");
|
|
|
log.Info("btnBalance_Click", ex.Message);
|
|
|
}
|
|
|
StCardInfo.DataBind();
|
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
|
/// 开放道试运行平衡单
|
|
|
/// </summary>
|
|
|
/// <param name="sender"></param>
|
|
|
/// <param name="e"></param>
|
|
|
protected void btnNonBalance_Click(object sender, Ext.Net.DirectEventArgs e)
|
|
|
{
|
|
|
string sqlwhere = string.Empty;
|
|
|
if (string.IsNullOrEmpty(hdUserId.Value.ToString()) || hdMan.Value.ToString().ToLower() == "admin")
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("该用户无生成平衡单权限，请用该站监控或者票管账户登录");
|
|
|
return;
|
|
|
}
|
|
|
if (!string.IsNullOrEmpty(s_txtStartDt.Value.ToString()))
|
|
|
{
|
|
|
if (CommonHelper._dbType == "1")
|
|
|
{
|
|
|
sqlwhere += "and classdate>='" + Convert.ToDateTime(s_txtStDt.Value).ToString("yyyy-MM-dd") + "' and classdate<='" + Convert.ToDateTime(s_txtEndDt.Value).ToString("yyyy-MM-dd") + "'";
|
|
|
}
|
|
|
else if (CommonHelper._dbType == "4")
|
|
|
{
|
|
|
sqlwhere += " and classdate>=DATE_FORMAT('" + Convert.ToDateTime(s_txtStDt.Value).ToString("yyyy-MM-dd") + "','%Y-%m-%d') and classdate<=DATE_FORMAT('" + Convert.ToDateTime(s_txtEndDt.Value).ToString("yyyy-MM-dd") + "','%Y-%m-%d')";
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
sqlwhere += "and classdate>=to_date('" + Convert.ToDateTime(s_txtStDt.Value).ToString("yyyy-MM-dd") + "','yyyy-MM-dd HH24:mi:ss') and classdate<=to_date('" + Convert.ToDateTime(s_txtEndDt.Value).ToString("yyyy-MM-dd") + "','yyyy-MM-dd HH24:mi:ss')";
|
|
|
}
|
|
|
//sqlwhere += " and classdate='" + Convert.ToDateTime(s_txtStartDt.Value).ToString("yyyy-MM-dd") + "'";
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("请选择统计日");
|
|
|
return;
|
|
|
}
|
|
|
|
|
|
if (CommonHelper._userType == "1")
|
|
|
{
|
|
|
sqlwhere += " and stano=" + CommonHelper._userStaNo + "";
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
if (!string.IsNullOrEmpty(s_cmbSta.SelectedItem.Value.ToString()))
|
|
|
{
|
|
|
sqlwhere += " and stano='" + s_cmbSta.SelectedItem.Value + "'";
|
|
|
}
|
|
|
}
|
|
|
try
|
|
|
{
|
|
|
bool f = bbll.CreateNonPreBlance(CommonHelper._userStaNo, s_txtStartDt.Value.ToString(), hdUserId.Value.ToString(), hdMan.Value.ToString(), CommonHelper._userType, CommonHelper._ishighway);
|
|
|
if (f)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("生成预交易平衡信息生成成功");
|
|
|
log.Info("btnBalance_Click", "生成预交易平衡信息生成成功");
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("生成预交易平衡信息生成失败，请重新点击生成");
|
|
|
log.Info("btnBalance_Click", "生成预交易平衡信息生成失败，请重新点击生成");
|
|
|
}
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("生成预交易平衡信息生成异常,联系软件维护人员");
|
|
|
log.Info("btnBalance_Click", ex.Message);
|
|
|
}
|
|
|
StCardInfo.DataBind();
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 生成封站平衡单
|
|
|
/// </summary>
|
|
|
/// <param name="sender"></param>
|
|
|
/// <param name="e"></param>
|
|
|
protected void btnFzBalance_Click(object sender, Ext.Net.DirectEventArgs e)
|
|
|
{
|
|
|
string sqlwhere = string.Empty;
|
|
|
if (string.IsNullOrEmpty(hdUserId.Value.ToString()) || hdMan.Value.ToString().ToLower() == "admin")
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("该用户无生成平衡单权限，请用该站监控或者票管账户登录");
|
|
|
return;
|
|
|
}
|
|
|
if (!string.IsNullOrEmpty(s_txtStartDt.Value.ToString()))
|
|
|
{
|
|
|
if (CommonHelper._dbType == "1")
|
|
|
{
|
|
|
sqlwhere += "and classdate>='" + Convert.ToDateTime(s_txtStDt.Value).ToString("yyyy-MM-dd") + "' and classdate<='" + Convert.ToDateTime(s_txtEndDt.Value).ToString("yyyy-MM-dd") + "'";
|
|
|
}
|
|
|
else if (CommonHelper._dbType == "4")
|
|
|
{
|
|
|
sqlwhere += " and classdate>=DATE_FORMAT('" + Convert.ToDateTime(s_txtStDt.Value).ToString("yyyy-MM-dd") + "','%Y-%m-%d') and classdate<=DATE_FORMAT('" + Convert.ToDateTime(s_txtEndDt.Value).ToString("yyyy-MM-dd") + "','%Y-%m-%d')";
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
sqlwhere += "and classdate>=to_date('" + Convert.ToDateTime(s_txtStDt.Value).ToString("yyyy-MM-dd") + "','yyyy-MM-dd HH24:mi:ss') and classdate<=to_date('" + Convert.ToDateTime(s_txtEndDt.Value).ToString("yyyy-MM-dd") + "','yyyy-MM-dd HH24:mi:ss')";
|
|
|
}
|
|
|
//sqlwhere += " and classdate='" + Convert.ToDateTime(s_txtStartDt.Value).ToString("yyyy-MM-dd") + "'";
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("请选择统计日");
|
|
|
return;
|
|
|
}
|
|
|
try
|
|
|
{
|
|
|
bool f = bbll.CreatePreBlanceForFz(CommonHelper._userStaNo, Convert.ToDateTime(s_txtStartDt.Value).ToString("yyyy-MM-dd"), hdUserId.Value.ToString(), hdMan.Value.ToString(), CommonHelper._userType, CommonHelper._ishighway);
|
|
|
if (f)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("生成预交易平衡信息生成成功");
|
|
|
log.Info("btnBalance_Click", "生成预交易平衡信息生成成功");
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("生成预交易平衡信息生成失败，请重新点击生成");
|
|
|
log.Info("btnBalance_Click", "生成预交易平衡信息生成失败，请重新点击生成");
|
|
|
}
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("生成预交易平衡信息生成异常,联系软件维护人员");
|
|
|
log.Info("btnBalance_Click", ex.Message);
|
|
|
}
|
|
|
StCardInfo.DataBind();
|
|
|
}
|
|
|
/// <summary>
|
|
|
///
|
|
|
/// </summary>
|
|
|
/// <param name="sender"></param>
|
|
|
/// <param name="e"></param>
|
|
|
[DirectMethod]
|
|
|
public void CreateFzBalance()
|
|
|
{
|
|
|
string sqlwhere = string.Empty;
|
|
|
if (string.IsNullOrEmpty(hdUserId.Value.ToString()) || hdMan.Value.ToString().ToLower() == "admin")
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("该用户无生成平衡单权限，请用该站监控或者票管账户登录");
|
|
|
return;
|
|
|
}
|
|
|
if (!string.IsNullOrEmpty(s_txtStartDt.Value.ToString()))
|
|
|
{
|
|
|
if (CommonHelper._dbType == "1")
|
|
|
{
|
|
|
sqlwhere += "and classdate>='" + Convert.ToDateTime(s_txtStDt.Value).ToString("yyyy-MM-dd") + "' and classdate<='" + Convert.ToDateTime(s_txtEndDt.Value).ToString("yyyy-MM-dd") + "'";
|
|
|
}
|
|
|
else if (CommonHelper._dbType == "4")
|
|
|
{
|
|
|
sqlwhere += " and classdate>=DATE_FORMAT('" + Convert.ToDateTime(s_txtStDt.Value).ToString("yyyy-MM-dd") + "','%Y-%m-%d') and classdate<=DATE_FORMAT('" + Convert.ToDateTime(s_txtEndDt.Value).ToString("yyyy-MM-dd") + "','%Y-%m-%d')";
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
sqlwhere += "and classdate>=to_date('" + Convert.ToDateTime(s_txtStDt.Value).ToString("yyyy-MM-dd") + "','yyyy-MM-dd HH24:mi:ss') and classdate<=to_date('" + Convert.ToDateTime(s_txtEndDt.Value).ToString("yyyy-MM-dd") + "','yyyy-MM-dd HH24:mi:ss')";
|
|
|
}
|
|
|
//sqlwhere += " and classdate='" + Convert.ToDateTime(s_txtStartDt.Value).ToString("yyyy-MM-dd") + "'";
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("请选择统计日");
|
|
|
return;
|
|
|
}
|
|
|
try
|
|
|
{
|
|
|
bool f = bbll.CreatePreBlanceForFz(CommonHelper._userStaNo, Convert.ToDateTime(s_txtStartDt.Value).ToString("yyyy-MM-dd"), hdUserId.Value.ToString(), hdMan.Value.ToString(), CommonHelper._userType, CommonHelper._ishighway);
|
|
|
if (f)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("生成预交易平衡信息生成成功");
|
|
|
log.Info("btnBalance_Click", "生成预交易平衡信息生成成功");
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("生成预交易平衡信息生成失败，请重新点击生成");
|
|
|
log.Info("btnBalance_Click", "生成预交易平衡信息生成失败，请重新点击生成");
|
|
|
}
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("生成预交易平衡信息生成异常,联系软件维护人员");
|
|
|
log.Info("btnBalance_Click", ex.Message);
|
|
|
}
|
|
|
StCardInfo.DataBind();
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 手工登记
|
|
|
/// 本人只能更改本人的
|
|
|
/// </summary>
|
|
|
/// <param name="sender"></param>
|
|
|
/// <param name="e"></param>
|
|
|
[DirectMethod]
|
|
|
public void DJEidtFor(string str)
|
|
|
{
|
|
|
if (hdUserId.Text.ToString().ToLower() == "admin")
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("ADMIN禁止操作信息...");
|
|
|
return;
|
|
|
}
|
|
|
DataTable dt;
|
|
|
if (hdMKDt.Value == null || hdMKDt.Value.ToString() == "" || hdoldDt.Value == null || hdoldManNo.Value == null)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("数据已过期，请重新选择修改数据...");
|
|
|
return;
|
|
|
}
|
|
|
if (string.IsNullOrEmpty(str))
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("请选择操作的行");
|
|
|
return;
|
|
|
}
|
|
|
try
|
|
|
{
|
|
|
JObject obj = JObject.Parse(str.Trim());
|
|
|
string verid = obj["VERID"].ToString();
|
|
|
string subcomno = obj["SUBCOMNO"].ToString();
|
|
|
string roadno = obj["ROADNO"].ToString();
|
|
|
string stano = obj["STANO"].ToString();
|
|
|
string classdate = Convert.ToDateTime(obj["CLASSDATE"].ToString()).ToString("yyyy-MM-dd");
|
|
|
string porttype = obj["PORTTYPE"].ToString();
|
|
|
string classno = obj["CLASSNO"].ToString();
|
|
|
string manno = obj["MANNO"].ToString();
|
|
|
string portno = obj["PORTNO"].ToString();
|
|
|
string djbilltype = "1";
|
|
|
string djbillkind = CommonHelper._billKind;
|
|
|
string djbillname = obj["DJBILLNAME"] == null ? "" : obj["DJBILLNAME"].ToString();
|
|
|
if (obj["ADMANNO"] != null && !string.IsNullOrEmpty(obj["ADMANNO"].ToString()) && obj["USERTYPE"] != null)
|
|
|
{
|
|
|
if (!obj["ADMANNO"].ToString().Equals(hdUserId.Value.ToString()) || !obj["USERTYPE"].ToString().Equals(CommonHelper._userType))
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("非本人/非本单位录入数据，不允许更改...");
|
|
|
return;
|
|
|
}
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("票据平衡数据数据不完整，联系维护人员...");
|
|
|
return;
|
|
|
}
|
|
|
//启用修改指令
|
|
|
//if (CommonHelper._updateflag == CommonHelper._UpdateOrder_Flag.ToString())
|
|
|
//{
|
|
|
// string djDt = hdMKDt.Value.ToString();
|
|
|
// TimeSpan ts = DateTime.Now - Convert.ToDateTime(djDt);
|
|
|
// if ((ts.TotalMinutes > 60 && ts.Days == 0) || ts.Days >= 1)
|
|
|
// {
|
|
|
// if (!CommonHelper.CheckUpdate(out dt, Convert.ToDateTime(hdMKDt.Value).Date))
|
|
|
// {
|
|
|
// CommonHelper.MsgShowInfo("未收到-修改指令，不允许更改数据，请提交修改申请...");
|
|
|
// return;
|
|
|
// }
|
|
|
// }
|
|
|
//}
|
|
|
//else
|
|
|
//{
|
|
|
// string djDt = hdMKDt.Value.ToString();
|
|
|
// TimeSpan ts = DateTime.Now - Convert.ToDateTime(djDt);
|
|
|
// if ((ts.Hours > 1 && ts.Days == 0) || ts.Days >= 1)
|
|
|
// {
|
|
|
// CommonHelper.MsgShowInfo("数据已超过1小时，不允许修改...");
|
|
|
// return;
|
|
|
// }
|
|
|
//}
|
|
|
CB_BILLBALANCE_TABLE mdl = new CB_BILLBALANCE_TABLE();
|
|
|
//CLASSDATE=@CLASSDATE and VERID=@VERID and STANO=@STANO and PORTTYPE=@PORTTYPE and MANNO=@MANNO and CLASSNO=@CLASSNO
|
|
|
mdl.VERID = int.Parse(verid);
|
|
|
mdl.STANO = int.Parse(stano);
|
|
|
mdl.PORTNO = int.Parse(portno);
|
|
|
mdl.PORTTYPE = int.Parse(porttype);
|
|
|
mdl.MANNO = int.Parse(manno);
|
|
|
mdl.CLASSNO = int.Parse(classno);
|
|
|
mdl.CLASSDATE = DateTime.Parse(classdate);
|
|
|
|
|
|
mdl.ADMAN = hdMan.Value.ToString();
|
|
|
mdl.ADMANNO = int.Parse(hdUserId.Value.ToString());
|
|
|
mdl.DATEMARK = DateTime.Now;
|
|
|
mdl.DJBILLSTNO = string.IsNullOrEmpty(txtDJBillStNo.Text.Trim()) ? 0 : int.Parse(txtDJBillStNo.Text.Trim());
|
|
|
mdl.DJBILLENDNO = string.IsNullOrEmpty(txtDJBillEndNo.Text.Trim()) ? 0 : int.Parse(txtDJBillEndNo.Text.Trim());
|
|
|
mdl.DJFPCOUNT = string.IsNullOrEmpty(txtDJFPCount.Text.Trim()) ? 0 : int.Parse(txtDJFPCount.Text.Trim());
|
|
|
mdl.DJBADCT = string.IsNullOrEmpty(txtDJBadCt.Text.Trim()) ? 0 : int.Parse(txtDJBadCt.Text.Trim());
|
|
|
mdl.DJBADCASH = string.IsNullOrEmpty(txtDJBadCash.Text.Trim()) ? 0 : Convert.ToInt32(Convert.ToDecimal(txtDJBadCash.Text.Trim()) * 100);
|
|
|
//obj["DJBADCASH"] == null ? 0 : Convert.ToInt32(Convert.ToDecimal(obj["DJBADCASH"].ToString()) * 100);
|
|
|
mdl.DJSGPCT = string.IsNullOrEmpty(txtDJSgpCt.Text.Trim()) ? 0 : int.Parse(txtDJSgpCt.Text.Trim());
|
|
|
mdl.DJSGPINCASH = string.IsNullOrEmpty(txtDJSgpCash.Text.Trim()) ? 0 : Convert.ToInt32(Convert.ToDecimal(txtDJSgpCash.Text.Trim()) * 100);
|
|
|
mdl.DJCKINCASH = string.IsNullOrEmpty(txtDJCKIncash.Text.Trim()) ? 0 : Convert.ToInt32(Convert.ToDecimal(txtDJCKIncash.Text.Trim()) * 100);
|
|
|
mdl.DJINCASH = string.IsNullOrEmpty(txtDjInCash.Text.Trim()) ? 0 : Convert.ToInt32(Convert.ToDecimal(txtDjInCash.Text.Trim()) * 100);
|
|
|
string djckcontent = string.Empty;
|
|
|
if (txtDjCKContent.Text.Trim().Length > 99)
|
|
|
{
|
|
|
djckcontent = txtDjCKContent.Text.Trim().Substring(0, 99);
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
djckcontent = txtDjCKContent.Text.Trim();
|
|
|
}
|
|
|
mdl.DJCKCONTENT = string.IsNullOrEmpty(txtDjCKContent.Text.Trim()) ? "" : djckcontent;
|
|
|
if (CommonHelper._ishighway == "1")
|
|
|
{
|
|
|
mdl.DJBILLTYPE = 1;//1-微机票
|
|
|
mdl.DJBILLKIND = int.Parse(djbillkind);//1-税务票
|
|
|
mdl.DJBILLNAME =int.Parse(djbillname);//票据标识-高速
|
|
|
//mdl.DJBILLTYPE = string.IsNullOrEmpty(CmbDJBillType.SelectedItem.Value) ? 0 : int.Parse(CmbDJBillType.SelectedItem.Value);
|
|
|
//mdl.DJBILLKIND = string.IsNullOrEmpty(CmbDJBillKind.SelectedItem.Value) ? 0 : int.Parse(CmbDJBillKind.SelectedItem.Value);
|
|
|
//mdl.DJBILLNAME = string.IsNullOrEmpty(cmbDJBillName.SelectedItem.Value) ? 0 : int.Parse(cmbDJBillName.SelectedItem.Value);
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
mdl.DJBILLTYPE = 1;//1-微机票
|
|
|
mdl.DJBILLKIND = int.Parse(djbillkind);//1-税务票
|
|
|
mdl.DJBILLNAME = int.Parse(djbillname);//票据标识-一级路
|
|
|
//mdl.DJBILLTYPE = string.IsNullOrEmpty(CmbDJBillType.SelectedItem.Value) ? 0 : int.Parse(CmbDJBillType.SelectedItem.Value);
|
|
|
//mdl.DJBILLKIND = string.IsNullOrEmpty(CmbDJBillKind.SelectedItem.Value) ? 0 : int.Parse(CmbDJBillKind.SelectedItem.Value);
|
|
|
//mdl.DJBILLNAME = string.IsNullOrEmpty(cmbDJBillName.SelectedItem.Value) ? 0 : int.Parse(cmbDJBillName.SelectedItem.Value);
|
|
|
}
|
|
|
mdl.BAK3 = txtDJBillSerialNO.Text.Trim();
|
|
|
if (bbll.UpdateDJBalance(mdl, CreateLog(subcomno, verid, classdate, stano, porttype, manno, classno)))
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("票平衡人工登记成功");
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("票平衡人工登记失败，请重新操作！");
|
|
|
}
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("票平衡人工登记异常:" + ex.Message);
|
|
|
}
|
|
|
StCardInfo.DataBind();
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 构建日志（参数：主键值）
|
|
|
/// </summary>
|
|
|
/// <param name="verid"></param>
|
|
|
/// <param name="classdate"></param>
|
|
|
/// <param name="stano"></param>
|
|
|
/// <param name="porttype"></param>
|
|
|
/// <param name="manno"></param>
|
|
|
/// <param name="classno"></param>
|
|
|
/// <returns></returns>
|
|
|
public CB_OP_LOG CreateLog(string subcomno, string verid, string classdate, string stano, string porttype, string manno, string classno)
|
|
|
{
|
|
|
//CLASSDATE=@CLASSDATE and VERID=@VERID and STANO=@STANO and PORTTYPE=@PORTTYPE and MANNO=@MANNO and CLASSNO=@CLASSNO
|
|
|
bool f = false;
|
|
|
CB_OP_LOG mdl = new CB_OP_LOG();
|
|
|
try
|
|
|
{
|
|
|
string n_classdt = "00000000" + Convert.ToDateTime(classdate).ToString("yyyyMMdd");
|
|
|
string n_verId = "00000" + verid;
|
|
|
string n_stano = "0000" + stano;
|
|
|
string n_potytype = "00" + porttype;
|
|
|
string n_manno = "0000000000000000" + manno;
|
|
|
string n_classno = "00" + classno;
|
|
|
string n_subcomno = "0000" + subcomno;
|
|
|
string keyNo = n_classdt.Substring(n_classdt.Length - 8) + n_verId.Substring(n_verId.Length - 5) + n_stano.Substring(n_stano.Length - 4) + n_potytype.Substring(n_potytype.Length - 2) + n_manno.Substring(n_manno.Length - 16) + n_classno.Substring(n_classno.Length - 2);
|
|
|
mdl.KEYLISTNO = keyNo;//主键集合
|
|
|
mdl.ID = CommonHelper._Prmis_Bill_Balance + n_subcomno.Substring(n_subcomno.Length - 4) + n_stano.Substring(n_stano.Length - 4) + DateTime.Now.ToString("yyyyMMddHHmmss");
|
|
|
mdl.TBNAME = CommonHelper.GetTbNameByPrmisid(CommonHelper._Prmis_Bill_Balance);//对应的表名称
|
|
|
mdl.TYPE = CommonHelper._OpLog_Jx;//1-根据字典表解析KEYLISTNO 2-不需要解析
|
|
|
mdl.PRMISID = CommonHelper._Prmis_Bill_Balance;//模块号
|
|
|
mdl.SUBCOMNO = int.Parse(subcomno);
|
|
|
mdl.STANO = int.Parse(CommonHelper._userStaNo);
|
|
|
mdl.OPTYPE = 1;//产生日志类型 1-修改
|
|
|
mdl.OLDT = Convert.ToDateTime(hdoldDt.Value.ToString());
|
|
|
mdl.OLMANNO = int.Parse(hdoldManNo.Value.ToString());
|
|
|
mdl.OLMAN = hdoldMan.Value.ToString();
|
|
|
mdl.OLUSERTYPE = int.Parse(hdoldUType.Value.ToString());
|
|
|
mdl.DATETIME = DateTime.Now;
|
|
|
mdl.UPMANNO = int.Parse(hdUserId.Value.ToString());
|
|
|
mdl.UPMAN = hdMan.Value.ToString();
|
|
|
mdl.UPUSERTYPE = int.Parse(CommonHelper._userType);
|
|
|
mdl.BAK1 = 0;
|
|
|
mdl.BAK2 = 0;
|
|
|
mdl.BAK3 = 0;
|
|
|
mdl.BAK4 = string.Empty;
|
|
|
mdl.BAK5 = string.Empty;
|
|
|
mdl.BAK6 = string.Empty;
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
mdl = null;
|
|
|
}
|
|
|
return mdl;
|
|
|
}
|
|
|
|
|
|
#region 票据信息管理
|
|
|
|
|
|
protected void stBillName_RefreshData(object sender, Ext.Net.StoreRefreshDataEventArgs e)
|
|
|
{
|
|
|
int start; int limit;
|
|
|
if (!string.IsNullOrEmpty(e.Parameters["Start"]) && !string.IsNullOrEmpty(e.Parameters["Limit"]))
|
|
|
{
|
|
|
start = int.Parse(e.Parameters["Start"]);
|
|
|
limit = int.Parse(e.Parameters["Limit"]);
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
start = e.Start;
|
|
|
limit = e.Limit;
|
|
|
}
|
|
|
int ct = 0;
|
|
|
DataTable dt = bbll.GetBillNameLst("", start, start + limit, out ct);
|
|
|
e.Total = ct;
|
|
|
stBillName.DataSource = dt;
|
|
|
stBillName.DataBind();
|
|
|
}
|
|
|
public void E_btnAdd_Click(object sender, Ext.Net.DirectEventArgs e)
|
|
|
{
|
|
|
int v = 0;
|
|
|
try
|
|
|
{
|
|
|
|
|
|
string sqlStr = "insert into CB_BILLNAME_TEXT(VALUE,TEXT,TYPE,KIND) VALUES('{0}','{1}','{2}','{3}')";
|
|
|
if (string.IsNullOrEmpty(E_CmbBillType.SelectedItem.Value))
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("选取票据类型");
|
|
|
return;
|
|
|
}
|
|
|
if (string.IsNullOrEmpty(E_CmbBillKind.SelectedItem.Value))
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("选取票据种类");
|
|
|
return;
|
|
|
}
|
|
|
if (string.IsNullOrEmpty(E_txtBillName.Text.Trim()))
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("输入票据信息");
|
|
|
return;
|
|
|
}
|
|
|
string billName = string.Empty;
|
|
|
if (E_txtBillName.Text.Trim().Length > 99)
|
|
|
{
|
|
|
billName = E_txtBillName.Text.Trim().Substring(0, 99);
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
billName = E_txtBillName.Text.Trim();
|
|
|
}
|
|
|
object obj = dicbll.GetCBMaxBillName(" and type='" + E_CmbBillType.SelectedItem.Value + "' and kind='" + E_CmbBillKind.SelectedItem.Value + "'");
|
|
|
if (obj == null)
|
|
|
{
|
|
|
v = 0;
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
v = int.Parse(obj.ToString());
|
|
|
}
|
|
|
string sql = string.Format(sqlStr, v, billName, E_CmbBillType.SelectedItem.Value, E_CmbBillKind.SelectedItem.Value);
|
|
|
if (dicbll.MyExcute(sql))
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("票据信息录入成功");
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("票据信息录入失败");
|
|
|
}
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("新增票据信息异常：" + ex.Message);
|
|
|
}
|
|
|
wdDetail.Hide();
|
|
|
stBillName.DataBind();
|
|
|
}
|
|
|
/// <summary>
|
|
|
///
|
|
|
/// </summary>
|
|
|
/// <param name="v"></param>
|
|
|
[DirectMethod]
|
|
|
public void E_Delete(string v)
|
|
|
{
|
|
|
try
|
|
|
{
|
|
|
string sql = "delete from CB_BILLNAME_TEXT where VALUE='" + v + "'";
|
|
|
if (dicbll.MyExcute(sql))
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("票据信息删除成功");
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("票据信息删除失败");
|
|
|
}
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("删除票据信息异常：" + ex.Message);
|
|
|
}
|
|
|
stBillName.DataBind();
|
|
|
}
|
|
|
#endregion 票据信息管理
|
|
|
}
|
|
|
} |