/// <summary> /// 将数据写入试验任务信息表中(TEST_INFO)Model /// 参数:operType=1:新增Add操作;operType=2:修改Update操作 /// </summary> /// <returns></returns> private void CreateOrUpdateTestInfo(int operType) { this._mdlTestInfo = new ModelTEST_INFO(); //任务编号 this._mdlTestInfo.F_TEST_TASK_ID = txtTaskId.Text.Trim(); //检测项目 this._mdlTestInfo.F_TEST_ITEM = txtTestItem.Text.Trim(); //规格型号 this._mdlTestInfo.F_TEST_MODEL = txtTestModel.Text.Trim(); //检测标准 this._mdlTestInfo.F_TEST_STANDARD = txtTestStandard.Text.Trim(); //检测性质 this._mdlTestInfo.F_TEST_PROPERTY = txtTestProperty.Text.Trim(); //检测目的 this._mdlTestInfo.F_TEST_AIM = txtTestAim.Text.Trim(); //委托单位 this._mdlTestInfo.F_TASK_DEPUTE_UNIT = txtDeputeUnit.Text.Trim(); //联系人 this._mdlTestInfo.F_CONTACT = txtContact.Text.Trim(); //电话 this._mdlTestInfo.F_PHONE = txtPhone.Text.Trim(); //email this._mdlTestInfo.F_EMAIL = txtEmail.Text.Trim(); //负责人 this._mdlTestInfo.F_TEST_CHARGE = txtCharge.Text.Trim(); //委托日期 this._mdlTestInfo.F_TASK_DEPUTE_DATE = dateEdit_task.DateTime; //样品系列、样品类别、序列试验目前界面不显示,数据库中填写下面的默认值。 //样品系列 this._mdlTestInfo.F_TEST_SERIES = ""; //样品类别 this._mdlTestInfo.F_SAMPLE_TYPE = ""; //序列试验 this._mdlTestInfo.F_SEQUENCE_TEST = 0; //试验任务状态;新增试验任务,状态为10:等待试验开始 this._mdlTestInfo.F_TEST_STATUS = 10; //创建时间 if (operType == 1) { this._mdlTestInfo.F_CREATE_TIME = DateTime.Now; } //操作员 this._mdlTestInfo.F_OPERATOR_ID = AppGlobal.GUserId; //操作时间 this._mdlTestInfo.F_OPERATIONTIME = DateTime.Now; //是否删除 this._mdlTestInfo.F_DEL = 0; }
public int InsertTestBaseInfo(DataSet dsTestInfo, string now_taskId) { int intResult = 0; AccessDBClass myAccessdb = new AccessDBClass("DataFile/" + now_taskId + ".mdb"); if (dsTestInfo != null) { ModelTEST_INFO mdlTestBaseInfo = new ModelTEST_INFO(); //试验任务编号 mdlTestBaseInfo.F_TEST_TASK_ID = dsTestInfo.Tables[0].Rows[0]["F_TEST_TASK_ID"].ToString(); //检测项目 mdlTestBaseInfo.F_TEST_ITEM = dsTestInfo.Tables[0].Rows[0]["F_TEST_ITEM"].ToString(); //规格型号 mdlTestBaseInfo.F_TEST_MODEL = dsTestInfo.Tables[0].Rows[0]["F_TEST_MODEL"].ToString(); //检测标准 mdlTestBaseInfo.F_TEST_STANDARD = dsTestInfo.Tables[0].Rows[0]["F_TEST_STANDARD"].ToString(); //检测性质 mdlTestBaseInfo.F_TEST_PROPERTY = dsTestInfo.Tables[0].Rows[0]["F_TEST_PROPERTY"].ToString(); //检测目的 mdlTestBaseInfo.F_TEST_AIM = dsTestInfo.Tables[0].Rows[0]["F_TEST_AIM"].ToString(); //委托单位 mdlTestBaseInfo.F_TASK_DEPUTE_UNIT = dsTestInfo.Tables[0].Rows[0]["F_TASK_DEPUTE_UNIT"].ToString(); //联系人 mdlTestBaseInfo.F_CONTACT = dsTestInfo.Tables[0].Rows[0]["F_CONTACT"].ToString(); //电话 mdlTestBaseInfo.F_PHONE = dsTestInfo.Tables[0].Rows[0]["F_PHONE"].ToString(); //email mdlTestBaseInfo.F_EMAIL = dsTestInfo.Tables[0].Rows[0]["F_EMAIL"].ToString(); //负责人 mdlTestBaseInfo.F_TEST_CHARGE = dsTestInfo.Tables[0].Rows[0]["F_TEST_CHARGE"].ToString(); //委托日期 mdlTestBaseInfo.F_TASK_DEPUTE_DATE = Convert.ToDateTime(dsTestInfo.Tables[0].Rows[0]["F_TASK_DEPUTE_DATE"].ToString()); //样品系列 //mdlTestBaseInfo.F_TEST_SERIES = dsTestInfo.Tables[0].Rows[0]["F_TEST_SERIES"].ToString(); mdlTestBaseInfo.F_TEST_SERIES = " "; //样品类别 //mdlTestBaseInfo.F_SAMPLE_TYPE = dsTestInfo.Tables[0].Rows[0]["F_SAMPLE_TYPE"].ToString(); mdlTestBaseInfo.F_SAMPLE_TYPE = " "; //序列试验 mdlTestBaseInfo.F_SEQUENCE_TEST = Convert.ToInt16(dsTestInfo.Tables[0].Rows[0]["F_SEQUENCE_TEST"].ToString()); //试验状态 mdlTestBaseInfo.F_TEST_STATUS = Convert.ToInt16(dsTestInfo.Tables[0].Rows[0]["F_TEST_STATUS"].ToString()); //创建时间 mdlTestBaseInfo.F_CREATE_TIME = Convert.ToDateTime(dsTestInfo.Tables[0].Rows[0]["F_CREATE_TIME"].ToString()); //操作员 mdlTestBaseInfo.F_OPERATOR_ID = dsTestInfo.Tables[0].Rows[0]["F_OPERATOR_ID"].ToString(); //操作时间 mdlTestBaseInfo.F_OPERATIONTIME = Convert.ToDateTime(dsTestInfo.Tables[0].Rows[0]["F_OPERATIONTIME"].ToString()); //是否删除 mdlTestBaseInfo.F_DEL = Convert.ToInt16(dsTestInfo.Tables[0].Rows[0]["F_DEL"].ToString()); string strSql = "insert into T_TEST_INFO(F_TEST_TASK_ID,F_TEST_ITEM,F_TEST_MODEL"; strSql = strSql + ",F_TEST_STANDARD,F_TEST_PROPERTY,F_TEST_AIM"; strSql = strSql + ",F_TASK_DEPUTE_UNIT,F_CONTACT,F_PHONE"; strSql = strSql + ",F_EMAIL,F_TEST_CHARGE,F_TASK_DEPUTE_DATE"; strSql = strSql + ",F_TEST_SERIES,F_SAMPLE_TYPE,F_SEQUENCE_TEST"; strSql = strSql + ",F_TEST_STATUS,F_CREATE_TIME,F_OPERATOR_ID"; strSql = strSql + ",F_OPERATIONTIME,F_DEL)"; strSql = strSql + " values(@F_TEST_TASK_ID,@F_TEST_ITEM,@F_TEST_MODEL "; strSql = strSql + ",@F_TEST_STANDARD,@F_TEST_PROPERTY,@F_TEST_AIM"; strSql = strSql + ",@F_TASK_DEPUTE_UNIT,@F_CONTACT,@F_PHONE"; strSql = strSql + ",@F_EMAIL,@F_TEST_CHARGE,@F_TASK_DEPUTE_DATE"; strSql = strSql + ",@F_TEST_SERIES,@F_SAMPLE_TYPE,@F_SEQUENCE_TEST"; strSql = strSql + ",@F_TEST_STATUS,@F_CREATE_TIME,@F_OPERATOR_ID"; strSql = strSql + ",@F_OPERATIONTIME,@F_DEL)"; OleDbParameter[] prams = { new OleDbParameter("@F_TEST_TASK_ID", mdlTestBaseInfo.F_TEST_TASK_ID), new OleDbParameter("@F_TEST_ITEM", mdlTestBaseInfo.F_TEST_ITEM), new OleDbParameter("@F_TEST_MODEL", mdlTestBaseInfo.F_TEST_MODEL), new OleDbParameter("@F_TEST_STANDARD", mdlTestBaseInfo.F_TEST_STANDARD), new OleDbParameter("@F_TEST_PROPERTY", mdlTestBaseInfo.F_TEST_PROPERTY), new OleDbParameter("@F_TEST_AIM", mdlTestBaseInfo.F_TEST_AIM), new OleDbParameter("@F_TASK_DEPUTE_UNIT", mdlTestBaseInfo.F_TASK_DEPUTE_UNIT), new OleDbParameter("@F_CONTACT", mdlTestBaseInfo.F_CONTACT), new OleDbParameter("@F_PHONE", mdlTestBaseInfo.F_PHONE), new OleDbParameter("@F_EMAIL", mdlTestBaseInfo.F_EMAIL), new OleDbParameter("@F_TEST_CHARGE", mdlTestBaseInfo.F_TEST_CHARGE), new OleDbParameter("@F_TASK_DEPUTE_DATE", mdlTestBaseInfo.F_TASK_DEPUTE_DATE), new OleDbParameter("@F_TEST_SERIES", mdlTestBaseInfo.F_TEST_SERIES), new OleDbParameter("@F_SAMPLE_TYPE", mdlTestBaseInfo.F_SAMPLE_TYPE), new OleDbParameter("@F_SEQUENCE_TEST", mdlTestBaseInfo.F_SEQUENCE_TEST), new OleDbParameter("@F_TEST_STATUS", mdlTestBaseInfo.F_TEST_STATUS), new OleDbParameter("@F_CREATE_TIME", mdlTestBaseInfo.F_CREATE_TIME), new OleDbParameter("@F_OPERATOR_ID", mdlTestBaseInfo.F_OPERATOR_ID), new OleDbParameter("@F_OPERATIONTIME", mdlTestBaseInfo.F_OPERATIONTIME), new OleDbParameter("@F_DEL", mdlTestBaseInfo.F_DEL) }; bool insert_status = myAccessdb.ExecuteSQLNonquery(strSql, prams); } return(intResult); }