public bool veriFileType(int tid, int _typeid) { ArrayList list = new ArrayList(); list.Add(string.Concat(new object[] { "SELECT * FROM EPM_Datum_Affair eda LEFT JOIN XPM_Basic_CodeList xbcl ON xbcl.CodeID=eda.filesType LEFT JOIN XPM_Basic_CodeType xbct ON xbct.TypeID = xbcl.TypeID WHERE xbct.SignCode='DocumentType' AND eda.filesType=", tid, " AND xbcl.TypeID=", _typeid })); list.Add(string.Concat(new object[] { "SELECT * FROM v_Quality_Goal eda LEFT JOIN XPM_Basic_CodeList xbcl ON xbcl.CodeID=eda.filesType LEFT JOIN XPM_Basic_CodeType xbct ON xbct.TypeID = xbcl.TypeID WHERE xbct.SignCode='DocumentType' AND eda.filesType=", tid, " AND xbcl.TypeID=", _typeid })); string saftyViewName = SafetyMeasureAction.GetSaftyViewName(); list.Add(string.Concat(new object[] { "SELECT * FROM ", saftyViewName, " eda LEFT JOIN XPM_Basic_CodeList xbcl ON xbcl.CodeID=eda.filesType LEFT JOIN XPM_Basic_CodeType xbct ON xbct.TypeID = xbcl.TypeID WHERE xbct.SignCode='DocumentType' AND eda.filesType=", tid, " AND xbcl.TypeID=", _typeid })); list.Add(string.Concat(new object[] { "SELECT * FROM Prj_V_ScienceInnovate eda LEFT JOIN XPM_Basic_CodeList xbcl ON xbcl.CodeID=eda.filesType LEFT JOIN XPM_Basic_CodeType xbct ON xbct.TypeID = xbcl.TypeID WHERE xbct.SignCode='DocumentType' AND eda.filesType=", tid, " AND xbcl.TypeID=", _typeid })); list.Add(string.Concat(new object[] { "SELECT * FROM Prj_V_ExpertProject eda LEFT JOIN XPM_Basic_CodeList xbcl ON xbcl.CodeID=eda.filesType LEFT JOIN XPM_Basic_CodeType xbct ON xbct.TypeID = xbcl.TypeID WHERE xbct.SignCode='DocumentType' AND eda.filesType=", tid, " AND xbcl.TypeID=", _typeid })); list.Add(string.Concat(new object[] { "SELECT * FROM Prj_TechnologyCriterion eda LEFT JOIN XPM_Basic_CodeList xbcl ON xbcl.CodeID=eda.filesType LEFT JOIN XPM_Basic_CodeType xbct ON xbct.TypeID = xbcl.TypeID WHERE xbct.SignCode='DocumentType' AND eda.filesType=", tid, " AND xbcl.TypeID=", _typeid })); list.Add(string.Concat(new object[] { "SELECT * FROM Prj_TechnologyManage eda LEFT JOIN XPM_Basic_CodeList xbcl ON xbcl.CodeID=eda.filesType LEFT JOIN XPM_Basic_CodeType xbct ON xbct.TypeID = xbcl.TypeID WHERE xbct.SignCode='DocumentType' AND eda.filesType=", tid, " AND xbcl.TypeID=", _typeid })); list.Add(string.Concat(new object[] { "SELECT * FROM Prj_V_TechnologyJD eda LEFT JOIN XPM_Basic_CodeList xbcl ON xbcl.CodeID=eda.filesType LEFT JOIN XPM_Basic_CodeType xbct ON xbct.TypeID = xbcl.TypeID WHERE xbct.SignCode='DocumentType' AND eda.filesType=", tid, " AND xbcl.TypeID=", _typeid })); list.Add(string.Concat(new object[] { "SELECT * FROM Prj_Summary eda LEFT JOIN XPM_Basic_CodeList xbcl ON xbcl.CodeID=eda.filesType LEFT JOIN XPM_Basic_CodeType xbct ON xbct.TypeID = xbcl.TypeID WHERE xbct.SignCode='DocumentType' AND eda.filesType=", tid, " AND xbcl.TypeID=", _typeid })); list.Add(string.Concat(new object[] { "SELECT * FROM Prj_ItemInspect eda LEFT JOIN XPM_Basic_CodeList xbcl ON xbcl.CodeID=eda.filesType LEFT JOIN XPM_Basic_CodeType xbct ON xbct.TypeID = xbcl.TypeID WHERE xbct.SignCode='DocumentType' AND eda.filesType=", tid, " AND xbcl.TypeID=", _typeid })); list.Add(string.Concat(new object[] { "SELECT * FROM Prj_ItemProg eda LEFT JOIN XPM_Basic_CodeList xbcl ON xbcl.CodeID=eda.filesType LEFT JOIN XPM_Basic_CodeType xbct ON xbct.TypeID = xbcl.TypeID WHERE xbct.SignCode='DocumentType' AND eda.filesType=", tid, " AND xbcl.TypeID=", _typeid })); for (int i = 0; i < list.Count; i++) { DataTable table = SqlHelper.ExecuteQuery(CommandType.Text, list[i].ToString().ToString(), null); if ((table != null) && (table.Rows.Count > 0)) { return(false); } } return(true); }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { string a; if ((a = this.page_type) != null) { if (!(a == "Add")) { if (a == "Update") { this.LblHead.Text = "修改安全目标方案"; SafetyMeasureAction.GetSingleRow(this.Page_Code); this.InfoObj = this.ActObj.GetSafetyMeasureModel(this.Page_Code); if (this.InfoObj != null) { this.TxtScheduleCode.Text = this.InfoObj.TaskName; this.TxtMeasure.Text = this.InfoObj.SaftyMeasure; this.Txtremark.Text = this.InfoObj.Remark; this.hdnTempScheduleCode.Value = this.InfoObj.ScheduleCode; this.hdnprjcode.Value = this.InfoObj.PrjCode.ToString(); int arg_13D_0 = this.InfoObj.Mark; if (this.InfoObj.Mark.ToString() != "") { int mark = this.InfoObj.Mark; if (mark != 2) { this.cbkmark.Checked = true; int arg_184_0 = this.InfoObj.FilesType; if (this.InfoObj.FilesType.ToString() != "") { this.hidenClass.Value = this.InfoObj.FilesType.ToString(); } } this.hdnmark.Value = mark.ToString(); } } } } else { if (base.Request["PrjCode"] == "") { this.JS.Text = "alert('请选择项目!');window.close();"; } this.LblHead.Text = "新增安全目标方案"; } } this.TxtScheduleCode.Attributes["onclick"] = "javascript:pickSchedule(this);"; } }
protected void BtnDelete_Click(object sender, EventArgs e) { new SafetyMeasureAction(); if (SafetyMeasureAction.DEL(new SafetyMeasureInfo { i_id = Convert.ToInt32(this.hiden_i_id.Value) }.i_id.ToString()) == 1) { this.JS.Text = "alert('操作成功!');"; this.Data_Bind(); return; } this.JS.Text = "alert('操作失败,网络连接故障,请稍候再试')"; }
protected void BtnOK_Click(object sender, EventArgs e) { if (this.page_Code != "") { this.hdnPn.Value = this.page_Code; this.InfoObj.i_id = int.Parse(this.page_Code); } this.InfoObj.PrjCode = new Guid(this.hdnprjcode.Value); this.InfoObj.ScheduleName = this.TxtScheduleCode.Text; this.InfoObj.ScheduleCode = this.hdnTempScheduleCode.Value; this.InfoObj.SaftyMeasure = this.TxtMeasure.Text; this.InfoObj.Remark = this.Txtremark.Text; new DatumLogic(); int num = 0; if (this.cbkmark.Checked) { this.InfoObj.Mark = 3; this.InfoObj.FilesType = int.Parse(this.DDTClass.SelectedValue.ToString()); this.filesClass.Visible = true; } else { this.InfoObj.Mark = 2; this.InfoObj.FilesType = 0; this.filesClass.Visible = false; } string a; if ((a = this.Page_type) != null) { if (!(a == "Add")) { if (a == "Update") { num = SafetyMeasureAction.Update(this.InfoObj); } } else { num = SafetyMeasureAction.Add(this.InfoObj); } } if (num > 0) { base.RegisterScript("top.ui.tabSuccess({ parentName: '_measurelist' });"); return; } base.RegisterScript("top.ui.alert('修改失败');"); }
protected void Data_Bind() { string strWhere; if (this.page_PrjCode != "") { strWhere = "PrjCode= '" + this.page_PrjCode + "'"; } else { strWhere = "PrjCode= '" + Guid.NewGuid() + "'"; } DataTable pageData = SafetyMeasureAction.GetPageData(strWhere); this.GridView_goall.DataSource = pageData; this.ViewState[MeasureList.resourceTable] = pageData; this.GridView_goall.DataBind(); }