示例#1
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public string Update(TH.Model._8D报告 model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update UFDLImport.._8D报告 set ");
            if (model.TaskID != null)
            {
                strSql.Append("TaskID=" + model.TaskID + ",");
            }
            else
            {
                strSql.Append("TaskID= null ,");
            }
            if (model.组长 != null)
            {
                strSql.Append("组长='" + model.组长 + "',");
            }
            else
            {
                strSql.Append("组长= null ,");
            }
            if (model.品管部 != null)
            {
                strSql.Append("品管部='" + model.品管部 + "',");
            }
            else
            {
                strSql.Append("品管部= null ,");
            }
            if (model.工程部 != null)
            {
                strSql.Append("工程部='" + model.工程部 + "',");
            }
            else
            {
                strSql.Append("工程部= null ,");
            }
            if (model.制造部 != null)
            {
                strSql.Append("制造部='" + model.制造部 + "',");
            }
            else
            {
                strSql.Append("制造部= null ,");
            }
            if (model.调查情况 != null)
            {
                strSql.Append("调查情况='" + model.调查情况 + "',");
            }
            if (model.调查情况签名 != null)
            {
                strSql.Append("调查情况签名='" + model.调查情况签名 + "',");
            }
            if (model.调查情况日期 != null && model.调查情况日期 != DateTime.MinValue)
            {
                strSql.Append("调查情况日期='" + model.调查情况日期 + "',");
            }
            if (model.临时措施 != null)
            {
                strSql.Append("临时措施='" + model.临时措施 + "',");
            }
            if (model.临时措施责任人 != null)
            {
                strSql.Append("临时措施责任人='" + model.临时措施责任人 + "',");
            }
            if (model.临时措施完成时限 != null && model.临时措施完成时限 != DateTime.MinValue)
            {
                strSql.Append("临时措施完成时限='" + model.临时措施完成时限 + "',");
            }
            if (model.临时措施结果验证 != null)
            {
                strSql.Append("临时措施结果验证='" + model.临时措施结果验证 + "',");
            }
            if (model.原因分析 != null)
            {
                strSql.Append("原因分析='" + model.原因分析 + "',");
            }
            if (model.纠正措施 != null)
            {
                strSql.Append("纠正措施='" + model.纠正措施 + "',");
            }
            if (model.纠正措施责任人 != null)
            {
                strSql.Append("纠正措施责任人='" + model.纠正措施责任人 + "',");
            }
            if (model.纠正措施完成时限 != null && model.纠正措施完成时限 != DateTime.MinValue)
            {
                strSql.Append("纠正措施完成时限='" + model.纠正措施完成时限 + "',");
            }
            if (model.纠正措施结果验证 != null)
            {
                strSql.Append("纠正措施结果验证='" + model.纠正措施结果验证 + "',");
            }
            if (model.预防措施 != null)
            {
                strSql.Append("预防措施='" + model.预防措施 + "',");
            }
            if (model.预防措施责任人 != null)
            {
                strSql.Append("预防措施责任人='" + model.预防措施责任人 + "',");
            }
            if (model.预防措施完成时限 != null && model.预防措施完成时限 != DateTime.MinValue)
            {
                strSql.Append("预防措施完成时限='" + model.预防措施完成时限 + "',");
            }
            if (model.预防措施结果验证 != null)
            {
                strSql.Append("预防措施结果验证='" + model.预防措施结果验证 + "',");
            }
            if (model.效果 != null)
            {
                strSql.Append("效果='" + model.效果 + "',");
            }
            if (model.效果签名 != null)
            {
                strSql.Append("效果签名='" + model.效果签名 + "',");
            }
            if (model.再次提交 != null)
            {
                strSql.Append("再次提交='" + model.再次提交 + "',");
            }
            if (model.再次提交日期 != null && model.再次提交日期 != DateTime.MinValue)
            {
                strSql.Append("再次提交日期='" + model.再次提交日期 + "',");
            }

            int n = strSql.ToString().LastIndexOf(",");

            strSql.Remove(n, 1);
            strSql.Append(" where IDHead=" + model.IDHead + " ");
            return(strSql.ToString());
        }
示例#2
0
        private void btnSave()
        {
            if (sState != "edit")
            {
                throw new Exception("请先点击编辑,并编辑数据后保存");
            }
            if (label状态.Text == "批准")
            {
                throw new Exception("已经批准,不能编辑");
            }

            txtIDHead.Focus();
            TH.Model._8D报告 model = new TH.Model._8D报告();

            if (txtIDHead.Text.Trim() == "")
            {
                throw new Exception("获得单据ID失败");
            }

            string    sSQL = "select * from UFDLImport.._8D报告 where idHead = " + txtIDHead.Text.Trim();
            DataTable dt   = clsSQLCommond.ExecQuery(sSQL);

            if (dt != null && dt.Rows.Count > 0 && dt.Rows[0]["状态"].ToString().Trim().ToLower() == "true" && dt.Rows[0]["审批人"].ToString().Trim() != "")
            {
                throw new Exception("单据已经批准");
            }

            model.IDHead = ReturnObjectToLong(txtIDHead.Text.Trim());
            model.TaskID = ReturnObjectToLong(txtTaskID.Text.Trim());

            if (txt组长.Text.Trim() == "" && txt品管部.Text.Trim() == "" && txt工程部.Text.Trim() == "" && txt制造部.Text.Trim() == "")
            {
                throw new Exception("组长,品管部,工程部,制造部 必须至少填写一栏");
            }

            model.组长  = txt组长.Text.Trim();
            model.品管部 = txt品管部.Text.Trim();
            model.工程部 = txt工程部.Text.Trim();
            model.制造部 = txt制造部.Text.Trim();

            if (txt调查情况.Text.Trim() == "")
            {
                throw new Exception("调查情况 必输");
            }
            model.调查情况 = txt调查情况.Text.Trim();

            if (txt签名.Text.Trim() == "")
            {
                throw new Exception("签名 必输");
            }
            model.调查情况签名 = txt签名.Text.Trim();

            if (ReturnObjectToDatetime(dtm签名日期.DateTime.ToString("yyyy-MM-dd")) < ReturnObjectToDatetime("2000-1-1"))
            {
                throw new Exception("调查签名日期 必输");
            }
            model.调查情况日期 = ReturnObjectToDatetime(dtm签名日期.DateTime.ToString("yyyy-MM-dd"));

            if (txt临时措施.Text.Trim() == "")
            {
                throw new Exception("临时措施 必输");
            }
            model.临时措施 = txt临时措施.Text.Trim();

            if (txt临时措施责任人.Text.Trim() == "")
            {
                throw new Exception("临时措施责任人 必输");
            }
            model.临时措施责任人 = txt临时措施责任人.Text.Trim();

            if (ReturnObjectToDatetime(dtm临时措施完成时限.DateTime.ToString("yyyy-MM-dd")) < ReturnObjectToDatetime("2000-1-1"))
            {
                throw new Exception("临时措施完成时限 必输");
            }
            model.临时措施完成时限 = ReturnObjectToDatetime(dtm临时措施完成时限.DateTime.ToString("yyyy-MM-dd"));

            if (txt临时措施结果验证.Text.Trim() == "")
            {
                throw new Exception("临时措施结果验证 必输");
            }
            model.临时措施结果验证 = txt临时措施结果验证.Text.Trim();

            if (txt原因分析.Text.Trim() == "")
            {
                throw new Exception("原因分析 必输");
            }
            model.原因分析 = txt原因分析.Text.Trim();

            if (txt纠正措施.Text.Trim() == "")
            {
                throw new Exception("纠正措施 必输");
            }
            model.纠正措施 = txt纠正措施.Text.Trim();

            if (txt纠正措施责任人.Text.Trim() == "")
            {
                throw new Exception("纠正措施责任人 必输");
            }
            model.纠正措施责任人 = txt纠正措施责任人.Text.Trim();

            if (ReturnObjectToDatetime(dtm纠正措施完成时限.DateTime.ToString("yyyy-MM-dd")) < ReturnObjectToDatetime("2000-1-1"))
            {
                throw new Exception("纠正措施完成时限 必输");
            }
            model.纠正措施完成时限 = ReturnObjectToDatetime(dtm纠正措施完成时限.DateTime.ToString("yyyy-MM-dd"));

            if (txt纠正措施结果验证.Text.Trim() == "")
            {
                throw new Exception("纠正措施结果验证 必输");
            }
            model.纠正措施结果验证 = txt纠正措施结果验证.Text.Trim();

            if (txt预防措施.Text.Trim() == "")
            {
                throw new Exception("预防措施 必输");
            }
            model.预防措施 = txt预防措施.Text.Trim();

            if (txt预防措施责任人.Text.Trim() == "")
            {
                throw new Exception("预防措施责任人 必输");
            }
            model.预防措施责任人 = txt预防措施责任人.Text.Trim();

            if (ReturnObjectToDatetime(dtm预防措施完成时限.DateTime.ToString("yyyy-MM-dd")) < ReturnObjectToDatetime("2000-1-1"))
            {
                throw new Exception("预防措施完成时限 必输");
            }
            model.预防措施完成时限 = ReturnObjectToDatetime(dtm预防措施完成时限.DateTime.ToString("yyyy-MM-dd"));

            if (txt预防措施结果验证.Text.Trim() == "")
            {
                throw new Exception("预防措施结果验证 必输");
            }
            model.预防措施结果验证 = txt预防措施结果验证.Text.Trim();
            model.效果       = txt效果.Text.Trim();
            model.效果签名     = txt效果签名.Text.Trim();

            TH.DAL._8D报告 dal = new TH.DAL._8D报告();

            sSQL = "select count(1) from  UFDLImport.._8D报告 where IDHead = " + model.IDHead.ToString();
            dt   = clsSQLCommond.ExecQuery(sSQL);
            int iCou = ReturnObjectToInt(dt.Rows[0][0]);

            if (iCou == 0)
            {
                sSQL = dal.Add(model);
            }
            else
            {
                model.再次提交   = sUserName;
                model.再次提交日期 = DateTime.Now;

                sSQL = dal.Update(model);
            }
            iCou = clsSQLCommond.ExecSql(sSQL);
            if (iCou > 0)
            {
                MessageBox.Show("保存成功");
                SetEnable(false);
            }

            #region 发送邮件给品管
            sSQL = @"
select distinct sEMail
from dbo._UserInfo left join UFDLImport.._vendUid on vchrUid=uid and accid = 200 and accyear = 111111 
	left join @u8.vendor on cVenCode = vendCode 
	left join @u8.Department d on d.cDepCode=_UserInfo.cDepCode 
where d.cdepcode = '6'and isnull(sEMail,'') <> ''
            ";
            sSQL = sSQL.Replace("111111", FrameBaseFunction.ClsBaseDataInfo.sUFDataBaseName.Substring(11, 4));
            dt   = clsSQLCommond.ExecQuery(sSQL);
            if (dt == null || dt.Rows.Count < 1)
            {
                throw new Exception("获得品管邮箱失败");
            }

            string sMail = "";
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (sMail == "")
                {
                    sMail = dt.Rows[i]["sEMail"].ToString().Trim();
                }
                else
                {
                    sMail = sMail + ";" + dt.Rows[i]["sEMail"].ToString().Trim();
                }
            }
            if (sMail.Trim() == "")
            {
                throw new Exception("获得供应商邮箱失败");
            }

            string sText = "杜乐8D改进报告:" + txt编号.Text.Trim() + " 已拒绝";
            if (sMail.Trim() != "")
            {
                btnSendMail(sText, sMail);
            }
            #endregion
        }
示例#3
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public string Add(TH.Model._8D报告 model)
        {
            StringBuilder strSql  = new StringBuilder();
            StringBuilder strSql1 = new StringBuilder();
            StringBuilder strSql2 = new StringBuilder();

            if (model.IDHead != null)
            {
                strSql1.Append("IDHead,");
                strSql2.Append("" + model.IDHead + ",");
            }
            if (model.TaskID != null)
            {
                strSql1.Append("TaskID,");
                strSql2.Append("" + model.TaskID + ",");
            }
            if (model.组长 != null)
            {
                strSql1.Append("组长,");
                strSql2.Append("'" + model.组长 + "',");
            }
            if (model.品管部 != null)
            {
                strSql1.Append("品管部,");
                strSql2.Append("'" + model.品管部 + "',");
            }
            if (model.工程部 != null)
            {
                strSql1.Append("工程部,");
                strSql2.Append("'" + model.工程部 + "',");
            }
            if (model.制造部 != null)
            {
                strSql1.Append("制造部,");
                strSql2.Append("'" + model.制造部 + "',");
            }
            if (model.调查情况 != null)
            {
                strSql1.Append("调查情况,");
                strSql2.Append("'" + model.调查情况 + "',");
            }
            if (model.调查情况签名 != null)
            {
                strSql1.Append("调查情况签名,");
                strSql2.Append("'" + model.调查情况签名 + "',");
            }
            if (model.调查情况日期 != null && model.调查情况日期 != DateTime.MinValue)
            {
                strSql1.Append("调查情况日期,");
                strSql2.Append("'" + model.调查情况日期 + "',");
            }
            if (model.临时措施 != null)
            {
                strSql1.Append("临时措施,");
                strSql2.Append("'" + model.临时措施 + "',");
            }
            if (model.临时措施责任人 != null)
            {
                strSql1.Append("临时措施责任人,");
                strSql2.Append("'" + model.临时措施责任人 + "',");
            }
            if (model.临时措施完成时限 != null && model.临时措施完成时限 != DateTime.MinValue)
            {
                strSql1.Append("临时措施完成时限,");
                strSql2.Append("'" + model.临时措施完成时限 + "',");
            }
            if (model.临时措施结果验证 != null)
            {
                strSql1.Append("临时措施结果验证,");
                strSql2.Append("'" + model.临时措施结果验证 + "',");
            }
            if (model.原因分析 != null)
            {
                strSql1.Append("原因分析,");
                strSql2.Append("'" + model.原因分析 + "',");
            }
            if (model.纠正措施 != null)
            {
                strSql1.Append("纠正措施,");
                strSql2.Append("'" + model.纠正措施 + "',");
            }
            if (model.纠正措施责任人 != null)
            {
                strSql1.Append("纠正措施责任人,");
                strSql2.Append("'" + model.纠正措施责任人 + "',");
            }
            if (model.纠正措施完成时限 != null && model.纠正措施完成时限 != DateTime.MinValue)
            {
                strSql1.Append("纠正措施完成时限,");
                strSql2.Append("'" + model.纠正措施完成时限 + "',");
            }
            if (model.纠正措施结果验证 != null)
            {
                strSql1.Append("纠正措施结果验证,");
                strSql2.Append("'" + model.纠正措施结果验证 + "',");
            }
            if (model.预防措施 != null)
            {
                strSql1.Append("预防措施,");
                strSql2.Append("'" + model.预防措施 + "',");
            }
            if (model.预防措施责任人 != null)
            {
                strSql1.Append("预防措施责任人,");
                strSql2.Append("'" + model.预防措施责任人 + "',");
            }
            if (model.预防措施完成时限 != null && model.预防措施完成时限 != DateTime.MinValue)
            {
                strSql1.Append("预防措施完成时限,");
                strSql2.Append("'" + model.预防措施完成时限 + "',");
            }
            if (model.预防措施结果验证 != null)
            {
                strSql1.Append("预防措施结果验证,");
                strSql2.Append("'" + model.预防措施结果验证 + "',");
            }
            if (model.效果 != null)
            {
                strSql1.Append("效果,");
                strSql2.Append("'" + model.效果 + "',");
            }
            if (model.效果签名 != null)
            {
                strSql1.Append("效果签名,");
                strSql2.Append("'" + model.效果签名 + "',");
            }

            strSql.Append("insert into UFDLImport.._8D报告(");
            strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
            strSql.Append(")");
            strSql.Append(" values (");
            strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
            strSql.Append(")");
            return(strSql.ToString());
        }