You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
657 lines
26 KiB
C#
657 lines
26 KiB
C#
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;
|
|
|
|
namespace CPCBILLSYS
|
|
{
|
|
public partial class BillApplyFor : 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;
|
|
s_txtEndDt.Value = DateTime.Now;
|
|
StBillApplyFor.AutoLoadParams.Add(new Ext.Net.Parameter("Start", "0"));
|
|
StBillApplyFor.AutoLoadParams.Add(new Ext.Net.Parameter("Limit", Paging.PageSize.ToString()));
|
|
BindBillType();
|
|
BindBillKind();
|
|
BindBillName();
|
|
BindSubCompany();
|
|
BindSPFlag();
|
|
SetColumnShow();
|
|
}
|
|
}
|
|
|
|
#region 数据绑定
|
|
public void SetColumnShow()
|
|
{
|
|
if (CommonHelper._userType == "1")
|
|
{
|
|
btnCreateBill.Hide();
|
|
btnEidt.Show();
|
|
btnAddDj.Show();
|
|
//cmbSPFlag.Hide();
|
|
btnDelete.Show();
|
|
btnUP.Hide();
|
|
}
|
|
else if (CommonHelper._userType == "2")
|
|
{
|
|
btnCreateBill.Show();
|
|
btnEidt.Hide();
|
|
btnAddDj.Hide();
|
|
btnEidt.Show();
|
|
//cmbSPFlag.Show();
|
|
btnDelete.Hide();
|
|
btnUP.Show();
|
|
}
|
|
else if (CommonHelper._userType == "3")
|
|
{
|
|
btnCreateBill.Hide();
|
|
btnEidt.Hide();
|
|
btnAddDj.Hide();
|
|
btnEdit.Hide();
|
|
//cmbSPFlag.Show();
|
|
btnDelete.Hide();
|
|
btnUP.Hide();
|
|
}
|
|
}
|
|
public void BindSubCompany()
|
|
{
|
|
DataTable dt = null;
|
|
if (CommonHelper._userType == "1")
|
|
{
|
|
DataTable dtName = dicbll.GetStaAllInfo(" and STANO='" + CommonHelper._userStaNo + "'");
|
|
|
|
dt = dicbll.GetSubCompany(" and SUBCOMNO='" + dtName.Rows[0]["SUBCOMNO"].ToString() + "'");
|
|
}
|
|
else
|
|
{
|
|
dt = dicbll.GetSubCompany(" and SUBCOMNO='" + CommonHelper._userStaNo + "'");
|
|
}
|
|
storeSubCompany.DataSource = dt;
|
|
storeSubCompany.DataBind();
|
|
}
|
|
public void BindBillType()
|
|
{
|
|
stBillType.DataSource = dicbll.GetCBKind(" and VALUE in(1,2)");
|
|
stBillType.DataBind();
|
|
}
|
|
public void BindBillKind()
|
|
{
|
|
stBillKind.DataSource = dicbll.GetCBBillKind("");
|
|
stBillKind.DataBind();
|
|
}
|
|
public void BindBillName()
|
|
{
|
|
stBillName.DataSource = dicbll.GetCBBillName("");
|
|
stBillName.DataBind();
|
|
}
|
|
public void BindSPFlag()
|
|
{
|
|
stSpFlag.DataSource = dicbll.GetSPFlag(" and VALUE in(1,2)");
|
|
stSpFlag.DataBind();
|
|
DataTable dt;
|
|
if (CommonHelper._userType == "1")
|
|
{
|
|
dt = dicbll.GetSPFlag(" and VALUE in(0,1,2)");
|
|
}
|
|
else if (CommonHelper._userType == "2")
|
|
{
|
|
dt = dicbll.GetSPFlag(" and VALUE in(1,2,3)");
|
|
}
|
|
else
|
|
{
|
|
dt = dicbll.GetSPFlag(" and VALUE in(1,2)");
|
|
}
|
|
s_stSpFlag.DataSource = dt;
|
|
s_stSpFlag.DataBind();
|
|
}
|
|
/// <summary>
|
|
/// 绑定票据种类
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void cmbBillKind_Select(object sender, Ext.Net.DirectEventArgs e)
|
|
{
|
|
if (string.IsNullOrEmpty(cmbBillType.SelectedItem.Value))
|
|
{
|
|
CommonHelper.MsgShowInfo("请选择票据类型...");
|
|
return;
|
|
}
|
|
stBillName.DataSource = dicbll.GetCBBillName(" and TYPE=" + cmbBillType.SelectedItem.Value + " and KIND=" + cmbBillKind.SelectedItem.Value + "");
|
|
stBillName.DataBind();
|
|
}
|
|
protected void cmbBillName_Select(object sender, Ext.Net.DirectEventArgs e)
|
|
{
|
|
txtBillName.Text = cmbBillName.SelectedItem.Text;
|
|
}
|
|
/// <summary>
|
|
///
|
|
/// </summary>
|
|
/// <param name="sneder"></param>
|
|
/// <param name="e"></param>
|
|
protected void cmbSubCom_Select(object sneder, Ext.Net.DirectEventArgs e)
|
|
{
|
|
DataTable dt = null;
|
|
try
|
|
{
|
|
if (CommonHelper._userType == "1")
|
|
{
|
|
dt = dicbll.GetStaAllInfo(" and STANO='" + CommonHelper._userStaNo + "'");
|
|
}
|
|
else
|
|
{
|
|
dt = dicbll.GetStaAllInfo(" and SUBCOMNO='" + cmbSubCom.SelectedItem.Value + "'");
|
|
}
|
|
}
|
|
catch
|
|
{
|
|
dt = new DataTable();
|
|
}
|
|
stSta.DataSource = dt;
|
|
stSta.DataBind();
|
|
}
|
|
#endregion 数据绑定
|
|
|
|
/// <summary>
|
|
/// 查询
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void btnSearch_Click(object sender, Ext.Net.DirectEventArgs e)
|
|
{
|
|
Paging.SetPageIndex(1);
|
|
StBillApplyFor.DataBind();
|
|
}
|
|
/// <summary>
|
|
/// 加载数据
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void StBillApplyFor_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_txtStartDt.Value == null || string.IsNullOrEmpty(s_txtStartDt.Value.ToString()))
|
|
{
|
|
CommonHelper.MsgShowInfo("请选择查询日期！");
|
|
return;
|
|
}
|
|
string sqlwhere = string.Empty;
|
|
if (CommonHelper._dbType == "1")
|
|
{
|
|
sqlwhere += " and MKDT>='" + Convert.ToDateTime(s_txtStartDt.Value).ToString("yyyy-MM-dd HH:mm:ss") + "' and MKDT<='" + Convert.ToDateTime(s_txtEndDt.Value).AddDays(1).AddSeconds(-1).ToString("yyyy-MM-dd HH:mm:ss") + "'";
|
|
}
|
|
else if (CommonHelper._dbType == "4")
|
|
{
|
|
sqlwhere += " and MKDT>=DATE_FORMAT('" + Convert.ToDateTime(s_txtStartDt.Value).ToString("yyyy-MM-dd HH:mm:ss") + "','%Y-%m-%d %H:%i:%s') and MKDT<=DATE_FORMAT('" + Convert.ToDateTime(s_txtEndDt.Value).AddDays(1).AddSeconds(-1).ToString("yyyy-MM-dd HH:mm:ss") + "','%Y-%m-%d %H:%i:%s')";
|
|
}
|
|
else
|
|
{
|
|
sqlwhere += " and MKDT>=to_date('" + Convert.ToDateTime(s_txtStartDt.Value).ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd HH24:mi:ss') and MKDT<=to_date('" + Convert.ToDateTime(s_txtEndDt.Value).AddDays(1).AddSeconds(-1).ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd HH24:mi:ss')";
|
|
}
|
|
if (!string.IsNullOrEmpty(s_cmbSpFlag.SelectedItem.Value))
|
|
{
|
|
sqlwhere += " and SPFLAG=" + s_cmbSpFlag.SelectedItem.Value + "";
|
|
}
|
|
if (CommonHelper._userType == "2" && CommonHelper._ishighway == "2")
|
|
{
|
|
sqlwhere += " and SUBCOMNO=" + CommonHelper._userStaNo + "";
|
|
}
|
|
int ct = 0;
|
|
DataTable dt = bbll.GetApplayForLst(sqlwhere, start + 1, start + limit, out ct);
|
|
e.Total = ct;
|
|
StBillApplyFor.DataSource = dt;
|
|
StBillApplyFor.DataBind();
|
|
}
|
|
/// <summary>
|
|
/// 增加
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void btnAdd_Click(object sender, Ext.Net.DirectEventArgs e)
|
|
{
|
|
try
|
|
{
|
|
if (hdUserId.Text.ToString().ToLower() == "admin")
|
|
{
|
|
CommonHelper.MsgShowInfo("ADMIN禁止操作信息...");
|
|
return;
|
|
}
|
|
if (string.IsNullOrEmpty(cmbSubCom.SelectedItem.Value) || string.IsNullOrEmpty(cmbSta.SelectedItem.Value))
|
|
{
|
|
CommonHelper.MsgShowInfo("请选择对应的分公司/收费站");
|
|
return;
|
|
}
|
|
if (string.IsNullOrEmpty(cmbBillType.SelectedItem.Value) || string.IsNullOrEmpty(cmbBillKind.SelectedItem.Value))
|
|
{
|
|
CommonHelper.MsgShowInfo("请选择对应的发票种类/发票类别");
|
|
return;
|
|
}
|
|
if (string.IsNullOrEmpty(cmbBillName.SelectedItem.Value))
|
|
{
|
|
CommonHelper.MsgShowInfo("请选择对应的发票名称");
|
|
return;
|
|
}
|
|
long ct = 0;
|
|
if (string.IsNullOrEmpty(txtCount.Text.Trim()))
|
|
{
|
|
CommonHelper.MsgShowInfo("请输入正确的票据数量");
|
|
return;
|
|
}
|
|
else
|
|
{
|
|
if (!long.TryParse(txtCount.Text.Trim(), out ct))
|
|
{
|
|
CommonHelper.MsgShowInfo("请输入正确的票据数量");
|
|
return;
|
|
}
|
|
}
|
|
CB_BILLAPPLYFOR mdl = new CB_BILLAPPLYFOR();
|
|
string subStr = "000" + cmbSubCom.SelectedItem.Value;
|
|
string staStr = "000" + cmbSta.SelectedItem.Value;
|
|
string billtype = "00" + cmbBillType.SelectedItem.Value;
|
|
mdl.APPLYNO = "A" + billtype.Substring(billtype.Length - 2) + subStr.Substring(subStr.Length - 4) + staStr.Substring(staStr.Length - 4) + DateTime.Now.ToString("yyyyMMddHHmmss");
|
|
mdl.SUBCOMNO = int.Parse(cmbSubCom.SelectedItem.Value);
|
|
try
|
|
{
|
|
DataTable dtName = dicbll.GetStaAllInfo(" and STANO='" + cmbSta.SelectedItem.Value + "'");
|
|
mdl.ROADNO = int.Parse(dtName.Rows[0]["ROADNO"].ToString());
|
|
}
|
|
catch
|
|
{
|
|
mdl.ROADNO = 15;
|
|
}
|
|
mdl.STANO = int.Parse(cmbSta.SelectedItem.Value);
|
|
mdl.BILLTYPE = int.Parse(cmbBillType.SelectedItem.Value);
|
|
mdl.BILLKIND = int.Parse(cmbBillKind.SelectedItem.Value);
|
|
mdl.BILLNAME = int.Parse(cmbBillName.SelectedItem.Value);
|
|
mdl.COUNT = ct;
|
|
mdl.MKDT = DateTime.Now;
|
|
//站级不审批
|
|
mdl.SPFLAG = 0;//新单据
|
|
mdl.SPMANNO = int.Parse(hdUserId.Value.ToString());
|
|
mdl.SPMAN = hdMan.Value.ToString();
|
|
mdl.SPDT = DateTime.Now;
|
|
mdl.BAK1 = int.Parse(CommonHelper._userType);
|
|
if (bbll.AddApplayFor(mdl))
|
|
{
|
|
CommonHelper.MsgShowInfo("申领单登记成功");
|
|
}
|
|
else
|
|
{
|
|
CommonHelper.MsgShowInfo("申领单登记失败");
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
CommonHelper.MsgShowInfo("申领单登记异常：" + ex.Message);
|
|
}
|
|
wdEdit.Hide();
|
|
StBillApplyFor.DataBind();
|
|
}
|
|
/// <summary>
|
|
/// 修改
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void btnEdit_Click(object sender, Ext.Net.DirectEventArgs e)
|
|
{
|
|
try
|
|
{
|
|
if (hdUserId.Text.ToString().ToLower() == "admin")
|
|
{
|
|
CommonHelper.MsgShowInfo("ADMIN禁止操作信息...");
|
|
return;
|
|
}
|
|
DataTable dt;
|
|
if (hdApplayNO.Value == null || hdMKDt.Value == null || hdMKDt.Value.ToString() == "" || hdoldManNo.Value == null || hdoldMan.Value == null)
|
|
{
|
|
CommonHelper.MsgShowInfo("数据已过期，请重新选择修改数据...");
|
|
return;
|
|
}
|
|
else
|
|
{
|
|
if (hdoldManNo.Value != null && !string.IsNullOrEmpty(hdoldManNo.Value.ToString()))
|
|
{
|
|
if (!hdoldManNo.Value.Equals(hdUserId.Value.ToString()))
|
|
{
|
|
CommonHelper.MsgShowInfo("非本人录入数据，不允许更改...");
|
|
return;
|
|
}
|
|
}
|
|
}
|
|
if (string.IsNullOrEmpty(cmbSubCom.SelectedItem.Value) || string.IsNullOrEmpty(cmbSta.SelectedItem.Value))
|
|
{
|
|
CommonHelper.MsgShowInfo("请选择对应的分公司/收费站");
|
|
return;
|
|
}
|
|
if (string.IsNullOrEmpty(cmbBillType.SelectedItem.Value) || string.IsNullOrEmpty(cmbBillKind.SelectedItem.Value))
|
|
{
|
|
CommonHelper.MsgShowInfo("请选择对应的发票种类/发票类别");
|
|
return;
|
|
}
|
|
if (string.IsNullOrEmpty(cmbBillName.SelectedItem.Value))
|
|
{
|
|
CommonHelper.MsgShowInfo("请选择对应的发票名称");
|
|
return;
|
|
}
|
|
long ct = 0;
|
|
if (string.IsNullOrEmpty(txtCount.Text.Trim()))
|
|
{
|
|
CommonHelper.MsgShowInfo("请输入正确的票据数量");
|
|
return;
|
|
}
|
|
else
|
|
{
|
|
if (!long.TryParse(txtCount.Text.Trim(), out ct))
|
|
{
|
|
CommonHelper.MsgShowInfo("请输入正确的票据数量");
|
|
return;
|
|
}
|
|
}
|
|
|
|
//if (CommonHelper._userType == "2" || CommonHelper._userType == "3")
|
|
//{
|
|
// if (string.IsNullOrEmpty(cmbSPFlag.SelectedItem.Value))
|
|
// {
|
|
// CommonHelper.MsgShowInfo("请选择对应的审批结果");
|
|
// return;
|
|
// }
|
|
//}
|
|
|
|
CB_BILLAPPLYFOR mdl = new CB_BILLAPPLYFOR();
|
|
mdl.APPLYNO = hdApplayNO.Value.ToString();
|
|
mdl.SUBCOMNO = int.Parse(cmbSubCom.SelectedItem.Value);
|
|
try
|
|
{
|
|
DataTable dtName = dicbll.GetStaAllInfo(" and STANO='" + cmbSta.SelectedItem.Value + "'");
|
|
mdl.ROADNO = int.Parse(dtName.Rows[0]["ROADNO"].ToString());
|
|
}
|
|
catch
|
|
{
|
|
mdl.ROADNO = 15;
|
|
}
|
|
mdl.STANO = int.Parse(cmbSta.SelectedItem.Value);
|
|
mdl.BILLTYPE = int.Parse(cmbBillType.SelectedItem.Value);
|
|
mdl.BILLKIND = int.Parse(cmbBillKind.SelectedItem.Value);
|
|
mdl.BILLNAME = int.Parse(cmbBillName.SelectedItem.Value);
|
|
mdl.MKDT = DateTime.Now;
|
|
mdl.COUNT = ct;
|
|
mdl.SPFLAG = CommonHelper._SpFlag_NEW;//新单据
|
|
//if (CommonHelper._userType == "1")
|
|
//{
|
|
// //站级不审批
|
|
// mdl.SPFLAG = CommonHelper._SpFlag_NEW;//新单据
|
|
//}
|
|
//else
|
|
//{
|
|
// mdl.SPFLAG = int.Parse(cmbSPFlag.SelectedItem.Value);//新单据
|
|
//}
|
|
mdl.SPMANNO = int.Parse(hdUserId.Value.ToString());
|
|
mdl.SPMAN = hdMan.Value.ToString();
|
|
mdl.SPDT = DateTime.Now;
|
|
mdl.BAK1 = int.Parse(CommonHelper._userType);
|
|
if (bbll.UpdateApplayFor(mdl))
|
|
{
|
|
CommonHelper.MsgShowInfo("站级-申领单修改成功");
|
|
}
|
|
else
|
|
{
|
|
CommonHelper.MsgShowInfo("站级-申领单修改失败");
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
CommonHelper.MsgShowInfo("申领单修改异常：" + ex.Message);
|
|
}
|
|
wdEdit.Hide();
|
|
StBillApplyFor.DataBind();
|
|
}
|
|
/// <summary>
|
|
/// 删除
|
|
/// </summary>
|
|
/// <param name="applayno"></param>
|
|
[DirectMethod]
|
|
public void DeleteApplyFor(string applayno)
|
|
{
|
|
try
|
|
{
|
|
if (hdUserId.Text.ToString().ToLower() == "admin")
|
|
{
|
|
CommonHelper.MsgShowInfo("ADMIN禁止操作信息...");
|
|
return;
|
|
}
|
|
if (bbll.DeleteApplayFor(applayno))
|
|
{
|
|
CommonHelper.MsgShowInfo("申领单删除成功");
|
|
}
|
|
else
|
|
{
|
|
CommonHelper.MsgShowInfo("申领单删除失败");
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
CommonHelper.MsgShowInfo("申领单删除异常：" + ex.Message);
|
|
}
|
|
StBillApplyFor.DataBind();
|
|
}
|
|
/// <summary>
|
|
/// 审批单据
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
[DirectMethod]
|
|
public void SPApplayInfo(string applayno)
|
|
{
|
|
try
|
|
{
|
|
if (hdUserId.Text.ToString().ToLower() == "admin")
|
|
{
|
|
CommonHelper.MsgShowInfo("ADMIN禁止操作信息...");
|
|
return;
|
|
}
|
|
CB_BILLAPPLYFOR mdl = new CB_BILLAPPLYFOR();
|
|
mdl.APPLYNO = applayno;
|
|
mdl.SPFLAG = CommonHelper._SpFlag_SP;
|
|
mdl.SPMANNO = int.Parse(hdUserId.Value.ToString());
|
|
mdl.SPMAN = hdMan.Value.ToString();
|
|
mdl.SPDT = DateTime.Now;
|
|
//spflag=1--封单-用于上传
|
|
if (bbll.UpdateApplayForSP(mdl))
|
|
{
|
|
CommonHelper.MsgShowInfo("单据审批成功");
|
|
}
|
|
else
|
|
{
|
|
CommonHelper.MsgShowInfo("单据审批失败");
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
CommonHelper.MsgShowInfo("单据审批异常：" + ex.Message);
|
|
}
|
|
StBillApplyFor.DataBind();
|
|
}
|
|
/// <summary>
|
|
/// 生成单据单-供总中心使用
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void btnCreateBill_Click(object sender, Ext.Net.DirectEventArgs e)
|
|
{
|
|
if (hdUserId.Text.ToString().ToLower() == "admin")
|
|
{
|
|
CommonHelper.MsgShowInfo("ADMIN禁止操作信息...");
|
|
return;
|
|
}
|
|
//分公司-将审批通过的单据汇总
|
|
if (s_txtStartDt.Value == null || string.IsNullOrEmpty(s_txtStartDt.Value.ToString()))
|
|
{
|
|
CommonHelper.MsgShowInfo("请选择操纵日期！");
|
|
return;
|
|
}
|
|
string sqlwhere = string.Empty;
|
|
if (CommonHelper._dbType == "1")
|
|
{
|
|
sqlwhere += " and MKDT>='" + Convert.ToDateTime(s_txtStartDt.Value).ToString("yyyy-MM-dd HH:mm:ss") + "' and MKDT<='" + Convert.ToDateTime(s_txtEndDt.Value).AddDays(1).AddSeconds(-1).ToString("yyyy-MM-dd HH:mm:ss") + "'";
|
|
}
|
|
else
|
|
{
|
|
sqlwhere += " and MKDT>=to_date('" + Convert.ToDateTime(s_txtStartDt.Value).ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd HH24:mi:ss') and MKDT<=to_date('" + Convert.ToDateTime(s_txtEndDt.Value).AddDays(1).AddSeconds(-1).ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd HH24:mi:ss')";
|
|
}
|
|
sqlwhere += " and BAK1=1 and SPFLAG=2";
|
|
//将站级SPFLAG=2-已审批的数据-汇总成一个单据-上传分中心
|
|
//审批成功数据汇总放入上传表
|
|
List<string> lst = new List<string>();
|
|
List<IDataParameter[]> cmdParamList = new List<IDataParameter[]>();
|
|
try
|
|
{
|
|
DataTable dt = bbll.GetApplayForSum(sqlwhere);
|
|
if (dt.Rows.Count == 0)
|
|
{
|
|
CommonHelper.MsgShowInfo("不存在审批数据，无法生成分公司单据，请完成审批");
|
|
return;
|
|
}
|
|
foreach (DataRow item in dt.Rows)
|
|
{
|
|
CB_BILLAPPLYFOR mdl = new CB_BILLAPPLYFOR();
|
|
string subStr = "000" + item["SUBCOMNO"].ToString();
|
|
string staStr = "000" + item["SUBCOMNO"].ToString();
|
|
string billtype = "00" + item["BILLTYPE"].ToString();
|
|
mdl.APPLYNO = "A" + billtype.Substring(billtype.Length - 2) + subStr.Substring(subStr.Length - 4) + staStr.Substring(staStr.Length - 4) + DateTime.Now.ToString("yyyyMMddHHmmss");
|
|
if (bbll.IsExist("select count(1) from CB_BILLAPPLYFOR_GTCENTER where APPLYNO='" + mdl.APPLYNO + "'") > 0)
|
|
{
|
|
bbll.ExcuteSql("delete from CB_BILLAPPLYFOR_GTCENTER where APPLYNO='" + mdl.APPLYNO + "'");
|
|
}
|
|
mdl.SUBCOMNO = int.Parse(item["SUBCOMNO"].ToString());
|
|
mdl.ROADNO = int.Parse(item["SUBCOMNO"].ToString());
|
|
mdl.STANO = int.Parse(item["SUBCOMNO"].ToString());
|
|
mdl.BILLTYPE = int.Parse(item["BILLTYPE"].ToString());
|
|
mdl.BILLKIND = int.Parse(item["BILLKIND"].ToString());
|
|
mdl.BILLNAME = int.Parse(item["BILLNAME"].ToString());
|
|
mdl.COUNT = long.Parse(item["COUNT"].ToString());
|
|
mdl.MKDT = DateTime.Now;
|
|
//站级不审批
|
|
mdl.SPFLAG = CommonHelper._SpFlag_NEW;
|
|
mdl.SPMANNO = int.Parse(hdUserId.Value.ToString());
|
|
mdl.SPMAN = hdMan.Value.ToString();
|
|
mdl.SPDT = DateTime.Now;
|
|
mdl.BAK1 = int.Parse(CommonHelper._userType);
|
|
if (bbll.AddApplayFor(mdl))
|
|
{
|
|
CommonHelper.MsgShowInfo("生成单据成功");
|
|
}
|
|
else
|
|
{
|
|
CommonHelper.MsgShowInfo("生成单据失败");
|
|
}
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
CommonHelper.MsgShowInfo("生成单据异常：" + ex.Message);
|
|
}
|
|
StBillApplyFor.DataBind();
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
/// 审批单据
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
[DirectMethod]
|
|
public void UpApplayInfo(string applayno)
|
|
{
|
|
try
|
|
{
|
|
if (hdUserId.Text.ToString().ToLower() == "admin")
|
|
{
|
|
CommonHelper.MsgShowInfo("ADMIN禁止操作信息...");
|
|
return;
|
|
}
|
|
CB_BILLAPPLYFOR mdl = new CB_BILLAPPLYFOR();
|
|
mdl.APPLYNO = applayno;
|
|
mdl.SPFLAG = CommonHelper._SpFlag_SPHZ;
|
|
mdl.SPMANNO = int.Parse(hdUserId.Value.ToString());
|
|
mdl.SPMAN = hdMan.Value.ToString();
|
|
mdl.SPDT = DateTime.Now;
|
|
//spflag=1--封单-用于上传
|
|
if (bbll.UpdateApplayForSP(mdl))
|
|
{
|
|
CommonHelper.MsgShowInfo("单据上传成功");
|
|
}
|
|
else
|
|
{
|
|
CommonHelper.MsgShowInfo("单据上传失败");
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
CommonHelper.MsgShowInfo("单据上传异常：" + ex.Message);
|
|
}
|
|
StBillApplyFor.DataBind();
|
|
}
|
|
}
|
|
} |