Пример #1
0
        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;
        }
Пример #2
0
        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);
        }
Пример #3
0
        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;
        }
Пример #4
0
        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);
        }
Пример #5
0
        /// <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();
            }
        }
Пример #6
0
        /// <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();
            }
        }