326 lines
14 KiB
C#
326 lines
14 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.Utility;
|
|
using System.Text;
|
|
using GThinking.N_CONTROL;
|
|
using GThinking.N_MISPRO;
|
|
using GThinking.N_MISPRO.TableCache;
|
|
|
|
namespace GThinking.N_XLJC
|
|
{
|
|
public partial class CPML_PLDRList : SingleGridBase
|
|
{
|
|
|
|
CPML_PLDR entity = new CPML_PLDR();
|
|
CPML_PLDR_M queryEntity = new CPML_PLDR_M();
|
|
|
|
#region 页面初始化
|
|
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
{
|
|
this.UMID = 101421007;
|
|
this.UMName = "线缆产品目录";
|
|
this.CurMaster = Master;
|
|
this.ModuleGV = ContentGrid;
|
|
this.CurEntity = entity;
|
|
this.CurQueryEntity = queryEntity;
|
|
sQueryURLTarget = "CPML_PLDRQuery.aspx";
|
|
this.PageHeight = 400;
|
|
this.PageWidth = 500;
|
|
base.DataKeyNames = new string[] { "XLXSCLQD_XLXHID", "XLXSCLQD_DYDJID" };
|
|
|
|
this.Master.EnableNewBtn = false;
|
|
this.Master.EnableCopyBtn = false;
|
|
this.Master.EnableEditBtn = false;
|
|
this.Master.EnableDeleteBtn = false;
|
|
this.Master.EnableViewBtn = false;
|
|
//this.Master.EnablePrintBtn = false;
|
|
|
|
base.InitPage();
|
|
|
|
this.ModuleGV.OnClientDblClick = "return false;";
|
|
|
|
if (!IsPostBack)
|
|
{
|
|
Master_OnStandardQuery(null, null);
|
|
}
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 模板继承事件
|
|
|
|
protected override void Master_OnStandardQuery(object sender, EventArgs e)
|
|
{
|
|
base.InitEntityByCondition();
|
|
entity.EntityTable.QuerySelSql = GetQuerySql();
|
|
base.Master_OnStandardQuery(sender, e);
|
|
entity.GridDataBind(ContentGrid, tSession);
|
|
}
|
|
|
|
protected override void moduleGV_RowDataBound(object sender, GridViewRowEventArgs e)
|
|
{
|
|
if (e.Row.RowType == DataControlRowType.DataRow)
|
|
{
|
|
}
|
|
base.moduleGV_RowDataBound(sender, e);
|
|
}
|
|
|
|
protected override void moduleGV_PageIndexChanging(object sender, GridViewPageEventArgs e)
|
|
{
|
|
base.InitEntityByCondition();
|
|
entity.EntityTable.QuerySelSql = GetQuerySql();
|
|
ContentGrid.SelectedIndex = -1;
|
|
base.moduleGV_PageIndexChanging(sender, e);
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 私有函数
|
|
|
|
private string GetQuerySql()
|
|
{
|
|
string sSQL = "select distinct XLXSCLQD_XLXHID, XLXSCLQD_DYDJID from XLXSCLQD ";
|
|
sSQL += " left join XLXHB on XLXHB_XLXHID = XLXSCLQD_XLXHID ";
|
|
sSQL += " where 1=1 and XLXSCLQD_WPID ='ZZZZ' and isnull(XLXHB_TYBZ,'N') <> 'Y' ";
|
|
|
|
if (PageParam.GetRTrimString("XHMLLB") == "TJ")
|
|
{
|
|
sSQL += " and not exists (select 1 from XLXSBJTJXHML where XLXSBJTJXHML_XLXHID=XLXSCLQD_XLXHID and XLXSBJTJXHML_DYDJID=XLXSCLQD_DYDJID)";
|
|
sSQL += " and not exists (select 1 from XLXSBJTJXHML where XLXSBJTJXHML_XLXHID=XLXSCLQD_XLXHID and XLXSBJTJXHML_DYDJID=' ')";
|
|
}
|
|
else if (PageParam.GetRTrimString("XHMLLB") == "BJ")
|
|
{
|
|
sSQL += " and not exists (select 1 from XLXSBJXHML where XLXSBJXHML_XLXHID=XLXSCLQD_XLXHID and XLXSBJXHML_DYDJID=XLXSCLQD_DYDJID)";
|
|
sSQL += " and not exists (select 1 from XLXSBJXHML where XLXSBJXHML_XLXHID=XLXSCLQD_XLXHID and XLXSBJXHML_DYDJID=' ')";
|
|
}
|
|
|
|
//型号模糊
|
|
if (!CurQueryEntity.FieldByName("XLXHIDJQPP").Value.ToString().Trim().ToUpper().Equals("TRUE"))
|
|
{
|
|
if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("XLXHID").Value.Trim()))
|
|
{
|
|
sSQL += "\r\n and XLXSCLQD_XLXHID like :pXLXHID ";
|
|
entity.Param.Add("pXLXHID", "%" + CurQueryEntity.FieldByName("XLXHID").Value.Trim() + "%");
|
|
}
|
|
}
|
|
else
|
|
{
|
|
if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("XLXHID").Value.Trim()))
|
|
{
|
|
sSQL += "\r\n and XLXSCLQD_XLXHID = :pXLXHID ";
|
|
entity.Param.Add("pXLXHID", CurQueryEntity.FieldByName("XLXHID").Value.Trim());
|
|
}
|
|
}
|
|
if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("DYDJ").Value.Trim()))
|
|
{
|
|
sSQL += "\r\n and XLXSCLQD_DYDJID = :pDYDJ ";
|
|
entity.Param.Add("pDYDJ", CurQueryEntity.FieldByName("DYDJ").Value.Trim());
|
|
}
|
|
sSQL += " order by XLXSCLQD_XLXHID,XLXSCLQD_DYDJID";
|
|
|
|
return sSQL;
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 控件事件
|
|
|
|
protected void btnQR_Click(object sender, EventArgs e)
|
|
{
|
|
if (string.IsNullOrEmpty(ContentGrid.CheckedRowIndexs))
|
|
{
|
|
ShowMessage("请勾选要导入的记录！");
|
|
return;
|
|
}
|
|
string[] sRowIndexs = ContentGrid.CheckedRowIndexs.Split(',');
|
|
if (!string.IsNullOrEmpty(PageParam.GetRTrimString("CPMLID")))
|
|
{
|
|
int maxXH = CMISproDataBase.GetMaxXH("DBERP", "XLXSBJXHML", "XLXSBJXHML_ZSXH", " XLXSBJXHML_CPMLID='" + PageParam.GetRTrimString("CPMLID")+"'" );
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL sSQL = new TSQL(dberp);
|
|
try
|
|
{
|
|
dberp.BeginTrans();
|
|
for (int i = 0; i < sRowIndexs.Length; i++)
|
|
{
|
|
string sCPMLID = PageParam.GetRTrimString("CPMLID");
|
|
string sXLXHID = ContentGrid.DataKeys[int.Parse(sRowIndexs[i])]["XLXSCLQD_XLXHID"].ToString().Trim();
|
|
string sDYDJID=ContentGrid.DataKeys[int.Parse(sRowIndexs[i])]["XLXSCLQD_DYDJID"].ToString().Trim();
|
|
sSQL.Clear();
|
|
if (PageParam.GetRTrimString("XHMLLB") == "BJ")
|
|
{
|
|
//批量插入XLXSBJXHML
|
|
sSQL.Add("insert into XLXSBJXHML( ");
|
|
sSQL.Add("XLXSBJXHML_CPMLID,XLXSBJXHML_XLXHID,XLXSBJXHML_DYDJID, ");
|
|
sSQL.Add("XLXSBJXHML_WHR,XLXSBJXHML_WHRID,XLXSBJXHML_WHSJ,XLXSBJXHML_ZSXH) ");
|
|
|
|
}
|
|
else if (PageParam.GetRTrimString("XHMLLB") == "TJ")
|
|
{
|
|
//批量插入XLXSBJTJXHML
|
|
sSQL.Add("insert into XLXSBJTJXHML( ");
|
|
sSQL.Add("XLXSBJTJXHML_CPMLID,XLXSBJTJXHML_XLXHID,XLXSBJTJXHML_DYDJID, ");
|
|
sSQL.Add("XLXSBJTJXHML_WHR,XLXSBJTJXHML_WHRID,XLXSBJTJXHML_WHSJ) ");
|
|
}
|
|
sSQL.Add("select :pCPMLID,:pXLXHID,:pDYDJID,");
|
|
sSQL.Add(":pWHR,:pWHRID,:pWHSJ ");
|
|
if (PageParam.GetRTrimString("XHMLLB") == "BJ")
|
|
{
|
|
sSQL.Add(" ,:pXH ");
|
|
sSQL.ParamByName("pXH").Value = ++maxXH;
|
|
}
|
|
|
|
sSQL.ParamByName("pCPMLID").Value = sCPMLID;
|
|
sSQL.ParamByName("pXLXHID").Value = sXLXHID;
|
|
sSQL.ParamByName("pDYDJID").Value = sDYDJID;
|
|
sSQL.ParamByName("pWHRID").Value = tSession.UserId;
|
|
sSQL.ParamByName("pWHR").Value = tSession.UserName;
|
|
sSQL.ParamByName("pWHSJ").Value = DateTime.Now;
|
|
dberp.ExecSQL(sSQL);
|
|
|
|
}
|
|
|
|
dberp.CommitTrans();
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
ShowMessage(ex.Message);
|
|
dberp.RollbackTrans();
|
|
return;
|
|
}
|
|
ShowMessage("导入完成！");
|
|
}
|
|
moduleGV_PageIndexChanging(null, null);
|
|
}
|
|
|
|
protected void btnALL_Click(object sender, EventArgs e)
|
|
{
|
|
Confirm.Register("IsQD", "当前查询记录即将进行全部导入，是否继续？");
|
|
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();
|
|
}
|
|
|
|
if (!string.IsNullOrEmpty(PageParam.GetRTrimString("CPMLID")))
|
|
{
|
|
base.InitEntityByCondition();
|
|
int maxXH = CMISproDataBase.GetMaxXH("DBERP", "XLXSBJXHML", "XLXSBJXHML_ZSXH", " XLXSBJXHML_CPMLID='" + PageParam.GetRTrimString("CPMLID") + "'");
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL sSQL = new TSQL(dberp);
|
|
try
|
|
{
|
|
dberp.BeginTrans();
|
|
//查询结果全部插入
|
|
sSQL.Clear();
|
|
if (PageParam.GetRTrimString("XHMLLB") == "BJ")
|
|
{
|
|
//批量插入XLXSBJXHML
|
|
sSQL.Add("insert into XLXSBJXHML( ");
|
|
sSQL.Add("XLXSBJXHML_CPMLID,XLXSBJXHML_XLXHID,XLXSBJXHML_DYDJID, ");
|
|
sSQL.Add("XLXSBJXHML_WHR,XLXSBJXHML_WHRID,XLXSBJXHML_WHSJ,XLXSBJXHML_ZSXH) ");
|
|
|
|
}
|
|
else if (PageParam.GetRTrimString("XHMLLB") == "TJ")
|
|
{
|
|
//批量插入XLXSBJTJXHML
|
|
sSQL.Add("insert into XLXSBJTJXHML( ");
|
|
sSQL.Add("XLXSBJTJXHML_CPMLID,XLXSBJTJXHML_XLXHID,XLXSBJTJXHML_DYDJID, ");
|
|
sSQL.Add("XLXSBJTJXHML_WHR,XLXSBJTJXHML_WHRID,XLXSBJTJXHML_WHSJ) ");
|
|
}
|
|
if (PageParam.GetRTrimString("XHMLLB") == "BJ")
|
|
{
|
|
sSQL.Add(" select CPMLID,XLXHID,DYDJID,WHR,WHRID,WHSJ,:pMaXH+ row_number() over(order by XLXHID,DYDJID) from ( ");
|
|
sSQL.ParamByName("pMaXH").Value = maxXH;
|
|
}
|
|
sSQL.Add("select distinct :pCPMLID as CPMLID,XLXSCLQD_XLXHID as XLXHID,XLXSCLQD_DYDJID as DYDJID,");
|
|
sSQL.Add(":pWHR as WHR,:pWHRID as WHRID,:pWHSJ as WHSJ");
|
|
sSQL.Add("from XLXSCLQD");
|
|
sSQL.Add(" left join XLXHB on XLXHB_XLXHID = XLXSCLQD_XLXHID ");
|
|
sSQL.Add( " where 1=1 and XLXSCLQD_WPID ='ZZZZ' and isnull(XLXHB_TYBZ,'N') <> 'Y'");
|
|
|
|
if (PageParam.GetRTrimString("XHMLLB") == "TJ")
|
|
{
|
|
sSQL.Add(" and not exists (select 1 from XLXSBJTJXHML where XLXSBJTJXHML_XLXHID=XLXSCLQD_XLXHID and XLXSBJTJXHML_DYDJID=XLXSCLQD_DYDJID)");
|
|
sSQL.Add(" and not exists (select 1 from XLXSBJTJXHML where XLXSBJTJXHML_XLXHID=XLXSCLQD_XLXHID and XLXSBJTJXHML_DYDJID=' ')");
|
|
}
|
|
else if (PageParam.GetRTrimString("XHMLLB") == "BJ")
|
|
{
|
|
sSQL.Add(" and not exists (select 1 from XLXSBJXHML where XLXSBJXHML_XLXHID=XLXSCLQD_XLXHID and XLXSBJXHML_DYDJID=XLXSCLQD_DYDJID)");
|
|
sSQL.Add(" and not exists (select 1 from XLXSBJXHML where XLXSBJXHML_XLXHID=XLXSCLQD_XLXHID and XLXSBJXHML_DYDJID=' ')");
|
|
}
|
|
|
|
//型号模糊
|
|
if (!CurQueryEntity.FieldByName("XLXHIDJQPP").Value.ToString().Trim().ToUpper().Equals("TRUE"))
|
|
{
|
|
if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("XLXHID").Value.Trim()))
|
|
{
|
|
sSQL.Add(" and XLXSCLQD_XLXHID like :pXLXHID ");
|
|
sSQL.ParamByName("pXLXHID").Value = string.Format("%{0}%", CurQueryEntity.FieldByName("XLXHID").Value.Trim());
|
|
}
|
|
}
|
|
else
|
|
{
|
|
if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("XLXHID").Value.Trim()))
|
|
{
|
|
sSQL.Add(" and XLXSCLQD_XLXHID = :pXLXHID ");
|
|
sSQL.ParamByName("pXLXHID").Value = CurQueryEntity.FieldByName("XLXHID").Value.Trim();
|
|
}
|
|
}
|
|
if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("DYDJ").Value.Trim()))
|
|
{
|
|
sSQL.Add(" and XLXSCLQD_DYDJID = :pDYDJ ");
|
|
sSQL.ParamByName("pDYDJ").Value = CurQueryEntity.FieldByName("DYDJ").Value.Trim();
|
|
}
|
|
if (PageParam.GetRTrimString("XHMLLB") == "BJ")
|
|
sSQL.Add(" )a ");
|
|
sSQL.ParamByName("pCPMLID").Value = PageParam.GetRTrimString("CPMLID");
|
|
sSQL.ParamByName("pWHRID").Value = tSession.UserId;
|
|
sSQL.ParamByName("pWHR").Value = tSession.UserName;
|
|
sSQL.ParamByName("pWHSJ").Value = DateTime.Now;
|
|
dberp.ExecSQL(sSQL);
|
|
dberp.CommitTrans();
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
ShowMessage(ex.Message);
|
|
dberp.RollbackTrans();
|
|
return;
|
|
}
|
|
|
|
ShowMessage("全部导入完成！");
|
|
|
|
DialogOperationScript dos = new DialogOperationScript(this);
|
|
dos.CloseSelf();
|
|
dos.Execute();
|
|
}
|
|
}
|
|
|
|
#endregion
|
|
|
|
|
|
|
|
}
|
|
}
|