/// <summary> /// 获得数据List /// </summary> public RunRecordFileMainList GetDataList(RunRecordMainQueryCondition QueryCondition) { SqlParameter[] sqlParams; StringBuilder strSqlOption = new StringBuilder(); QueryCondition.OutPut(out strSqlOption, out sqlParams); StringBuilder strSql = new StringBuilder(); if (QueryCondition.page == 0) { strSql.Append("select * "); strSql.Append(" FROM Tab_EndWork_RunRecrod_Main where 1=1 " + strSqlOption.ToString()); } else { strSql.Append(@"select top " + QueryCondition.rows.ToString() + " * from Tab_EndWork_RunRecrod_Main where 1 = 1 " + strSqlOption.ToString() + " and nID not in ( select top " + (QueryCondition.page - 1) * QueryCondition.rows + " nID from Tab_EndWork_RunRecrod_Main where 1=1 " + strSqlOption.ToString() + " order by nID desc) order by nID desc"); } DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0]; RunRecordFileMainList list = new RunRecordFileMainList(); foreach (DataRow dr in dt.Rows) { RunRecordFileMain _EndWork_RunRecrod_Main = new RunRecordFileMain(); DataRowToModel(_EndWork_RunRecrod_Main, dr); list.Add(_EndWork_RunRecrod_Main); } return(list); }
/// <summary> /// 获得一个实体对象 /// </summary> public RunRecordFileMain GetModel(RunRecordMainQueryCondition QueryCondition) { SqlParameter[] sqlParams; StringBuilder strSqlOption = new StringBuilder(); QueryCondition.OutPut(out strSqlOption, out sqlParams); StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * "); strSql.Append(" FROM Tab_EndWork_RunRecrod_Main where 1=1 " + strSqlOption.ToString()); DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0]; RunRecordFileMain _EndWork_RunRecrod_Main = null; if (dt.Rows.Count > 0) { _EndWork_RunRecrod_Main = new RunRecordFileMain(); DataRowToModel(_EndWork_RunRecrod_Main, dt.Rows[0]); } return(_EndWork_RunRecrod_Main); }
/// <summary> /// 读取DataRow数据到Model中 /// </summary> private void DataRowToModel(RunRecordFileMain model, DataRow dr) { model.nID = ObjectConvertClass.static_ext_int(dr["nID"]); model.dtUploadTime = ObjectConvertClass.static_ext_date(dr["dtUploadTime"]); model.strPlanGUID = ObjectConvertClass.static_ext_string(dr["strPlanGUID"]); model.dtPlanChuQinTime = ObjectConvertClass.static_ext_date(dr["dtPlanChuQinTime"]); model.strTrainNo = ObjectConvertClass.static_ext_string(dr["strTrainNo"]); model.strTrainNum = ObjectConvertClass.static_ext_string(dr["strTrainNum"]); model.strTrainTypeName = ObjectConvertClass.static_ext_string(dr["strTrainTypeName"]); model.strTrainmanNumber1 = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber1"]); model.strTrainmanName1 = ObjectConvertClass.static_ext_string(dr["strTrainmanName1"]); model.strTrainmanNumber2 = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber2"]); model.strTrainmanName2 = ObjectConvertClass.static_ext_string(dr["strTrainmanName2"]); model.strTrainmanNumber3 = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber3"]); model.strTrainmanName3 = ObjectConvertClass.static_ext_string(dr["strTrainmanName3"]); model.strTrainmanNumber4 = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber4"]); model.strTrainmanName4 = ObjectConvertClass.static_ext_string(dr["strTrainmanName4"]); model.strCardNumber = ObjectConvertClass.static_ext_string(dr["strCardNumber"]); model.strSiteNumber = ObjectConvertClass.static_ext_string(dr["strSiteNumber"]); model.strSiteName = ObjectConvertClass.static_ext_string(dr["strSiteName"]); }
/// <summary> /// 添加数据 /// </summary> public string Add(SqlCommand command, RunRecordFileMain model, Boolean isExitPlan, int a) { string sqlConnString = ZhuanChuString; string DetailTime = DateTime.Now.ToString(); int DetaieCount = a; if (ZhuanChuIsEnable == "1") { try { if (!string.IsNullOrEmpty(model.strTrainmanNumber1) && model.dtPlanChuQinTime > DateTime.Now.AddDays(-1000)) { DataTable dt = getMaxTimeAndCount(model.dtPlanChuQinTime.ToString(), model.strTrainmanNumber1); if (ObjectConvertClass.static_ext_int(dt.Rows[0]["DetaieCount"]) != 0) { DetaieCount = ObjectConvertClass.static_ext_int(dt.Rows[0]["DetaieCount"]); DetailTime = ObjectConvertClass.static_ext_string(dt.Rows[0]["DetailTime"]); } } } catch (Exception ex) { throw ex; } } 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,dtLastUpDateTime,nDetailCount)"); 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,@dtLastUpDateTime,@nDetailCount)"); 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), new SqlParameter("@nDetailCount", DetaieCount), new SqlParameter("@dtLastUpDateTime", DetailTime) }; command.CommandText = strSql.ToString(); command.Parameters.Clear(); command.Parameters.AddRange(parameters); return(ObjectConvertClass.static_ext_string(command.ExecuteScalar())); //return command.ExecuteNonQuery(); }