121 lines
5.0 KiB
C#
121 lines
5.0 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.Data;
|
|
using GThinking.N_MODEL.Page;
|
|
using GThinking.N_MISPRO;
|
|
using GThinking.N_CONTROL;
|
|
using GThinking.N_MISPRO.Utility;
|
|
|
|
namespace GThinking.N_XLXSBJ
|
|
{
|
|
public partial class BJFL_BJRHQCLList : SingleGridBase
|
|
{
|
|
BJFL_BJRHQCL entity = new BJFL_BJRHQCL();
|
|
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
{
|
|
this.UMID = 100860023;
|
|
this.UMName = "线缆销售报价分类";
|
|
this.CurMaster = Master;
|
|
this.ModuleGV = ContentGrid;
|
|
this.CurEntity = entity;
|
|
this.PageHeight = 600;
|
|
this.PageWidth = 750;
|
|
base.DataKeyNames = new string[] { "XLXSBJCL_BJCLID" };
|
|
Master.EnableNewBtn = false;
|
|
Master.EnableCopyBtn = false;
|
|
Master.EnableViewBtn = false;
|
|
Master.EnableEditBtn = false;
|
|
Master.EnableDeleteBtn = false;
|
|
Master.EnableQueryBtn = false;
|
|
|
|
base.InitPage();
|
|
|
|
if (!IsPostBack)
|
|
{
|
|
Master_OnStandardQuery(null, null);
|
|
}
|
|
}
|
|
|
|
#region 模板继承事件
|
|
|
|
protected override void Master_OnStandardQuery(object sender, EventArgs e)
|
|
{
|
|
base.Master_OnStandardQuery(sender, e);
|
|
entity.EntityTable.QuerySelSql = GetQuerySql();
|
|
entity.GridDataBind(ContentGrid, tSession);
|
|
}
|
|
|
|
protected override void moduleGV_PageIndexChanging(object sender, GridViewPageEventArgs e)
|
|
{
|
|
entity.EntityTable.QuerySelSql = GetQuerySql();
|
|
ContentGrid.SelectedIndex = -1;
|
|
base.moduleGV_PageIndexChanging(sender, e);
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 自定义方法
|
|
|
|
private string GetQuerySql()
|
|
{
|
|
string sSQL = " select XLXSBJCL_BJCLID,XLXSBJCL_BJCLMC, "
|
|
+ " case when XLXSBJFLBJRHQCL_BJCLID is null then 'N' else 'Y' end as BJRQHQ, "
|
|
+ " case when XLXSBJFLBJRHQCL_BJCLID is null then XLXSBJCL_WHRID else XLXSBJFLBJRHQCL_WHRID end as WHRID, "
|
|
+ " case when XLXSBJFLBJRHQCL_BJCLID is null then XLXSBJCL_WHR else XLXSBJFLBJRHQCL_WHR end as WHR,"
|
|
+ " case when XLXSBJFLBJRHQCL_BJCLID is null then XLXSBJCL_WHSJ else XLXSBJFLBJRHQCL_WHSJ end as WHSJ "
|
|
+ " from XLXSBJCL "
|
|
+ " left join XLXSBJFLBJRHQCL on XLXSBJFLBJRHQCL_BJFLID=:pBJFLID and XLXSBJFLBJRHQCL_BJCLID=XLXSBJCL_BJCLID "
|
|
+ " where XLXSBJCL_BJRHQ='Y' "
|
|
+ " order by XLXSBJCL_BJCLID ";
|
|
entity.Param.Add("pBJFLID", PageParam.GetRTrimString("BJFLID"));
|
|
return sSQL;
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 控件事件
|
|
|
|
protected void ContentGrid_RowDoubleClick(object sender, GThinking.N_CONTROL.RowDoubleClickEventArgs e)
|
|
{
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
string sBJFLID = PageParam.GetRTrimString("BJFLID");
|
|
string sBJCLID = ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSBJCL_BJCLID"].ToString().Trim();
|
|
if (CMISproDataBase.ExistsRecord("DBERP", string.Format("select 1 from XLXSBJFLBJRHQCL where XLXSBJFLBJRHQCL_BJFLID='{0}' and XLXSBJFLBJRHQCL_BJCLID='{1}'",
|
|
sBJFLID, sBJCLID)))
|
|
{
|
|
dberp.ExecSQL(string.Format("delete from XLXSBJFLBJRHQCL where XLXSBJFLBJRHQCL_BJFLID='{0}' and XLXSBJFLBJRHQCL_BJCLID='{1}'", sBJFLID, sBJCLID));
|
|
}
|
|
else
|
|
{
|
|
if (CMISproDataBase.ExistsRecord("DBERP", string.Format("select 1 from XLXSBJFL where XLXSBJFL_BJFLID='{0}' and XLXSBJFL_JGBTJYSS='3'", sBJFLID)))
|
|
{
|
|
ShowMessage("价格表调价因素“3|表价(现行价)=基价(出厂价+材料价价差)&调价”暂不支持设置报价日行情材料！");
|
|
return;
|
|
}
|
|
TSQL sql = new TSQL(dberp);
|
|
sql.Add("insert into XLXSBJFLBJRHQCL(XLXSBJFLBJRHQCL_BJFLID,XLXSBJFLBJRHQCL_BJCLID,XLXSBJFLBJRHQCL_WHRID,XLXSBJFLBJRHQCL_WHR,XLXSBJFLBJRHQCL_WHSJ)");
|
|
sql.Add(" values(:XLXSBJFLBJRHQCL_BJFLID,:XLXSBJFLBJRHQCL_BJCLID,:XLXSBJFLBJRHQCL_WHRID,:XLXSBJFLBJRHQCL_WHR,:XLXSBJFLBJRHQCL_WHSJ)");
|
|
sql.ParamByName("XLXSBJFLBJRHQCL_BJFLID").Value = sBJFLID;
|
|
sql.ParamByName("XLXSBJFLBJRHQCL_BJCLID").Value = sBJCLID;
|
|
sql.ParamByName("XLXSBJFLBJRHQCL_WHR").Value = tSession.UserName;
|
|
sql.ParamByName("XLXSBJFLBJRHQCL_WHRID").Value = tSession.UserId;
|
|
sql.ParamByName("XLXSBJFLBJRHQCL_WHSJ").Value = DateTime.Now;
|
|
dberp.ExecSQL(sql);
|
|
}
|
|
moduleGV_PageIndexChanging(null, null);
|
|
FormAreaUpdate();
|
|
}
|
|
|
|
#endregion
|
|
}
|
|
}
|