295 lines
11 KiB
C#
295 lines
11 KiB
C#
using System;
|
|
using System.Data;
|
|
using System.Configuration;
|
|
using System.Collections;
|
|
using System.Web;
|
|
using System.Web.Security;
|
|
using System.Web.UI;
|
|
using System.Web.UI.WebControls;
|
|
using System.Web.UI.WebControls.WebParts;
|
|
using System.Web.UI.HtmlControls;
|
|
using GThinking.N_MISPRO;
|
|
using GThinking.N_MISPRO.Data;
|
|
using GThinking.N_MODEL.Page;
|
|
using GThinking.N_MISPRO.Utility;
|
|
using GThinking.N_PUBLIC;
|
|
using GThinking.N_MODEL.Dialog;
|
|
|
|
namespace GThinking.N_XLXSBJ
|
|
{
|
|
public partial class BJYF_JEBLInfo : SingleCardBase
|
|
{
|
|
BJYFZB entity = new BJYFZB();
|
|
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
{
|
|
this.UMID = 100860071;
|
|
this.UMName = "线缆销售报价单运费";
|
|
this.CurMaster = Master;
|
|
this.CurEntity = entity;
|
|
this.PageHeight = 500;
|
|
this.PageWidth = 700;
|
|
|
|
if (!IsPostBack)
|
|
{
|
|
InitControls();
|
|
}
|
|
|
|
base.InitPage();
|
|
}
|
|
|
|
#region 模板事件继承
|
|
|
|
protected override void SetControlState()
|
|
{
|
|
base.SetControlState();
|
|
cbxYFJSFS.Enabled = false;
|
|
txtWHR.Enabled = false;
|
|
datWHSJ.Enabled = false;
|
|
}
|
|
|
|
protected override void LoadRecord()
|
|
{
|
|
if (!IsPostBack)
|
|
{
|
|
entity.Param.Add("OLDXZQHID", PageParam.GetRTrimString("XLXSBJDQYFZB_XZQHID"));
|
|
}
|
|
else
|
|
{
|
|
entity.Param.Add("OLDXZQHID", txtOLDXZQHID.Value);
|
|
}
|
|
base.LoadRecord();
|
|
txtOLDXZQHID.Value = txtXZQHID.Value.Trim();
|
|
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
SQL.Clear();
|
|
SQL.Add("select XZQH_XZQHID,XZQH_FID,XZQH_PROVINCE,XZQH_CITY,XZQH_COUNTY from XZQH where XZQH_XZQHID = :pXZQHID ");
|
|
SQL.ParamByName("pXZQHID").Value = txtXZQHID.Value;
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
if (ds.Tables[0].Rows[0]["XZQH_FID"].ToString().Trim().Equals("86"))
|
|
{
|
|
cbxKHSZDPRO.SelectedValue = ds.Tables[0].Rows[0]["XZQH_XZQHID"].ToString().Trim();
|
|
cbxKHSZDCITY.SelectedValue = "";
|
|
cbxKHSZDCOUNTY.SelectedValue = "";
|
|
}
|
|
else if (ds.Tables[0].Rows[0]["XZQH_FID"].ToString().Trim().EndsWith("0000"))
|
|
{
|
|
cbxKHSZDPRO.SelectedValue = ds.Tables[0].Rows[0]["XZQH_FID"].ToString().Trim();
|
|
cbxKHSZDCITY.SelectedValue = ds.Tables[0].Rows[0]["XZQH_XZQHID"].ToString().Trim();
|
|
cbxKHSZDCOUNTY.SelectedValue = "";
|
|
}
|
|
else
|
|
{
|
|
cbxKHSZDCITY.SelectedValue = ds.Tables[0].Rows[0]["XZQH_FID"].ToString().Trim();
|
|
cbxKHSZDCOUNTY.SelectedValue = ds.Tables[0].Rows[0]["XZQH_XZQHID"].ToString().Trim();
|
|
TSQL sSQL = new TSQL(dberp);
|
|
sSQL.Clear();
|
|
sSQL.Add("select XZQH_XZQHID,XZQH_FID from XZQH where XZQH_XZQHID = :pXZQHID ");
|
|
sSQL.ParamByName("pXZQHID").Value = cbxKHSZDCITY.SelectedValue.Trim();
|
|
DataSet dsPRO = dberp.OpenDataSet(sSQL);
|
|
if (dsPRO.Tables[0].Rows.Count > 0)
|
|
{
|
|
cbxKHSZDPRO.SelectedValue = dsPRO.Tables[0].Rows[0]["XZQH_FID"].ToString().Trim();
|
|
}
|
|
}
|
|
|
|
SQL.Clear();
|
|
SQL.Add(" select XZQH_XZQHID,XZQH_CITY from XZQH where XZQH_FID = :pFID ");
|
|
SQL.Add(" order by XZQH_XZQHID ");
|
|
SQL.ParamByName("pFID").Value = cbxKHSZDPRO.SelectedValue.Trim();
|
|
DataSet ds1 = dberp.OpenDataSet(SQL);
|
|
cbxKHSZDCITY.Items.Add(new ListItem("", ""));
|
|
if (ds1.Tables[0].Rows.Count > 0)
|
|
{
|
|
for (int i = 0; i < ds1.Tables[0].Rows.Count; i++)
|
|
{
|
|
if (!ds1.Tables[0].Rows[i]["XZQH_CITY"].ToString().Trim().Equals(""))
|
|
{
|
|
cbxKHSZDCITY.Items.Add(new ListItem(ds1.Tables[0].Rows[i]["XZQH_CITY"].ToString().Trim(), ds1.Tables[0].Rows[i]["XZQH_XZQHID"].ToString().Trim()));
|
|
}
|
|
}
|
|
}
|
|
SQL.Clear();
|
|
SQL.Add(" select XZQH_XZQHID,XZQH_COUNTY from XZQH where XZQH_FID = :pFID ");
|
|
SQL.Add(" order by XZQH_XZQHID ");
|
|
SQL.ParamByName("pFID").Value = cbxKHSZDCITY.SelectedValue.Trim();
|
|
DataSet dsCOUNTY = dberp.OpenDataSet(SQL);
|
|
cbxKHSZDCOUNTY.Items.Add(new ListItem("", ""));
|
|
if (dsCOUNTY.Tables[0].Rows.Count > 0)
|
|
{
|
|
for (int i = 0; i < dsCOUNTY.Tables[0].Rows.Count; i++)
|
|
{
|
|
if (!dsCOUNTY.Tables[0].Rows[i]["XZQH_COUNTY"].ToString().Trim().Equals(""))
|
|
{
|
|
cbxKHSZDCOUNTY.Items.Add(new ListItem(dsCOUNTY.Tables[0].Rows[i]["XZQH_COUNTY"].ToString().Trim(), dsCOUNTY.Tables[0].Rows[i]["XZQH_XZQHID"].ToString().Trim()));
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
protected override void OnNewRecorder()
|
|
{
|
|
base.OnNewRecorder();
|
|
cbxYFJSFS.SelectedValue = PageParam.GetRTrimString("XLXSBJDQYFZB_YFJSFS");
|
|
txtWHR.Text = tSession.UserName;
|
|
txtWHRID.Value = tSession.UserId;
|
|
datWHSJ.Text = CMISproConvert.ConvertTime(DateTime.Now);
|
|
}
|
|
|
|
protected override void OnCopyRecorder()
|
|
{
|
|
base.OnCopyRecorder();
|
|
txtWHR.Text = tSession.UserName;
|
|
txtWHRID.Value = tSession.UserId;
|
|
datWHSJ.Text = CMISproConvert.ConvertTime(DateTime.Now);
|
|
}
|
|
|
|
protected override bool DataLogicValid()
|
|
{
|
|
if (!base.DataLogicValid()) return false;
|
|
|
|
if (cbxKHSZDPRO.SelectedValue.Trim().Equals("") && cbxKHSZDCITY.SelectedValue.Trim().Equals("") && cbxKHSZDCOUNTY.SelectedValue.Trim().Equals(""))
|
|
{
|
|
ShowMessage("地区--不允许为空！");
|
|
return false;
|
|
}
|
|
|
|
if (CMISproDataBase.ExistsRecord("DBERP", string.Format("select 1 from XLXSBJDQYFZB where XLXSBJDQYFZB_XZQHID='{0}' AND XLXSBJDQYFZB_YFJSFS <> '2' ", txtXZQHID.Value)))
|
|
{
|
|
ShowMessage("所选地区已设置其他运费计算方式！");
|
|
return false;
|
|
}
|
|
|
|
return true;
|
|
}
|
|
|
|
protected override bool Master_BeforeSaveAction(object sender, EventArgs e)
|
|
{
|
|
if (!base.Master_BeforeSaveAction(sender, e)) return false;
|
|
|
|
txtWHR.Text = tSession.UserName;
|
|
txtWHRID.Value = tSession.UserId;
|
|
datWHSJ.Text = CMISproConvert.ConvertTime(System.DateTime.Now);
|
|
|
|
if (!cbxKHSZDCOUNTY.SelectedValue.Trim().Equals(""))
|
|
{
|
|
txtXZQHID.Value = cbxKHSZDCOUNTY.SelectedValue.Trim();
|
|
}
|
|
else if (!cbxKHSZDCITY.SelectedValue.Trim().Equals(""))
|
|
{
|
|
txtXZQHID.Value = cbxKHSZDCITY.SelectedValue.Trim();
|
|
}
|
|
else if (!cbxKHSZDPRO.SelectedValue.Trim().Equals(""))
|
|
{
|
|
txtXZQHID.Value = cbxKHSZDPRO.SelectedValue.Trim();
|
|
}
|
|
else
|
|
txtXZQHID.Value = "";
|
|
|
|
return true;
|
|
}
|
|
|
|
protected override bool Master_AfterSaveAction(object sender, EventArgs e)
|
|
{
|
|
txtOLDXZQHID.Value = txtXZQHID.Value.Trim();
|
|
|
|
return base.Master_AfterSaveAction(sender, e);
|
|
}
|
|
|
|
#endregion
|
|
|
|
protected void cbxKHSZDPRO_OnSelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
if (!IsPostBack)//此处解决列表页直接点编辑触发change的问题
|
|
return;
|
|
cbxKHSZDCITY.ClearItems();
|
|
if (!cbxKHSZDPRO.SelectedValue.Trim().Equals(""))
|
|
{
|
|
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
SQL.Clear();
|
|
SQL.Add(" select XZQH_XZQHID,XZQH_CITY from XZQH where XZQH_FID = :pFID ");
|
|
SQL.Add(" order by XZQH_XZQHID ");
|
|
SQL.ParamByName("pFID").Value = cbxKHSZDPRO.SelectedValue.Trim();
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
cbxKHSZDCITY.Items.Add(new ListItem("", ""));
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
if (!ds.Tables[0].Rows[i]["XZQH_CITY"].ToString().Trim().Equals(""))
|
|
{
|
|
cbxKHSZDCITY.Items.Add(new ListItem(ds.Tables[0].Rows[i]["XZQH_CITY"].ToString().Trim(), ds.Tables[0].Rows[i]["XZQH_XZQHID"].ToString().Trim()));
|
|
}
|
|
}
|
|
if (cbxKHSZDCITY.Items.Count == 2)
|
|
{
|
|
cbxKHSZDCITY.SelectedIndex = 1;
|
|
}
|
|
}
|
|
}
|
|
else
|
|
{
|
|
cbxKHSZDCITY.SelectedValue = "";
|
|
}
|
|
}
|
|
|
|
protected void cbxKHSZDCITY_OnSelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
if (!IsPostBack)
|
|
return;
|
|
cbxKHSZDCOUNTY.ClearItems();
|
|
if (!cbxKHSZDCITY.SelectedValue.Trim().Equals(""))
|
|
{
|
|
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
SQL.Clear();
|
|
SQL.Add(" select XZQH_XZQHID,XZQH_COUNTY from XZQH where XZQH_FID = :pFID ");
|
|
SQL.Add(" order by XZQH_XZQHID ");
|
|
SQL.ParamByName("pFID").Value = cbxKHSZDCITY.SelectedValue.Trim();
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
cbxKHSZDCOUNTY.Items.Add(new ListItem("", ""));
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
if (!ds.Tables[0].Rows[i]["XZQH_COUNTY"].ToString().Trim().Equals(""))
|
|
{
|
|
cbxKHSZDCOUNTY.Items.Add(new ListItem(ds.Tables[0].Rows[i]["XZQH_COUNTY"].ToString().Trim(), ds.Tables[0].Rows[i]["XZQH_XZQHID"].ToString().Trim()));
|
|
}
|
|
}
|
|
if (cbxKHSZDCOUNTY.Items.Count == 2)
|
|
{
|
|
cbxKHSZDCOUNTY.SelectedIndex = 1;
|
|
}
|
|
}
|
|
}
|
|
else
|
|
{
|
|
cbxKHSZDCOUNTY.SelectedValue = "";
|
|
}
|
|
}
|
|
|
|
#region 自定义函数
|
|
|
|
private void InitControls()
|
|
{
|
|
TComboBox.SetComboBox("DBERP", cbxKHSZDPRO, "select XZQH_XZQHID,XZQH_PROVINCE from XZQH where XZQH_FID = '86' ORDER BY XZQH_XZQHID ", false);
|
|
|
|
cbxYFJSFS.ClearItems();
|
|
cbxYFJSFS.Items.Add(new ListItem("运价运重", "1"));
|
|
cbxYFJSFS.Items.Add(new ListItem("运金比例", "2"));
|
|
cbxYFJSFS.Items.Add(new ListItem("运距运重", "3"));
|
|
cbxYFJSFS.Items.Add(new ListItem("运距运件", "4"));
|
|
}
|
|
|
|
#endregion
|
|
}
|
|
}
|