/// <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);
}
