403 lines
18 KiB
C#
403 lines
18 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_MODEL.Page;
|
|
using GThinking.N_MISPRO.Data;
|
|
using GThinking.N_MISPRO;
|
|
using GThinking.N_MISPRO.Utility;
|
|
using System.Text;
|
|
using GThinking.N_CONTROL;
|
|
|
|
|
|
namespace GThinking.N_XLXSBJ
|
|
{
|
|
public partial class TJYZJDKCBList : SingleGridBase
|
|
{
|
|
TJYZJDKCB entity = new TJYZJDKCB();
|
|
TJYZJDKCB_M qryEntity = new TJYZJDKCB_M();
|
|
#region Page类事件继承
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
{
|
|
this.UMID = 100860130;
|
|
this.UMName = "调价因子加点扩充表";
|
|
this.CurMaster = Master;
|
|
this.ModuleGV = grdTJYZJDKCB;
|
|
this.CurEntity = entity;
|
|
this.CurQueryEntity = qryEntity;
|
|
this.sURLTarget = "TJYZJDKCBInfo.aspx";
|
|
this.sQueryURLTarget = "TJYZJDKCBQuery.aspx";
|
|
this.PageHeight = 600;
|
|
this.PageWidth = 750;
|
|
this.CanDeleteCheckedRows = true;
|
|
base.DataKeyNames = new string[] { "TJYZJDKCB_KCQXLXHID", "TJYZJDKCB_KCHXLXHID", "TJYZJDKCB_DYDJID", "TJYZJDKCB_KCHDYDJID", "TJYZJDKCB_XXJGID", "TJYZJDKCB_ZXJMXX", "TJYZJDKCB_ZXJMSX", "TJYZJDKCB_YZID" };
|
|
|
|
if (!IsPostBack)
|
|
{
|
|
CurQueryEntity.FieldByName("PXFS").Value = "0";
|
|
CurQueryEntity.FieldByName("KCQXHJQPP").Value = "True";
|
|
CurQueryEntity.FieldByName("KCHXHJQPP").Value = "True";
|
|
if (!string.IsNullOrEmpty(PageParam.GetRTrimString("XLXHID")))
|
|
{
|
|
CurQueryEntity.FieldByName("KCHXLXHID").Value = PageParam.GetRTrimString("XLXHID");
|
|
}
|
|
}
|
|
base.InitPage();
|
|
if (!string.IsNullOrEmpty(PageParam.GetRTrimString("YZID")))
|
|
{
|
|
txtYZID.Value = PageParam.GetRTrimString("YZID");
|
|
}
|
|
InitControls();
|
|
if (!IsPostBack)
|
|
{
|
|
Master_OnStandardQuery(null, null);
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 模板事件
|
|
protected override void Master_OnStandardQuery(object sender, EventArgs e)
|
|
{
|
|
base.InitEntityByCondition();
|
|
entity.EntityTable.QuerySelSql = GetSql();
|
|
base.Master_OnStandardQuery(sender, e);
|
|
entity.GridDataBind(grdTJYZJDKCB, tSession);
|
|
}
|
|
|
|
protected override void moduleGV_PageIndexChanging(object sender, GridViewPageEventArgs e)
|
|
{
|
|
base.InitEntityByCondition();
|
|
entity.EntityTable.QuerySelSql = GetSql();
|
|
base.moduleGV_PageIndexChanging(sender, e);
|
|
grdTJYZJDKCB.SelectedIndex = -1;
|
|
}
|
|
|
|
protected override void moduleGV_RowDataBound(object sender, GridViewRowEventArgs e)
|
|
{
|
|
if (e.Row.RowType == DataControlRowType.DataRow)
|
|
{
|
|
LinkPageParam.AddString("TJYZJDKCB_KCQXLXHID", this.grdTJYZJDKCB.DataKeys[e.Row.RowIndex]["TJYZJDKCB_KCQXLXHID"].ToString().Trim());
|
|
LinkPageParam.AddString("TJYZJDKCB_KCHXLXHID", this.grdTJYZJDKCB.DataKeys[e.Row.RowIndex]["TJYZJDKCB_KCHXLXHID"].ToString().Trim());
|
|
LinkPageParam.AddString("TJYZJDKCB_DYDJID", this.grdTJYZJDKCB.DataKeys[e.Row.RowIndex]["TJYZJDKCB_DYDJID"].ToString().Trim());
|
|
LinkPageParam.AddString("TJYZJDKCB_KCHDYDJID", this.grdTJYZJDKCB.DataKeys[e.Row.RowIndex]["TJYZJDKCB_KCHDYDJID"].ToString().Trim());
|
|
LinkPageParam.AddString("TJYZJDKCB_XXJGID", this.grdTJYZJDKCB.DataKeys[e.Row.RowIndex]["TJYZJDKCB_XXJGID"].ToString().Trim());
|
|
LinkPageParam.AddString("TJYZJDKCB_ZXJMXX", this.grdTJYZJDKCB.DataKeys[e.Row.RowIndex]["TJYZJDKCB_ZXJMXX"].ToString().Trim());
|
|
LinkPageParam.AddString("TJYZJDKCB_ZXJMSX", this.grdTJYZJDKCB.DataKeys[e.Row.RowIndex]["TJYZJDKCB_ZXJMSX"].ToString().Trim());
|
|
LinkPageParam.AddString("TJYZJDKCB_YZID", this.grdTJYZJDKCB.DataKeys[e.Row.RowIndex]["TJYZJDKCB_YZID"].ToString().Trim());
|
|
|
|
|
|
}
|
|
base.moduleGV_RowDataBound(sender, e);
|
|
}
|
|
|
|
protected override bool Master_BeforeDeleteAction(object sender, EventArgs e)
|
|
{
|
|
|
|
entity.Param.Add("TJYZJDKCB_KCQXLXHID", this.grdTJYZJDKCB.DataKeys[grdTJYZJDKCB.SelectedIndex]["TJYZJDKCB_KCQXLXHID"].ToString().Trim());
|
|
entity.Param.Add("TJYZJDKCB_KCHXLXHID", this.grdTJYZJDKCB.DataKeys[grdTJYZJDKCB.SelectedIndex]["TJYZJDKCB_KCHXLXHID"].ToString().Trim());
|
|
|
|
string sDYDJID = this.grdTJYZJDKCB.DataKeys[grdTJYZJDKCB.SelectedIndex]["TJYZJDKCB_DYDJID"].ToString().Trim();
|
|
string sDZHDYDJID = this.grdTJYZJDKCB.DataKeys[grdTJYZJDKCB.SelectedIndex]["TJYZJDKCB_KCHDYDJID"].ToString().Trim();
|
|
string sXXJGID = this.grdTJYZJDKCB.DataKeys[grdTJYZJDKCB.SelectedIndex]["TJYZJDKCB_XXJGID"].ToString().Trim();
|
|
if (sDYDJID.Trim().Equals(""))
|
|
{
|
|
sDYDJID = " ";
|
|
}
|
|
if (sDZHDYDJID.Trim().Equals(""))
|
|
{
|
|
sDZHDYDJID = " ";
|
|
}
|
|
if (sXXJGID.Trim().Equals(""))
|
|
{
|
|
sXXJGID = " ";
|
|
}
|
|
entity.Param.Add("TJYZJDKCB_DYDJID", sDYDJID);
|
|
entity.Param.Add("TJYZJDKCB_KCHDYDJID", sDZHDYDJID);
|
|
entity.Param.Add("TJYZJDKCB_XXJGID", sXXJGID);
|
|
entity.Param.Add("TJYZJDKCB_ZXJMXX", this.grdTJYZJDKCB.DataKeys[grdTJYZJDKCB.SelectedIndex]["TJYZJDKCB_ZXJMXX"].ToString().Trim());
|
|
entity.Param.Add("TJYZJDKCB_ZXJMSX", this.grdTJYZJDKCB.DataKeys[grdTJYZJDKCB.SelectedIndex]["TJYZJDKCB_ZXJMSX"].ToString().Trim());
|
|
entity.Param.Add("TJYZJDKCB_YZID", this.grdTJYZJDKCB.DataKeys[grdTJYZJDKCB.SelectedIndex]["TJYZJDKCB_YZID"].ToString().Trim());
|
|
return base.Master_BeforeDeleteAction(sender, e);
|
|
|
|
|
|
|
|
}
|
|
|
|
protected override void AfterDelete(TDatabase db, ref bool ActionIsDone)
|
|
{
|
|
base.AfterDelete(db, ref ActionIsDone);
|
|
}
|
|
|
|
protected override bool Master_AfterDeleteAction(object sender, EventArgs e)
|
|
{
|
|
if (!base.Master_AfterDeleteAction(sender, e))
|
|
{ return false; }
|
|
base.InitEntityByCondition();
|
|
entity.EntityTable.QuerySelSql = GetSql();
|
|
entity.GridDataBind(grdTJYZJDKCB, tSession);
|
|
grdTJYZJDKCB.SelectedIndex = -1;
|
|
return true;
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 自定义函数
|
|
|
|
private string GetSql()
|
|
{
|
|
if (!string.IsNullOrEmpty(txtYZID.Value.Trim()))
|
|
{
|
|
TPageParams pageparams = new TPageParams();
|
|
pageparams.AddString("YZID", txtYZID.Value.Trim());
|
|
SetNewFormParam(pageparams);
|
|
|
|
}
|
|
StringBuilder strSQL = new StringBuilder();
|
|
strSQL.AppendLine(" select TJYZJDKCB_KCQXLXHID,TJYZJDKCB_KCHXLXHID,TJYZJDKCB_YZID,TJYZJDKCB_JDZ, ");
|
|
strSQL.AppendLine(" TJYZJDKCB_ZXJMXX, TJYZJDKCB_ZXJMXX as ZXJMXX,TJYZJDKCB_ZXJMSX,TJYZJDKCB_ZXJMSX as ZXJMSX,");
|
|
strSQL.AppendLine(" TJYZJDKCB_DYDJID, TJYZJDKCB_DYDJID as DYDJID,TJYZJDKCB_KCHDYDJID,TJYZJDKCB_XXJGID,TJYZJDKCB_XXJGID as XXJGID, ");
|
|
strSQL.AppendLine(" TJYZJDKCB_WHR,TJYZJDKCB_WHRID,TJYZJDKCB_WHSJ ");
|
|
strSQL.AppendLine(" from TJYZJDKCB ");
|
|
strSQL.AppendLine(" where TJYZJDKCB_YZID=:pYZID ");
|
|
entity.Param.Add("pYZID", txtYZID.Value.Trim());
|
|
if (!CurQueryEntity.FieldByName("KCQXLXHID").Value.Equals(""))
|
|
{
|
|
if (CurQueryEntity.FieldByName("KCQXHJQPP").Value.Equals("True"))
|
|
{
|
|
strSQL.AppendLine(" and TJYZJDKCB_KCQXLXHID = :pTJYZJDKCB_KCQXLXHID ");
|
|
entity.Param.Add("pTJYZJDKCB_KCQXLXHID", CurQueryEntity.FieldByName("KCQXLXHID").Value);
|
|
}
|
|
else
|
|
{
|
|
strSQL.AppendLine(" and TJYZJDKCB_KCQXLXHID like :pTJYZJDKCB_KCQXLXHID ");
|
|
entity.Param.Add("pTJYZJDKCB_KCQXLXHID", "%" + CurQueryEntity.FieldByName("KCQXLXHID").Value + "%");
|
|
}
|
|
|
|
|
|
}
|
|
if (!CurQueryEntity.FieldByName("KCHXLXHID").Value.Equals(""))
|
|
{
|
|
if (CurQueryEntity.FieldByName("KCHXHJQPP").Value.Equals("True"))
|
|
{
|
|
strSQL.AppendLine(" and TJYZJDKCB_KCHXLXHID = :pTJYZJDKCB_KCHXLXHID ");
|
|
entity.Param.Add("pTJYZJDKCB_KCHXLXHID", CurQueryEntity.FieldByName("KCHXLXHID").Value);
|
|
}
|
|
else
|
|
{
|
|
strSQL.AppendLine(" and TJYZJDKCB_KCHXLXHID like :pTJYZJDKCB_KCHXLXHID ");
|
|
entity.Param.Add("pTJYZJDKCB_KCHXLXHID", "%" + CurQueryEntity.FieldByName("KCHXLXHID").Value + "%");
|
|
}
|
|
|
|
}
|
|
if (CurQueryEntity.FieldByName("PXFS").Value.Trim().Equals("0"))
|
|
{
|
|
strSQL.AppendLine(" order by TJYZJDKCB_KCQXLXHID ");
|
|
}
|
|
else if (CurQueryEntity.FieldByName("PXFS").Value.Trim().Equals("1"))
|
|
{
|
|
strSQL.AppendLine(" order by TJYZJDKCB_KCQXLXHID desc ");
|
|
}
|
|
else if (CurQueryEntity.FieldByName("PXFS").Value.Trim().Equals("3"))
|
|
{
|
|
strSQL.AppendLine(" order by TJYZJDKCB_KCHXLXHID ");
|
|
}
|
|
else if (CurQueryEntity.FieldByName("PXFS").Value.Trim().Equals("4"))
|
|
{
|
|
strSQL.AppendLine(" order by TJYZJDKCB_KCHXLXHID desc ");
|
|
}
|
|
else
|
|
{
|
|
strSQL.AppendLine(" order by TJYZJDKCB_KCQXLXHID,TJYZJDKCB_KCHXLXHID ");
|
|
}
|
|
return strSQL.ToString();
|
|
}
|
|
|
|
private void InitControls()
|
|
{
|
|
if (!string.IsNullOrEmpty(PageParam.GetRTrimString("XLXHID")))
|
|
{
|
|
btnDR.Visible = false;
|
|
}
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 控件事件
|
|
|
|
protected void btnRefresh_Click(object sender, EventArgs e)
|
|
{
|
|
moduleGV_PageIndexChanging(null, null);
|
|
}
|
|
|
|
protected void btnRefreshPLTZ_Click(object sender, EventArgs e)
|
|
{
|
|
base.InitEntityByCondition();
|
|
string[] RowsArry;
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
SQL.Clear();
|
|
SQL.Add(" update TJYZJDKCB set TJYZJDKCB_JDZ=:pJDZ ");
|
|
SQL.Add(" where TJYZJDKCB_YZID=:pYZID ");
|
|
SQL.ParamByName("pYZID").Value = txtYZID.Value.Trim();
|
|
SQL.ParamByName("pJDZ").Value =CMISproConvert.StrToFloat(txtPLTZJDZ.Value.Trim());
|
|
if (!CurQueryEntity.FieldByName("KCQXLXHID").Value.Equals(""))
|
|
{
|
|
if (CurQueryEntity.FieldByName("KCQXHJQPP").Value.Equals("True"))
|
|
{
|
|
SQL.Add(" and TJYZJDKCB_KCQXLXHID = :pTJYZJDKCB_KCQXLXHID ");
|
|
SQL.ParamByName("pTJYZJDKCB_KCQXLXHID").Value = CurQueryEntity.FieldByName("KCQXLXHID").Value;
|
|
}
|
|
else
|
|
{
|
|
SQL.Add(" and TJYZJDKCB_KCQXLXHID like :pTJYZJDKCB_KCQXLXHID ");
|
|
SQL.ParamByName("pTJYZJDKCB_KCQXLXHID").Value = "%" + CurQueryEntity.FieldByName("KCQXLXHID").Value + "%";
|
|
}
|
|
|
|
|
|
}
|
|
if (!CurQueryEntity.FieldByName("KCHXLXHID").Value.Equals(""))
|
|
{
|
|
if (CurQueryEntity.FieldByName("KCHXHJQPP").Value.Equals("True"))
|
|
{
|
|
SQL.Add(" and TJYZJDKCB_KCHXLXHID = :pTJYZJDKCB_KCHXLXHID ");
|
|
SQL.ParamByName("pTJYZJDKCB_KCHXLXHID").Value = CurQueryEntity.FieldByName("KCHXLXHID").Value;
|
|
}
|
|
else
|
|
{
|
|
SQL.Add(" and TJYZJDKCB_KCHXLXHID like :pTJYZJDKCB_KCHXLXHID ");
|
|
SQL.ParamByName("pTJYZJDKCB_KCHXLXHID").Value = "%" + CurQueryEntity.FieldByName("KCHXLXHID").Value + "%";
|
|
}
|
|
|
|
}
|
|
if (grdTJYZJDKCB.CheckBox && !String.IsNullOrEmpty(grdTJYZJDKCB.CheckedRowIndexs))
|
|
{
|
|
SQL.Add("and (1<>1 ");
|
|
RowsArry = grdTJYZJDKCB.CheckedRowIndexs.Split(new char[] { ',' });
|
|
for (int i = 0; i < RowsArry.Length; i++)
|
|
{
|
|
SQL.Add(string.Format(" or (TJYZJDKCB_KCQXLXHID=isnull('{0}',' ') and TJYZJDKCB_KCHXLXHID=isnull('{1}',' ') and TJYZJDKCB_XXJGID=isnull('{2}',' ') and TJYZJDKCB_ZXJMXX=isnull({3},0) and TJYZJDKCB_ZXJMSX=isnull({4},0) and TJYZJDKCB_DYDJID=isnull('{5}',' ') and TJYZJDKCB_KCHDYDJID=isnull('{6}',' ') and TJYZJDKCB_YZID='{7}') ",
|
|
grdTJYZJDKCB.DataKeys[CMISproConvert.StrToInt(RowsArry[i])]["TJYZJDKCB_KCQXLXHID"].ToString().Trim(), grdTJYZJDKCB.DataKeys[CMISproConvert.StrToInt(RowsArry[i])]["TJYZJDKCB_KCHXLXHID"].ToString().Trim(),
|
|
grdTJYZJDKCB.DataKeys[CMISproConvert.StrToInt(RowsArry[i])]["TJYZJDKCB_XXJGID"].ToString().Trim(),grdTJYZJDKCB.DataKeys[CMISproConvert.StrToInt(RowsArry[i])]["TJYZJDKCB_ZXJMXX"].ToString().Trim(),
|
|
grdTJYZJDKCB.DataKeys[CMISproConvert.StrToInt(RowsArry[i])]["TJYZJDKCB_ZXJMSX"].ToString().Trim(),grdTJYZJDKCB.DataKeys[CMISproConvert.StrToInt(RowsArry[i])]["TJYZJDKCB_DYDJID"].ToString().Trim(),
|
|
grdTJYZJDKCB.DataKeys[CMISproConvert.StrToInt(RowsArry[i])]["TJYZJDKCB_KCHDYDJID"].ToString().Trim(),grdTJYZJDKCB.DataKeys[CMISproConvert.StrToInt(RowsArry[i])]["TJYZJDKCB_YZID"].ToString().Trim()));
|
|
|
|
}
|
|
SQL.Add(" ) ");
|
|
|
|
}
|
|
dberp.ExecSQL(SQL);
|
|
moduleGV_PageIndexChanging(null, null);
|
|
}
|
|
|
|
|
|
protected void btnDR_Click(object sender, EventArgs e)
|
|
{
|
|
TPageParams pageParams = new TPageParams();
|
|
pageParams.UrlPath = "TJYZJDKCBDRInfo.aspx";
|
|
pageParams.Title = "导入Excel文件";
|
|
pageParams.AddString("YZID", txtYZID.Value.Trim());
|
|
pageParams.AddString("btnRefreshCID", btnRefresh.ClientID);
|
|
OpenDialog(pageParams);
|
|
}
|
|
|
|
protected void btnPLTZ_Click(object sender, EventArgs e)
|
|
{
|
|
TPageParams pageParams = new TPageParams();
|
|
pageParams.UrlPath = "TJYZJDKCBPLSZInfo.aspx";
|
|
pageParams.Title = "批量调整加点值";
|
|
pageParams.AddString("txtPLTZJDZ", txtPLTZJDZ.ClientID);
|
|
if (grdTJYZJDKCB.CheckBox && !String.IsNullOrEmpty(grdTJYZJDKCB.CheckedRowIndexs))
|
|
{
|
|
pageParams.AddString("PLSZAll", "N");
|
|
}
|
|
else
|
|
pageParams.AddString("PLSZAll", "Y");
|
|
pageParams.AddString("btnRefreshCID", btnRefreshPLTZ.ClientID);
|
|
OpenDialog(pageParams);
|
|
}
|
|
|
|
protected void btnTBZDZB_Click(object sender, EventArgs e)
|
|
{
|
|
string sWarning = string.Format("将删除当前因子扩充表记录，并同步报价单型号加点对照表记录，是否确认？");
|
|
Confirm.Register("IsQD", sWarning);
|
|
Confirm.ShowBtnText = TConfirm.cBtnText.Yes_No;
|
|
if (Confirm.GetValue("IsQD").Trim().Equals(""))
|
|
{
|
|
Confirm.Ask("IsQD");
|
|
return;
|
|
}
|
|
else if (Confirm.GetValue("IsQD").Trim().Equals("N"))
|
|
{
|
|
//表示进行了提示并选择了取消，直接返回或其他处理
|
|
Confirm.Clear();
|
|
return;
|
|
|
|
}
|
|
else if (Confirm.GetValue("IsQD").Trim().Equals("Y"))
|
|
{
|
|
//表示进行了提示并选择了确认
|
|
Confirm.Clear();
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
dberp.BeginTrans();
|
|
try
|
|
{
|
|
//删除当前因子所有扩充记录
|
|
SQL.Clear();
|
|
SQL.Add(" delete from TJYZJDKCB where TJYZJDKCB_YZID=:pYZID ");
|
|
SQL.ParamByName("pYZID").Value = txtYZID.Value.Trim();
|
|
dberp.ExecSQL(SQL);
|
|
|
|
//按型号加点对照表扩充
|
|
SQL.Clear();
|
|
SQL.Add(@"insert into TJYZJDKCB
|
|
(TJYZJDKCB_KCQXLXHID,
|
|
TJYZJDKCB_KCHXLXHID,
|
|
TJYZJDKCB_XXJGID,
|
|
TJYZJDKCB_ZXJMXX,
|
|
TJYZJDKCB_ZXJMSX,
|
|
TJYZJDKCB_DYDJID,
|
|
TJYZJDKCB_KCHDYDJID,
|
|
TJYZJDKCB_YZID,
|
|
TJYZJDKCB_JDZ,
|
|
TJYZJDKCB_WHR,
|
|
TJYZJDKCB_WHRID,
|
|
TJYZJDKCB_WHSJ
|
|
)
|
|
select XLXSJGBXHDZB_JGBXLXHID,XLXSJGBXHDZB_BJDXLXHID,XLXSJGBXHDZB_XXJGID,XLXSJGBXHDZB_ZXJMXX,XLXSJGBXHDZB_ZXJMSX,XLXSJGBXHDZB_DYDJID,XLXSJGBXHDZB_DZHDYDJID,
|
|
:pYZID,XLXSJGBXHDZB_YZZ,:pWHR,:pWHRID,:pWHSJ
|
|
from XLXSJGBXHDZB
|
|
where 1=1 ");
|
|
SQL.ParamByName("pYZID").Value = txtYZID.Value.Trim();
|
|
SQL.ParamByName("pWHR").Value = tSession.UserName;
|
|
SQL.ParamByName("pWHRID").Value = tSession.UserId;
|
|
SQL.ParamByName("pWHSJ").Value = DateTime.Now;
|
|
dberp.ExecSQL(SQL);
|
|
|
|
dberp.CommitTrans();
|
|
ShowMessage("同步成功！");
|
|
|
|
|
|
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
dberp.RollbackTrans();
|
|
ShowMessage(ex.Message);
|
|
}
|
|
|
|
}
|
|
btnRefresh_Click(null, null);
|
|
}
|
|
|
|
|
|
#endregion
|
|
}
|
|
}
|