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 } }