301 lines
12 KiB
C#
301 lines
12 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_MODEL.Page;
|
|
using GThinking.N_CONTROL;
|
|
using GThinking.N_MISPRO.Data;
|
|
using GThinking.N_MISPRO.Utility;
|
|
using GThinking.N_PUBLIC;
|
|
using GThinking.N_MODEL.UserControls;
|
|
using System.Text;
|
|
using GThinking.N_WORKFLOW;
|
|
using GThinking.N_PUBLIC2;
|
|
|
|
namespace GThinking.N_XLJC
|
|
{
|
|
public partial class XLXLXHList : SingleGridBase
|
|
{
|
|
XLXHB entity = new XLXHB();
|
|
XLXHB_M queryentity = new XLXHB_M();
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
{
|
|
this.UMID = 101421000;
|
|
this.UMName = "线缆型号";
|
|
this.CurMaster = Master;
|
|
this.ModuleGV = grdContentGrid;
|
|
this.CurEntity = entity;
|
|
this.CurQueryEntity = queryentity;
|
|
this.sURLTarget = "XLXLXHInfo.aspx";
|
|
this.sQueryURLTarget = "XLXLXHQuery.aspx";
|
|
this.PageHeight = 700;
|
|
this.PageWidth = 500;
|
|
this.CanDeleteCheckedRows = true;
|
|
base.DataKeyNames = new string[] { "XLXHB_CPYT", "XLXHB_XLTXID", "XLXHB_XLXHID" };
|
|
|
|
base.InitPage();
|
|
if (!IsPostBack)
|
|
{
|
|
Master_OnStandardQuery(null, null);
|
|
}
|
|
}
|
|
|
|
#region 模板继承事件
|
|
|
|
protected override void Master_OnStandardQuery(object sender, EventArgs e)
|
|
{
|
|
base.InitEntityByCondition();
|
|
entity.EntityTable.QuerySelSql = GetQuerySQL();
|
|
base.Master_OnStandardQuery(sender, e);
|
|
entity.GridDataBind(grdContentGrid, tSession);
|
|
}
|
|
|
|
protected override void moduleGV_PageIndexChanging(object sender, GridViewPageEventArgs e)
|
|
{
|
|
base.InitEntityByCondition();
|
|
entity.EntityTable.QuerySelSql = GetQuerySQL();
|
|
grdContentGrid.SelectedIndex = -1;
|
|
base.moduleGV_PageIndexChanging(sender, e);
|
|
}
|
|
|
|
protected override bool Master_BeforeDeleteAction(object sender, EventArgs e)
|
|
{
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
if (grdContentGrid.CheckBox && !String.IsNullOrEmpty(grdContentGrid.CheckedRowIndexs))
|
|
{
|
|
string[] RowsArry = grdContentGrid.CheckedRowIndexs.Split(new char[] { ',' });
|
|
//勾选的型号
|
|
string sXLXHIDList = "";
|
|
for (int i = 0; i < RowsArry.Length; i++)
|
|
{
|
|
sXLXHIDList = sXLXHIDList + grdContentGrid.DataKeys[CMISproConvert.StrToInt(RowsArry[i].ToString())]["XLXHB_XLXHID"].ToString().Trim() + ",";
|
|
}
|
|
sXLXHIDList = sXLXHIDList.Trim().TrimEnd(',');
|
|
|
|
dberp.ExecSQL(string.Format("delete from XLXHB where 1 =1 and " + GetWhereEqual("XLXHB_XLXHID", sXLXHIDList)));
|
|
dberp.ExecSQL(string.Format("delete from XLXHDYDJ where 1 =1 and " + GetWhereEqual("XLXHDYDJ_XLXHID", sXLXHIDList)));
|
|
return base.Master_BeforeDeleteAction(sender, e);
|
|
}
|
|
else
|
|
{
|
|
string sXLXHID = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXHB_XLXHID"].ToString().Trim();
|
|
|
|
entity.Param.Add("XLXHB_XLXHID", sXLXHID);
|
|
int k = dberp.ExecSQL(string.Format("delete from XLXHDYDJ where 1 =1 and XLXHDYDJ_XLXHID= '{0}'", sXLXHID));
|
|
return base.Master_BeforeDeleteAction(sender, e);
|
|
}
|
|
}
|
|
|
|
protected override bool Master_AfterDeleteAction(object sender, EventArgs e)
|
|
{
|
|
if (!base.Master_AfterDeleteAction(sender, e)) { return false; }
|
|
base.InitEntityByCondition();
|
|
entity.EntityTable.QuerySelSql = GetQuerySQL();
|
|
entity.GridDataBind(grdContentGrid, tSession);
|
|
grdContentGrid.SelectedIndex = -1;
|
|
return true;
|
|
}
|
|
|
|
protected override void moduleGV_RowDataBound(object sender, GridViewRowEventArgs e)
|
|
{
|
|
if (e.Row.RowType == DataControlRowType.DataRow)
|
|
{
|
|
int indexCPYT = grdContentGrid.Columns.IndexOf(grdContentGrid.FindColumnByFieldName("XLXHB_CPYT")) + 1;
|
|
|
|
string sCPYT = e.Row.Cells[indexCPYT].Text.ToString().Trim();
|
|
|
|
if (!sCPYT.Equals(""))
|
|
{
|
|
e.Row.Cells[indexCPYT].Text = GetCPYTMC(sCPYT);
|
|
}
|
|
LinkPageParam.AddString("XLXHB_XLXHID", grdContentGrid.DataKeys[e.Row.RowIndex]["XLXHB_XLXHID"].ToString().Trim());
|
|
}
|
|
base.moduleGV_RowDataBound(sender, e);
|
|
}
|
|
|
|
|
|
|
|
#endregion
|
|
|
|
#region 自定义事件
|
|
|
|
private string GetQuerySQL()
|
|
{
|
|
StringBuilder sSQL = new StringBuilder();
|
|
sSQL.AppendLine("select XLXHB_XLJBXHID,XLXHB_XLXHID,XLXHB_XLXHBH,XLXHB_XLXHMC, XLXHB_XLTXID,XLXHB_CPYT,XLXHB_XLGGJDGZ,XLXHB_QYRQ, ");
|
|
sSQL.AppendLine("XLXHB_TYBZ,XLXHB_TYRQ,XLXHB_WHR,XLXHB_WHSJ");
|
|
sSQL.AppendLine(" from XLXHB ");
|
|
sSQL.AppendLine(" where 1=1 ");
|
|
|
|
if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("CPYT").Value.Trim()))
|
|
{
|
|
sSQL.AppendLine(" and XLXHB_CPYT = :pCPYT ");
|
|
entity.Param.Add("pCPYT", CurQueryEntity.FieldByName("CPYT").Value.Trim());
|
|
}
|
|
|
|
if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("JBXH").Value.Trim()))
|
|
{
|
|
sSQL.AppendLine(" and XLXHB_XLJBXHID = :pJBXH ");
|
|
entity.Param.Add("pJBXH", CurQueryEntity.FieldByName("JBXH").Value.Trim());
|
|
}
|
|
|
|
if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("XHBM").Value.Trim()))
|
|
{
|
|
sSQL.AppendLine(" and XLXHB_XLXHID = :pXHBM ");
|
|
entity.Param.Add("pXHBM", CurQueryEntity.FieldByName("XHBM").Value.Trim());
|
|
}
|
|
|
|
if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("XHMC").Value.Trim()))
|
|
{
|
|
sSQL.AppendLine(" and XLXHB_XLXHMC like :pXHMC ");
|
|
entity.Param.Add("pXHMC", "%" + CurQueryEntity.FieldByName("XHMC").Value.Trim() + "%");
|
|
}
|
|
|
|
sSQL.AppendLine("order by XLXHB_XLJBXHID,XLXHB_XLXHID");
|
|
return sSQL.ToString();
|
|
}
|
|
|
|
public string GetWhereEqual(string p_FieldName, string p_Values)
|
|
{
|
|
p_Values = p_Values.Replace(",", "' or " + p_FieldName + "='");
|
|
p_Values = p_FieldName + "='" + p_Values + "'";
|
|
p_Values = "(" + p_Values + ")";
|
|
return p_Values;
|
|
|
|
}
|
|
|
|
|
|
#endregion
|
|
|
|
#region 控件事件
|
|
|
|
protected void btnDRQS_Click(object sender, EventArgs e)
|
|
{
|
|
TPageParams pageParams = new TPageParams();
|
|
pageParams.CallAction = TPageCallAction.pcaEdit;
|
|
pageParams.UrlPath = "../components/N_XLJC/XLXLXH_DRList.aspx";
|
|
pageParams.AddString("CZFS", "DR");
|
|
OpenModuleDialog(101421000, pageParams, btnRefresh1.ClientID.ToString());
|
|
}
|
|
|
|
protected void btnRefresh1_Click(object sender, EventArgs e)
|
|
{
|
|
Master_OnStandardQuery(null, null);
|
|
FormAreaUpdate();
|
|
}
|
|
|
|
|
|
protected void btnDRQS_MenuItemClick(object sender, string ItemIndex)
|
|
{
|
|
TPageParams pageParams = new TPageParams();
|
|
pageParams.CallAction = TPageCallAction.pcaEdit;
|
|
pageParams.UrlPath = "../components/N_XLJC/XLXLXH_DRList.aspx";
|
|
pageParams.AddString("CZFS", "SC");
|
|
OpenModuleDialog(101421000, pageParams, btnRefresh1.ClientID.ToString());
|
|
}
|
|
|
|
protected void btnDYDJ_Click(object sender, EventArgs e)
|
|
{
|
|
if (grdContentGrid.SelectedIndex < 0)
|
|
{
|
|
ShowMessage("请选择处理记录！");
|
|
return;
|
|
}
|
|
|
|
if (!CMISproDataBase.ExistsRecord("DBERP", string.Format("select 1 from XLXHB where XLXHB_XLXHID='{0}'", grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXHB_XLXHID"].ToString().Trim())))
|
|
{
|
|
ShowMessage("当前记录已不存在，请刷新后重试！");
|
|
return;
|
|
}
|
|
TPageParams pageParams = new TPageParams();
|
|
pageParams.CallAction = TPageCallAction.pcaEdit;
|
|
pageParams.UrlPath = "../components/N_XLJC/XLXLXH_DYDJ.aspx";
|
|
pageParams.AddString("DYDJID", "");
|
|
pageParams.AddString("XLXHID", grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXHB_XLXHID"].ToString().Trim());
|
|
OpenModuleDialog(101421000, pageParams);
|
|
}
|
|
|
|
protected void btnDYDJ_MenuItemClick(object sender, string Value)
|
|
{
|
|
TPageParams pageParams = new TPageParams();
|
|
pageParams.CallAction = TPageCallAction.pcaEdit;
|
|
pageParams.UrlPath = "../components/N_XLJC/XLXLXH_DYDJ.aspx";
|
|
pageParams.AddString("DYDJID", Value);
|
|
pageParams.AddString("XLXHID", grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXHB_XLXHID"].ToString().Trim());
|
|
OpenModuleDialog(101421000, pageParams);
|
|
}
|
|
|
|
protected void btnDYDJ_DropDown(object sender, EventArgs e)
|
|
{
|
|
if (grdContentGrid.SelectedIndex < 0)
|
|
{
|
|
ShowMessage("请选择处理记录！");
|
|
return;
|
|
}
|
|
|
|
if (!CMISproDataBase.ExistsRecord("DBERP", string.Format("select 1 from XLXHB where XLXHB_XLXHID='{0}'", grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXHB_XLXHID"].ToString().Trim())))
|
|
{
|
|
ShowMessage("当前记录已不存在，请刷新后重试！");
|
|
return;
|
|
}
|
|
|
|
btnDYDJ.Nodes.Clear();
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL sSql = new TSQL(dberp);
|
|
sSql.Add("select XLXHDYDJ_ACDC,XLXHDYDJ_DYDJID ");
|
|
sSql.Add("from XLXHDYDJ ");
|
|
sSql.Add("left join XLDYDJB on XLDYDJB_DYDJID=XLXHDYDJ_DYDJID ");
|
|
sSql.Add("where XLXHDYDJ_XLXHID=:pXLXHID ");
|
|
sSql.Add("order by XLDYDJB_DYJLDW desc,XLDYDJB_XXLXDY,XLDYDJB_XXXXDY ");
|
|
sSql.ParamByName("pXLXHID").Value = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXHB_XLXHID"].ToString().Trim();
|
|
DataSet ds = dberp.OpenDataSet(sSql);
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
btnDYDJ.Nodes.Add(new gtTreeNode(ds.Tables[0].Rows[i]["XLXHDYDJ_DYDJID"].ToString().Trim(), ds.Tables[0].Rows[i]["XLXHDYDJ_ACDC"].ToString().Trim() + "|" + ds.Tables[0].Rows[i]["XLXHDYDJ_DYDJID"].ToString().Trim()));
|
|
}
|
|
MenuAreaUpdate();
|
|
}
|
|
|
|
protected void btnCLQDDR_Click(object sender, EventArgs e)
|
|
{
|
|
XLJBXHService.INSERTXLJBXHB("ZXLXSBJCLQDDR");
|
|
ShowMessage("导入完成！");
|
|
}
|
|
|
|
private string GetCPYTMC(string sCPYT)
|
|
{
|
|
string sRet = "";
|
|
if (sCPYT.Equals("NNNN"))
|
|
{
|
|
sRet = "NNNN|非线缆产品";
|
|
}
|
|
else
|
|
{
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
SQL.Clear();
|
|
SQL.Add("select XLCPYT_CPYT,XLCPYT_CPYTMC from XLCPYT where XLCPYT_CPYT = :pCPYT ");
|
|
SQL.ParamByName("pCPYT").Value = sCPYT;
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
sRet = ds.Tables[0].Rows[0][0].ToString().Trim() + "|" + ds.Tables[0].Rows[0][1].ToString().Trim();
|
|
}
|
|
}
|
|
return sRet;
|
|
|
|
}
|
|
#endregion
|
|
}
|
|
}
|
|
|
|
|