protected void btnDelete_Click(object sender, EventArgs e) { string chk_no = hidChkNo.Text.Trim(); string line_id = this.tbxLineId_key.Text; string user = this.tbxCheckUser.Text.Trim(); TCheckResultBC BC = new TCheckResultBC(); BC.DeleteCheckResult(chk_no, line_id, user); MsInit(1); }
private System.Data.DataTable GetMsData() { TCheckResultBC BC = new TCheckResultBC(); string startTime; string endTime; System.DateTime currentTime = new System.DateTime(); if (this.tbxDate_key.Text == "") { currentTime = System.DateTime.Now; startTime = currentTime.AddDays(-7).ToString("yyyy/MM/dd"); endTime = currentTime.ToString("yyyy/MM/dd"); } else { startTime = Convert.ToDateTime(this.tbxDate_key.Text).ToString("yyyy/MM/dd"); endTime = startTime; } return(BC.SelTCheckResult(this.tbxLineId_key.Text, startTime, endTime, "", "")); }
/// <summary> /// 新规检查 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnInsert_Click(object sender, EventArgs e) { //string chk_no = this.hidChkNo.Text; //string make_no = this.hidMakeNo.Text; //string code = this.hidCode.Text; //string suu = this.hidSuu.Text; string make_no = this.tbxMakeNo_key.Text; string code = this.tbxCode_key.Text; string suu = this.hidSuu.Text; string line_id = this.tbxLineId_key.Text; Context.Items["chk_date"] = this.tbxDate_key.Text.Trim(); Context.Items["make_no"] = make_no; Context.Items["code"] = code; Context.Items["line_id"] = line_id; Context.Items["user"] = this.tbxCheckUser.Text.Trim(); Context.Items["user_name"] = this.lblUserName.Text; TCheckResultBC BC = new TCheckResultBC(); System.Data.DataTable dt = BC.SelTCheckResult(this.tbxLineId_key.Text, "", "", make_no, code); Int32 i, mxChkTimes, chkTimes, idx; mxChkTimes = 0; idx = 0; string yotei_chk_date; DataRow[] drs; string tmp_chk_no; ///sp = chr("_"); if (dt.Rows.Count > 0) { yotei_chk_date = dt.Rows[0]["yotei_chk_date"].ToString(); drs = dt.Select("yotei_chk_date='" + yotei_chk_date + "'"); for (i = 0; i <= drs.Length - 1; i++) { chkTimes = Convert.ToInt32(dt.Rows[i]["chk_times"].ToString()); if (mxChkTimes < chkTimes) { mxChkTimes = chkTimes; idx = i; } } if (drs[idx]["temp_id"].ToString().Trim() == "") { Common.ShowMsg(this.Page, "检查模板不存在"); return; } string[] sArray = drs[idx]["chk_no"].ToString().Split('_'); tmp_chk_no = sArray[0] + "_" + sArray[1] + "_" + (mxChkTimes + 1).ToString(); BC.InsTCheckResult(tmp_chk_no , System.DateTime.Now.Year.ToString() , (mxChkTimes + 1).ToString() , drs[idx]["plan_no"].ToString() , drs[idx]["line_id"].ToString() , drs[idx]["make_no"].ToString() , drs[idx]["code"].ToString() , drs[idx]["suu"].ToString() , drs[idx]["temp_id"].ToString() , drs[idx]["chk_result"].ToString() , this.tbxCheckUser.Text.Trim() , drs[idx]["yotei_chk_date"].ToString() , System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") , "" , "" , "0" , this.tbxCheckUser.Text.Trim() , System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") ); Context.Items["chk_no"] = tmp_chk_no; Server.Transfer("t_check_ms.aspx"); } else { Common.ShowMsg(this.Page, "检查计划数据不存在;"); return; } }