public static bool Delete(BatchModel bm) { string strSQL = "DELETE FROM [TSAP_JOBNO_BATCH] WHERE 1=1"; if(bm.SAP_BATCH==""&&bm.JOB_NO=="") { return false; } if (bm.SAP_BATCH != "") { strSQL = strSQL + " AND SAP_BATCH='" + bm.SAP_BATCH + "'"; } if (bm.JOB_NO != "") { strSQL = strSQL + " AND JOB_NO='" + bm.JOB_NO + "'"; } if (bm.STDPOWER != "") { strSQL = strSQL + " AND STDPOWER='" + bm.STDPOWER + "'"; } var reader = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectString, CommandType.Text, strSQL); return reader > 0 ? true : false; }
public static bool Delete(BatchModel bm) { string strSQL = "DELETE FROM [TSAP_JOBNO_BATCH] WHERE 1=1"; if (bm.SAP_BATCH == "" && bm.JOB_NO == "") { return(false); } if (bm.SAP_BATCH != "") { strSQL = strSQL + " AND SAP_BATCH='" + bm.SAP_BATCH + "'"; } if (bm.JOB_NO != "") { strSQL = strSQL + " AND JOB_NO='" + bm.JOB_NO + "'"; } if (bm.STDPOWER != "") { strSQL = strSQL + " AND STDPOWER='" + bm.STDPOWER + "'"; } var reader = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectString, CommandType.Text, strSQL); return(reader > 0 ? true : false); }
public static bool Insert(BatchModel bm) { string strSQL = string.Format(@"INSERT INTO [TSAP_JOBNO_BATCH]([JOB_NO],[SAP_BATCH],[STDPOWER],[CREATED_ON],[CREATED_BY]) VALUES ('{0}','{1}','{2}','{3}','{4}')", bm.JOB_NO, bm.SAP_BATCH,bm.STDPOWER,bm.CREATED_ON,bm.CREATED_BY); var reader = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectString, CommandType.Text, strSQL); return reader > 0 ? true : false; }
public static bool Insert(BatchModel bm) { string strSQL = string.Format(@"INSERT INTO [TSAP_JOBNO_BATCH]([JOB_NO],[SAP_BATCH],[STDPOWER],[CREATED_ON],[CREATED_BY]) VALUES ('{0}','{1}','{2}','{3}','{4}')", bm.JOB_NO, bm.SAP_BATCH, bm.STDPOWER, bm.CREATED_ON, bm.CREATED_BY); var reader = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectString, CommandType.Text, strSQL); return(reader > 0 ? true : false); }
/// <summary> /// 执行操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button2_Click(object sender, EventArgs e) { try { //判断密码 if (txtPassword.Text == "") { Log("请输入操作口令", "ABNORMAL", lstView); return; } if (!txtPassword.Text.Equals(Password)) { Log("输入的口令不正确,无法进行操作", "ABNORMAL", lstView); return; } if (radioButton1.Checked) { if (txtBatch.Text.Trim() == "") { Log("SapBatch不能为空", "ABNORMAL", lstView); return; } if (txtJobno.Text.Trim() == "") { Log("JobNo不能为空", "ABNORMAL", lstView); return; } if (txtStdpower.Text.Trim() == "") { Log("标称功率不能为空", "ABNORMAL", lstView); return; } } if (radioButton3.Checked) { if (txtBatch.Text.Trim() == "" && txtJobno.Text.Trim() == "") { Log("Sapbatch和Jobno不能同时为空", "ABNORMAL", lstView); return; } } //检查是否存在此jobno var batchNo = BatchDAL.getBatchInfo(txtJobno.Text.Trim(), txtBatch.Text.Trim()); if (batchNo != null && radioButton1.Checked) { Log(string.Format("此记录已经存在 BatchNo:{0} JobNo:{1} StdPower:{2}", batchNo.SAP_BATCH, batchNo.JOB_NO, batchNo.STDPOWER), "ABNORMAL", lstView); return; } if (batchNo == null && radioButton3.Checked) { Log("数据库中没有满足条件的数据,无法进行删除", "ABNORMAL", lstView); return; } BatchModel bm = new BatchModel(); bm.JOB_NO = txtJobno.Text.Trim(); bm.SAP_BATCH = txtBatch.Text.Trim(); bm.STDPOWER = txtStdpower.Text.Trim(); bm.CREATED_BY = System.Net.Dns.GetHostName(); bm.CREATED_ON = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); if (radioButton1.Checked) { if (BatchDAL.Insert(bm)) { Log(string.Format("插入成功! BatchNo:{0} JobNo:{1} StdPower:{2}", bm.SAP_BATCH, bm.JOB_NO, bm.STDPOWER), "NORMAL", lstView); return; } else { Log("插入失败!", "ABNORMAL", lstView); return; } } if (radioButton3.Checked) { if (BatchDAL.Delete(bm)) { Log(string.Format("删除成功! BatchNo:{0} JobNo:{1}", batchNo.SAP_BATCH, batchNo.JOB_NO), "NORMAL", lstView); return; } else { Log("删除失败!", "ABNORMAL", lstView); return; } } } catch (Exception ex) { Log(string.Format("操作异常! {0}", ex.Message), "ABNORMAL", lstView); return; } finally { clearControl(); } }
/// <summary> /// 执行操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button2_Click(object sender, EventArgs e) { try { //判断密码 if (txtPassword.Text == "") { Log("请输入操作口令", "ABNORMAL", lstView); return; } if (!txtPassword.Text.Equals(Password)) { Log("输入的口令不正确,无法进行操作", "ABNORMAL", lstView); return; } if (radioButton1.Checked) { if (txtBatch.Text.Trim() == "") { Log("SapBatch不能为空", "ABNORMAL", lstView); return; } if (txtJobno.Text.Trim() == "") { Log("JobNo不能为空", "ABNORMAL", lstView); return; } if (txtStdpower.Text.Trim() == "") { Log("标称功率不能为空", "ABNORMAL", lstView); return; } } if (radioButton3.Checked) { if (txtBatch.Text.Trim() == "" && txtJobno.Text.Trim() == "") { Log("Sapbatch和Jobno不能同时为空", "ABNORMAL", lstView); return; } } //检查是否存在此jobno var batchNo = BatchDAL.getBatchInfo(txtJobno.Text.Trim(), txtBatch.Text.Trim()); if (batchNo != null && radioButton1.Checked) { Log(string.Format("此记录已经存在 BatchNo:{0} JobNo:{1} StdPower:{2}", batchNo.SAP_BATCH, batchNo.JOB_NO, batchNo.STDPOWER), "ABNORMAL", lstView); return; } if (batchNo == null && radioButton3.Checked) { Log("数据库中没有满足条件的数据,无法进行删除", "ABNORMAL", lstView); return; } BatchModel bm = new BatchModel(); bm.JOB_NO = txtJobno.Text.Trim(); bm.SAP_BATCH = txtBatch.Text.Trim(); bm.STDPOWER = txtStdpower.Text.Trim(); bm.CREATED_BY = System.Net.Dns.GetHostName(); bm.CREATED_ON = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); if (radioButton1.Checked) { if (BatchDAL.Insert(bm)) { Log(string.Format("插入成功! BatchNo:{0} JobNo:{1} StdPower:{2}", bm.SAP_BATCH, bm.JOB_NO, bm.STDPOWER), "NORMAL", lstView); return; } else { Log("插入失败!", "ABNORMAL", lstView); return; } } if (radioButton3.Checked) { if (BatchDAL.Delete(bm)) { Log(string.Format("删除成功! BatchNo:{0} JobNo:{1}", batchNo.SAP_BATCH, batchNo.JOB_NO), "NORMAL", lstView); return; } else { Log("删除失败!", "ABNORMAL", lstView); return; } } } catch (Exception ex) { Log(string.Format("操作异常! {0}", ex.Message), "ABNORMAL", lstView); return; } finally { clearControl(); } }