/// <summary> /// 提交运行记录转储记录 /// </summary> public void SubMitRunRecordInfo(RunRecordFileMain runRecordFileMain) { SqlConnection connection = new SqlConnection(); SqlTransaction transaction = null; SqlCommand command = new SqlCommand(); command.Connection = connection; connection.ConnectionString = SqlHelper.ConnString; try { connection.Open(); transaction = connection.BeginTransaction(); command.Transaction = transaction; string strGUID = AddRunRecrod(command, runRecordFileMain); for (int i = 0; i < runRecordFileMain.RunRecordFileDetailList.Count; i++) { runRecordFileMain.RunRecordFileDetailList[i].strRecordGUID = strGUID; AddRecordFileDetail(command, runRecordFileMain.RunRecordFileDetailList[i]); } transaction.Commit(); } catch (Exception ex) { LogClass.log("Interface.SubMitRunRecordInfo:" + ex.Message); throw ex; } }
/// <summary> /// 添加数据 /// </summary> public string AddRunRecrod(SqlCommand command, RunRecordFileMain model) { StringBuilder strSql = new StringBuilder(); strSql.Append("DECLARE @ROWGUID_EndWork_RunRecrod_Main TABLE(ID uniqueidentifier) "); strSql.Append("insert into Tab_EndWork_RunRecrod_Main "); strSql.Append("(dtUploadTime,strPlanGUID,dtPlanChuQinTime,strTrainNo,strTrainNum,strTrainTypeName,strTrainmanNumber1,strTrainmanName1,strTrainmanNumber2,strTrainmanName2,strTrainmanNumber3,strTrainmanName3,strTrainmanNumber4,strTrainmanName4,strCardNumber,strSiteNumber,strSiteName)"); strSql.Append("OUTPUT INSERTED.STRGUID INTO @ROWGUID_EndWork_RunRecrod_Main "); strSql.Append("values(@dtUploadTime,@strPlanGUID,@dtPlanChuQinTime,@strTrainNo,@strTrainNum,@strTrainTypeName,@strTrainmanNumber1,@strTrainmanName1,@strTrainmanNumber2,@strTrainmanName2,@strTrainmanNumber3,@strTrainmanName3,@strTrainmanNumber4,@strTrainmanName4,@strCardNumber,@strSiteNumber,@strSiteName)"); strSql.Append(";SELECT ID FROM @ROWGUID_EndWork_RunRecrod_Main"); SqlParameter[] parameters = { new SqlParameter("@dtUploadTime", model.dtUploadTime), new SqlParameter("@strPlanGUID", model.strPlanGUID), new SqlParameter("@dtPlanChuQinTime", model.dtPlanChuQinTime), new SqlParameter("@strTrainNo", model.strTrainNo), new SqlParameter("@strTrainNum", model.strTrainNum), new SqlParameter("@strTrainTypeName", model.strTrainTypeName), new SqlParameter("@strTrainmanNumber1", model.strTrainmanNumber1), new SqlParameter("@strTrainmanName1", model.strTrainmanName1), new SqlParameter("@strTrainmanNumber2", model.strTrainmanNumber2), new SqlParameter("@strTrainmanName2", model.strTrainmanName2), new SqlParameter("@strTrainmanNumber3", model.strTrainmanNumber3), new SqlParameter("@strTrainmanName3", model.strTrainmanName3), new SqlParameter("@strTrainmanNumber4", model.strTrainmanNumber4), new SqlParameter("@strTrainmanName4", model.strTrainmanName4), new SqlParameter("@strCardNumber", model.strCardNumber), new SqlParameter("@strSiteNumber", model.strSiteNumber), new SqlParameter("@strSiteName", model.strSiteName), }; command.CommandText = strSql.ToString(); command.Parameters.Clear(); command.Parameters.AddRange(parameters); return(ObjectConvertClass.static_ext_string(command.ExecuteScalar())); }