/// <summary>
/// 增加一条数据
/// </summary>
public bool Add_Trans(Mod_TQC_PHYSICS_RESULT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TQC_PHYSICS_RESULT(");
strSql.Append("C_PHYSICS_GROUP_ID,C_PRESENT_SAMPLES_ID,C_CHARACTER_ID,C_CHARACTER_CODE,C_CHARACTER_NAME,C_VALUE,N_STATUS,C_REMARK,C_EMP_ID,N_SPLIT,N_TYPE,C_CHECK_STATE,C_TICK_NO,C_GROUP)");
strSql.Append(" values (");
strSql.Append(":C_PHYSICS_GROUP_ID,:C_PRESENT_SAMPLES_ID,:C_CHARACTER_ID,:C_CHARACTER_CODE,:C_CHARACTER_NAME,:C_VALUE,:N_STATUS,:C_REMARK,:C_EMP_ID,:N_SPLIT,:N_TYPE,:C_CHECK_STATE,:C_TICK_NO,:C_GROUP)");
OracleParameter[] parameters =
{
new OracleParameter(":C_PHYSICS_GROUP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PRESENT_SAMPLES_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CHARACTER_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CHARACTER_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CHARACTER_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_VALUE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_SPLIT", OracleDbType.Decimal, 1),
new OracleParameter(":N_TYPE", OracleDbType.Decimal, 1),
new OracleParameter(":C_CHECK_STATE", OracleDbType.Varchar2, 10),
new OracleParameter(":C_TICK_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_GROUP", OracleDbType.Varchar2, 10)
};
parameters[0].Value = model.C_PHYSICS_GROUP_ID;
parameters[1].Value = model.C_PRESENT_SAMPLES_ID;
parameters[2].Value = model.C_CHARACTER_ID;
parameters[3].Value = model.C_CHARACTER_CODE;
parameters[4].Value = model.C_CHARACTER_NAME;
parameters[5].Value = model.C_VALUE;
parameters[6].Value = model.N_STATUS;
parameters[7].Value = model.C_REMARK;
parameters[8].Value = model.C_EMP_ID;
parameters[9].Value = model.N_SPLIT;
parameters[10].Value = model.N_TYPE;
parameters[11].Value = model.C_CHECK_STATE;
parameters[12].Value = model.C_TICK_NO;
parameters[13].Value = model.C_GROUP;
int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 复制
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_Copy_Click(object sender, EventArgs e)
{
int[] number_tick_no = gv_Copy.GetSelectedRows();//获取选中行号数组；
if (number_tick_no.Length == 0)
{
MessageBox.Show("请选择需要确认的信息！");
return;
}
DataRow dr = this.gv_ZYXX.GetDataRow(this.gv_ZYXX.FocusedRowHandle);
DataTable dt = ((DataView)gv_ZYXX.DataSource).ToTable();
for (int i = 0; i < number_tick_no.Length; i++)
{
DataRow dr_Num = gv_Copy.GetDataRow(number_tick_no[i]);
Mod_TQC_PHYSICS_RESULT_MAIN mod = bllTqcPhyResultMain.GetModel(dr_Num["取样主表主键"].ToString());
mod.C_EQ_NAME = dr["设备名称"].ToString();
mod.C_TEMP = dr["温度"].ToString();
mod.C_HUMIDITY = dr["湿度"].ToString();
mod.N_IS_LR = 1;
bllTqcPhyResultMain.Update(mod);
for (int s = 0; s < dt.Rows.Count; s++)
{
Mod_TQC_PHYSICS_RESULT modResult = new Mod_TQC_PHYSICS_RESULT();
modResult.C_PHYSICS_GROUP_ID = dt.Rows[i]["C_PHYSICS_GROUP_ID"].ToString();
modResult.C_PRESENT_SAMPLES_ID = dr_Num["取样主表主键"].ToString();
modResult.C_CHARACTER_ID = dt.Rows[i]["C_CHARACTER_ID"].ToString();
modResult.C_CHARACTER_CODE = dt.Rows[i]["C_CODE"].ToString();
modResult.C_CHARACTER_NAME = dt.Rows[i]["C_NAME"].ToString();
modResult.C_VALUE = dt.Rows[i]["C_VALUE"].ToString();
modResult.C_EMP_ID = RV.UI.UserInfo.UserID;
modResult.D_MOD_DT = RV.UI.ServerTime.timeNow();
modResult.N_SPLIT = 0;
modResult.N_TYPE = 1;
modResult.C_CHECK_STATE = "0";
modResult.C_TICK_NO = dr_Num["钩号"].ToString();
bllTqcPhysicsResult.Add(modResult);
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TQC_PHYSICS_RESULT GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_PHYSICS_GROUP_ID,C_PRESENT_SAMPLES_ID,C_CHARACTER_ID,C_CHARACTER_CODE,C_CHARACTER_NAME,C_VALUE,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT,N_SPLIT,N_TYPE,C_CHECK_STATE,C_TICK_NO,C_GROUP from TQC_PHYSICS_RESULT ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TQC_PHYSICS_RESULT model = new Mod_TQC_PHYSICS_RESULT();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TQC_PHYSICS_RESULT DataRowToModel(DataRow row)
{
Mod_TQC_PHYSICS_RESULT model = new Mod_TQC_PHYSICS_RESULT();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["C_PHYSICS_GROUP_ID"] != null)
{
model.C_PHYSICS_GROUP_ID = row["C_PHYSICS_GROUP_ID"].ToString();
}
if (row["C_PRESENT_SAMPLES_ID"] != null)
{
model.C_PRESENT_SAMPLES_ID = row["C_PRESENT_SAMPLES_ID"].ToString();
}
if (row["C_CHARACTER_ID"] != null)
{
model.C_CHARACTER_ID = row["C_CHARACTER_ID"].ToString();
}
if (row["C_CHARACTER_CODE"] != null)
{
model.C_CHARACTER_CODE = row["C_CHARACTER_CODE"].ToString();
}
if (row["C_CHARACTER_NAME"] != null)
{
model.C_CHARACTER_NAME = row["C_CHARACTER_NAME"].ToString();
}
if (row["C_VALUE"] != null)
{
model.C_VALUE = row["C_VALUE"].ToString();
}
if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "")
{
model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString());
}
if (row["C_REMARK"] != null)
{
model.C_REMARK = row["C_REMARK"].ToString();
}
if (row["C_EMP_ID"] != null)
{
model.C_EMP_ID = row["C_EMP_ID"].ToString();
}
if (row["D_MOD_DT"] != null && row["D_MOD_DT"].ToString() != "")
{
model.D_MOD_DT = DateTime.Parse(row["D_MOD_DT"].ToString());
}
if (row["N_SPLIT"] != null && row["N_SPLIT"].ToString() != "")
{
model.N_STATUS = decimal.Parse(row["N_SPLIT"].ToString());
}
if (row["N_TYPE"] != null && row["N_TYPE"].ToString() != "")
{
model.N_TYPE = decimal.Parse(row["N_TYPE"].ToString());
}
if (row["C_CHECK_STATE"] != null)
{
model.C_CHECK_STATE = row["C_CHECK_STATE"].ToString();
}
if (row["C_TICK_NO"] != null)
{
model.C_TICK_NO = row["C_TICK_NO"].ToString();
}
if (row["C_GROUP"] != null)
{
model.C_GROUP = row["C_GROUP"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TQC_PHYSICS_RESULT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TQC_PHYSICS_RESULT set ");
strSql.Append("C_PHYSICS_GROUP_ID=:C_PHYSICS_GROUP_ID,");
strSql.Append("C_PRESENT_SAMPLES_ID=:C_PRESENT_SAMPLES_ID,");
strSql.Append("C_CHARACTER_ID=:C_CHARACTER_ID,");
strSql.Append("C_CHARACTER_CODE=:C_CHARACTER_CODE,");
strSql.Append("C_CHARACTER_NAME=:C_CHARACTER_NAME,");
strSql.Append("C_VALUE=:C_VALUE,");
strSql.Append("N_STATUS=:N_STATUS,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("D_MOD_DT=:D_MOD_DT,");
strSql.Append("N_SPLIT=:N_SPLIT,");
strSql.Append("N_TYPE=:N_TYPE,");
strSql.Append("C_CHECK_STATE=:C_CHECK_STATE,");
strSql.Append("C_TICK_NO=:C_TICK_NO,");
strSql.Append("C_GROUP=:C_GROUP");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_PHYSICS_GROUP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PRESENT_SAMPLES_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CHARACTER_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CHARACTER_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CHARACTER_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_VALUE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":N_SPLIT", OracleDbType.Decimal, 1),
new OracleParameter(":N_TYPE", OracleDbType.Decimal, 1),
new OracleParameter(":C_CHECK_STATE", OracleDbType.Varchar2, 10),
new OracleParameter(":C_TICK_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_GROUP", OracleDbType.Varchar2, 10),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_PHYSICS_GROUP_ID;
parameters[1].Value = model.C_PRESENT_SAMPLES_ID;
parameters[2].Value = model.C_CHARACTER_ID;
parameters[3].Value = model.C_CHARACTER_CODE;
parameters[4].Value = model.C_CHARACTER_NAME;
parameters[5].Value = model.C_VALUE;
parameters[6].Value = model.N_STATUS;
parameters[7].Value = model.C_REMARK;
parameters[8].Value = model.C_EMP_ID;
parameters[9].Value = model.D_MOD_DT;
parameters[10].Value = model.N_SPLIT;
parameters[11].Value = model.N_TYPE;
parameters[12].Value = model.C_CHECK_STATE;
parameters[13].Value = model.C_TICK_NO;
parameters[14].Value = model.C_GROUP;
parameters[15].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 修改性能值
/// </summary>
/// <returns></returns>
public string Edit_Result(DataRow dr, DataTable dt_result, string str_PHYSICS_GROUP_ID, string strSB, string strWD, string strSD, string strBC, string strBZ, string strSHR)
{
try
{
string result = "1";
TransactionHelper.BeginTransaction();
string strUserID = RV.UI.UserInfo.userID;
DateTime time = RV.UI.ServerTime.timeNow();
Dal_TQC_PHYSICS_RESULT_MAIN dalTqcPhyResultMain = new Dal_TQC_PHYSICS_RESULT_MAIN();
Dal_TQC_PHYSICS_RESULT_LOG dalResultLog = new Dal_TQC_PHYSICS_RESULT_LOG();
Dal_TQC_COMPRE_ROLL dalTqcCompreRoll = new Dal_TQC_COMPRE_ROLL();
Dal_TQB_PHYSICS_GROUP dalGroup = new Dal_TQB_PHYSICS_GROUP();
if (dr != null)
{
string C_PRESENT_SAMPLES_ID = dr["取样主表主键"].ToString();
string strCheckState = dr["检验状态"].ToString();
if (strCheckState == "初检")
{
strCheckState = "0";
}
else if (strCheckState == "复检")
{
strCheckState = "1";
}
string strCode = dalGroup.Get_Code(str_PHYSICS_GROUP_ID);
Mod_TQC_PHYSICS_RESULT_MAIN mod = dalTqcPhyResultMain.GetModel(C_PRESENT_SAMPLES_ID);
DataTable dt_DB = new DataTable();
if (strCode == "R01")
{
dt_DB = dalTqcPhyResultMain.Get_DB_List(dr["批号"].ToString(), str_PHYSICS_GROUP_ID, strCheckState, mod.C_IS_PD).Tables[0];
}
else
{
dt_DB = dalTqcPhyResultMain.Get_DB_List(C_PRESENT_SAMPLES_ID).Tables[0];
}
for (int mm = 0; mm < dt_DB.Rows.Count; mm++)
{
Mod_TQC_PHYSICS_RESULT_MAIN mod_Main = dalTqcPhyResultMain.GetModel(dt_DB.Rows[mm]["C_ID"].ToString());
if (mod_Main != null)
{
mod_Main.C_EQ_NAME = strSB;
mod_Main.C_TEMP = strWD;
mod_Main.C_HUMIDITY = strSD;
mod_Main.N_IS_LR = 1;
mod_Main.C_BC = strBC;
mod_Main.C_BZ = strBZ;
mod_Main.C_CHECK_USER = strSHR;
if (!dalTqcPhyResultMain.Update_Trans(mod_Main))
{
TransactionHelper.RollBack();
return("保存设备信息失败！");
}
}
int num_Edit = dalResultLog.Get_Max_EditNum(str_PHYSICS_GROUP_ID, dt_DB.Rows[mm]["C_ID"].ToString());//修改次数
num_Edit++;
DataTable dt_Old = dal.Get_XNList(strCode, dt_DB.Rows[mm]["C_ID"].ToString()).Tables[0];
for (int i = 0; i < dt_Old.Rows.Count; i++)
{
int strType = 0;
if (dt_Old.Rows[i]["C_CODE"].ToString().Contains("000GCL"))
{
strType = 0;
}
else
{
strType = 1;
}
if (!string.IsNullOrEmpty(dt_Old.Rows[i]["C_VALUE"].ToString()))
{
Mod_TQC_PHYSICS_RESULT_LOG modResult_Log = new Mod_TQC_PHYSICS_RESULT_LOG();
modResult_Log.C_PHYSICS_GROUP_ID = str_PHYSICS_GROUP_ID;
modResult_Log.C_PRESENT_SAMPLES_ID = dt_DB.Rows[mm]["C_ID"].ToString();
modResult_Log.C_CHARACTER_ID = dt_Old.Rows[i]["C_CHARACTER_ID"].ToString();
modResult_Log.C_CHARACTER_CODE = dt_Old.Rows[i]["C_CODE"].ToString();
modResult_Log.C_CHARACTER_NAME = dt_Old.Rows[i]["C_NAME"].ToString();
modResult_Log.C_VALUE = dt_Old.Rows[i]["C_VALUE"].ToString();
modResult_Log.C_EMP_ID = strUserID;
modResult_Log.N_TYPE = strType;
modResult_Log.C_TICK_NO = dr["钩号"].ToString();
modResult_Log.C_CHECK_STATE = strCheckState;
modResult_Log.C_EDIT_NUM = num_Edit.ToString();
if (!dalResultLog.Add_Trans(modResult_Log))
{
TransactionHelper.RollBack();
return("保存修改记录出错！");
}
}
}
dal.Delete_Trans(str_PHYSICS_GROUP_ID, dt_DB.Rows[mm]["C_ID"].ToString());
for (int k = 0; k < dt_result.Rows.Count; k++)
{
int strType = 0;
if (dt_result.Rows[k]["C_CODE"].ToString().Contains("000GCL"))
{
strType = 0;
}
else
{
strType = 1;
}
if (dt_result.Rows[k]["C_VALUE"].ToString() != "")
{
Mod_TQC_PHYSICS_RESULT modResult = new Mod_TQC_PHYSICS_RESULT();
modResult.C_PHYSICS_GROUP_ID = str_PHYSICS_GROUP_ID;
modResult.C_PRESENT_SAMPLES_ID = dt_DB.Rows[mm]["C_ID"].ToString();
modResult.C_CHARACTER_ID = dt_result.Rows[k]["C_CHARACTER_ID"].ToString();
modResult.C_CHARACTER_CODE = dt_result.Rows[k]["C_CODE"].ToString();
modResult.C_CHARACTER_NAME = dt_result.Rows[k]["C_NAME"].ToString();
modResult.C_VALUE = dt_result.Rows[k]["C_VALUE"].ToString();
modResult.C_EMP_ID = strUserID;
modResult.N_TYPE = strType;
modResult.C_TICK_NO = dr["钩号"].ToString();
modResult.C_CHECK_STATE = strCheckState;
if (!dal.Add_Trans(modResult))
{
TransactionHelper.RollBack();
return("修改数据出错！");
}
}
}
}
}
TransactionHelper.Commit();
dalTqcCompreRoll.JUDGE_ROLL_BATCH(dr["批号"].ToString());
return(result);
}
catch (Exception ex)
{
TransactionHelper.RollBack();
return(ex.Message);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TQC_PHYSICS_RESULT model)
{
return(dal.Update(model));
}
/// <summary>
/// 保存性能值
/// </summary>
/// <returns></returns>
public string Save_Result(DataTable dt_result, string strPhyCode)
{
try
{
string result = "1";
TransactionHelper.BeginTransaction();
string strUserID = RV.UI.UserInfo.userID;
DateTime time = RV.UI.ServerTime.timeNow();
Dal_TQB_PHYSICS_GROUP daltqbPhysicsGroup = new Dal_TQB_PHYSICS_GROUP();
Dal_TQC_PHYSICS_RESULT_MAIN dalResultMain = new Dal_TQC_PHYSICS_RESULT_MAIN();
Mod_TQC_PHYSICS_RESULT model;
DataTable dt_Character = dal.Get_Character_List(strPhyCode).Tables[0];
if (dt_Character.Rows.Count == 0)
{
TransactionHelper.RollBack();
return("性能基础数据有误,保存失败！");
}
string str_PHYSICS_GROUP_ID = dt_Character.Rows[0]["C_PHYSICS_GROUP_ID"].ToString();
for (int irow = 0; irow < dt_result.Rows.Count; irow++)
{
string val = dt_result.Rows[irow]["chk"].ToString();
if (val == "False")
{
continue;
}
string C_PRESENT_SAMPLES_ID = dt_result.Rows[irow]["取样主表主键"].ToString();
dal.Delete_Trans(str_PHYSICS_GROUP_ID, C_PRESENT_SAMPLES_ID);
Mod_TQC_PHYSICS_RESULT_MAIN modelMain = dalResultMain.GetModel(C_PRESENT_SAMPLES_ID);
if (modelMain != null)
{
modelMain.N_IS_LR = 1;
modelMain.C_EQ_NAME = dt_result.Rows[irow]["设备信息"].ToString();
if (!dalResultMain.Update_Trans(modelMain))
{
TransactionHelper.RollBack();
return("保存失败！");
}
}
for (int icol = 13; icol < dt_result.Columns.Count; icol++)
{
int iType = 2;
if (dt_Character.Rows[icol - 13]["C_CODE"].ToString().Contains("000GCL"))
{
iType = 0;
}
else
{
iType = 1;
}
if (!string.IsNullOrEmpty(dt_result.Rows[irow][icol].ToString()))
{
model = new Mod_TQC_PHYSICS_RESULT();
model.C_PHYSICS_GROUP_ID = str_PHYSICS_GROUP_ID; //物理分组表主键
model.C_PRESENT_SAMPLES_ID = C_PRESENT_SAMPLES_ID; //tqc_physics_result_main主键
model.C_CHARACTER_ID = dt_Character.Rows[icol - 13]["C_CHARACTER_ID"].ToString(); //检验基础数据表主键
model.C_CHARACTER_CODE = dt_Character.Rows[icol - 13]["C_CODE"].ToString(); //性能代码
model.C_CHARACTER_NAME = dt_Character.Rows[icol - 13]["C_NAME"].ToString(); //性能名称
model.C_VALUE = dt_result.Rows[irow][icol].ToString(); //性能值
model.C_EMP_ID = strUserID; //录入人
model.N_TYPE = iType; //0过程量；1检验量
model.C_CHECK_STATE = dt_result.Rows[irow]["检验状态"].ToString() == "初检" ? "0" : "1"; // 状态；0-初检；1-复检；2-评审
model.C_TICK_NO = dt_result.Rows[irow]["钩号"].ToString(); //钩号
if (!dal.Add_Trans(model))
{
TransactionHelper.RollBack();
return("保存失败！");
}
}
}
}
TransactionHelper.Commit();
return(result);
}
catch (Exception ex)
{
TransactionHelper.RollBack();
return(ex.Message);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TQC_PHYSICS_RESULT model)
{
return(dal.Add(model));
}
/// <summary>
/// 保存性能值
/// </summary>
/// <returns></returns>
public string Save_Result_Old(DataRow dr, DataTable dt_result, string strPhyCode, string strSB, string strWD, string strSD, string strBC, string strBZ, string strSHR)
{
try
{
string result = "1";
TransactionHelper.BeginTransaction();
Dal_TQC_PHYSICS_RESULT_MAIN dalTqcPhyResultMain = new Dal_TQC_PHYSICS_RESULT_MAIN();
Dal_TQB_PHYSICS_GROUP dalTqbPhysicsGroup = new Dal_TQB_PHYSICS_GROUP();
string strUserID = RV.UI.UserInfo.userID;
DateTime time = RV.UI.ServerTime.timeNow();
string C_PRESENT_SAMPLES_ID = dr["取样主表主键"].ToString();
Mod_TQC_PHYSICS_RESULT_MAIN mod = dalTqcPhyResultMain.GetModel(C_PRESENT_SAMPLES_ID);
string strCheckState = dr["检验状态"].ToString();
if (strCheckState == "初检")
{
strCheckState = "0";
}
else if (strCheckState == "复检")
{
strCheckState = "1";
}
string str_PHYSICS_GROUP_ID = dalTqbPhysicsGroup.Get_ID(strPhyCode);
DataTable dt_DB = new DataTable();
if (strPhyCode == "R01")
{
dt_DB = dalTqcPhyResultMain.Get_DB_List(dr["批号"].ToString(), str_PHYSICS_GROUP_ID, strCheckState, mod.C_IS_PD).Tables[0];
}
else
{
dt_DB = dalTqcPhyResultMain.Get_DB_List(C_PRESENT_SAMPLES_ID).Tables[0];
}
for (int i = 0; i < dt_DB.Rows.Count; i++)
{
Mod_TQC_PHYSICS_RESULT_MAIN mod_Main = dalTqcPhyResultMain.GetModel(dt_DB.Rows[i]["C_ID"].ToString());
if (mod_Main != null)
{
mod_Main.C_EQ_NAME = strSB;
mod_Main.C_TEMP = strWD;
mod_Main.C_HUMIDITY = strSD;
mod_Main.N_IS_LR = 1;
mod_Main.C_BC = strBC;
mod_Main.C_BZ = strBZ;
mod_Main.C_CHECK_USER = strSHR;
if (!dalTqcPhyResultMain.Update_Trans(mod_Main))
{
TransactionHelper.RollBack();
return("保存设备信息失败！");
}
}
dal.Delete_Trans(str_PHYSICS_GROUP_ID, dt_DB.Rows[i]["C_ID"].ToString());
for (int mm = 0; mm < dt_result.Rows.Count; mm++)
{
if (!string.IsNullOrEmpty(dt_result.Rows[mm]["C_VALUE"].ToString()))
{
int i_Type = 0;
if (dt_result.Rows[mm]["C_CODE"].ToString().Contains("000GCL"))
{
i_Type = 0;
}
else
{
i_Type = 1;
}
Mod_TQC_PHYSICS_RESULT modResult = new Mod_TQC_PHYSICS_RESULT();
modResult.C_PHYSICS_GROUP_ID = str_PHYSICS_GROUP_ID;
modResult.C_PRESENT_SAMPLES_ID = dt_DB.Rows[i]["C_ID"].ToString();
modResult.C_CHARACTER_ID = dt_result.Rows[mm]["C_CHARACTER_ID"].ToString();
modResult.C_CHARACTER_CODE = dt_result.Rows[mm]["C_CODE"].ToString();
modResult.C_CHARACTER_NAME = dt_result.Rows[mm]["C_NAME"].ToString();
modResult.C_VALUE = dt_result.Rows[mm]["C_VALUE"].ToString();
modResult.C_EMP_ID = strUserID;
modResult.D_MOD_DT = time;
modResult.N_SPLIT = 0;
modResult.N_TYPE = i_Type;
modResult.C_CHECK_STATE = strCheckState;
modResult.C_TICK_NO = dt_DB.Rows[i]["C_TICK_NO"].ToString();
if (!dal.Add_Trans(modResult))
{
TransactionHelper.RollBack();
return("保存结果失败！");
}
}
}
}
TransactionHelper.Commit();
return(result);
}
catch (Exception ex)
{
TransactionHelper.RollBack();
return(ex.Message);
}
}
