/// <summary> /// 添加数据 /// </summary> public bool Add(ZXYJInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TAB_Plan_RunEvent_ZXYJ"); strSql.Append("(nid,strTrainPlanGUID,strTrainmanNumber1,strTrainmanNumber2,dtEventTime,strXDMC,strTrainNo,strTrainNumber,strTrainTypeName,strDWH,dtCreateTime,nTMIS,strTMISName)"); strSql.Append("values(@nid,@strTrainPlanGUID,@strTrainmanNumber1,@strTrainmanNumber2,@dtEventTime,@strXDMC,@strTrainNo,@strTrainNumber,@strTrainTypeName,@strDWH,@dtCreateTime,@nTMIS,@strTMISName)"); SqlParameter[] parameters = { new SqlParameter("@nid", model.nid), new SqlParameter("@strTrainPlanGUID", model.strTrainPlanGUID), new SqlParameter("@strTrainmanNumber1", model.strTrainmanNumber1), new SqlParameter("@strTrainmanNumber2", model.strTrainmanNumber2), new SqlParameter("@dtEventTime", model.dtEventTime), new SqlParameter("@strXDMC", model.strXDMC), new SqlParameter("@strTrainNo", model.strTrainNo), new SqlParameter("@strTrainNumber", model.strTrainNumber), new SqlParameter("@strTrainTypeName", model.strTrainTypeName), new SqlParameter("@strDWH", model.strDWH), new SqlParameter("@dtCreateTime", model.dtCreateTime), new SqlParameter("@nTMIS", model.nTMIS), new SqlParameter("@strTMISName", model.strTMISName) }; return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters) > 0); }
/// <summary> /// 获得数据List /// </summary> public ZXYJInfoList GetDataList(ZXYJQueryCondition 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_Plan_RunEvent_ZXYJ where 1=1 " + strSqlOption.ToString()); } else { strSql.Append(@"select top " + QueryCondition.rows.ToString() + " * from TAB_Plan_RunEvent_ZXYJ where 1 = 1 " + strSqlOption.ToString() + " and nID not in ( select top " + (QueryCondition.page - 1) * QueryCondition.rows + " nID from TAB_Plan_RunEvent_ZXYJ where 1=1 " + strSqlOption.ToString() + " order by nID desc) order by nID desc"); } DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0]; ZXYJInfoList list = new ZXYJInfoList(); foreach (DataRow dr in dt.Rows) { ZXYJInfo ZXYJ = new ZXYJInfo(); DataRowToModel(ZXYJ, dr); list.Add(ZXYJ); } return(list); }
/// <summary> /// 检查数据是否存在 /// </summary> public bool Exists(ZXYJInfo _ZXYJInfo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(*) from TAB_Plan_RunEvent_ZXYJ where nid=@nid"); SqlParameter[] parameters = { new SqlParameter("nid", _ZXYJInfo.nid) }; return(Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters)) > 0); }
/// <summary> /// 读取DataRow数据到Model中 /// </summary> private void DataRowToModel(ZXYJInfo model, DataRow dr) { model.nid = ObjectConvertClass.static_ext_int(dr["nid"]); model.strTrainPlanGUID = ObjectConvertClass.static_ext_string(dr["strTrainPlanGUID"]); model.strTrainmanNumber1 = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber1"]); model.strTrainmanNumber2 = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber2"]); model.dtEventTime = ObjectConvertClass.static_ext_Date(dr["dtEventTime"]); model.strXDMC = ObjectConvertClass.static_ext_string(dr["strXDMC"]); model.strTrainNo = ObjectConvertClass.static_ext_string(dr["strTrainNo"]); model.strTrainNumber = ObjectConvertClass.static_ext_string(dr["strTrainNumber"]); model.strTrainTypeName = ObjectConvertClass.static_ext_string(dr["strTrainTypeName"]); model.strDWH = ObjectConvertClass.static_ext_string(dr["strDWH"]); model.dtCreateTime = ObjectConvertClass.static_ext_Date(dr["dtCreateTime"]); model.nTMIS = ObjectConvertClass.static_ext_string(dr["nTMIS"]); model.strTMISName = ObjectConvertClass.static_ext_string(dr["strTMISName"]); }
/// <summary> /// 获得一个实体对象 /// </summary> public ZXYJInfo GetModel(ZXYJQueryCondition 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_Plan_RunEvent_ZXYJ where 1=1 " + strSqlOption.ToString()); DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0]; ZXYJInfo _ZXYJ = null; if (dt.Rows.Count > 0) { _ZXYJ = new ZXYJInfo(); DataRowToModel(_ZXYJ, dt.Rows[0]); } return(_ZXYJ); }
/// <summary> /// 更新数据 /// </summary> public bool Update(ZXYJInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("Update TAB_Plan_RunEvent_ZXYJ set "); strSql.Append(" nid = @nid, "); strSql.Append(" strTrainPlanGUID = @strTrainPlanGUID, "); strSql.Append(" strTrainmanNumber1 = @strTrainmanNumber1, "); strSql.Append(" strTrainmanNumber2 = @strTrainmanNumber2, "); strSql.Append(" dtEventTime = @dtEventTime, "); strSql.Append(" strXDMC = @strXDMC, "); strSql.Append(" strTrainNo = @strTrainNo, "); strSql.Append(" strTrainNumber = @strTrainNumber, "); strSql.Append(" strTrainTypeName = @strTrainTypeName, "); strSql.Append(" strDWH = @strDWH, "); strSql.Append(" dtCreateTime = @dtCreateTime, "); strSql.Append(" nTMIS = @nTMIS, "); strSql.Append(" strTMISName = @strTMISName "); strSql.Append(" where nid = @nid "); SqlParameter[] parameters = { new SqlParameter("@nid", model.nid), new SqlParameter("@strTrainPlanGUID", model.strTrainPlanGUID), new SqlParameter("@strTrainmanNumber1", model.strTrainmanNumber1), new SqlParameter("@strTrainmanNumber2", model.strTrainmanNumber2), new SqlParameter("@dtEventTime", model.dtEventTime), new SqlParameter("@strXDMC", model.strXDMC), new SqlParameter("@strTrainNo", model.strTrainNo), new SqlParameter("@strTrainNumber", model.strTrainNumber), new SqlParameter("@strTrainTypeName", model.strTrainTypeName), new SqlParameter("@strDWH", model.strDWH), new SqlParameter("@dtCreateTime", model.dtCreateTime), new SqlParameter("@nTMIS", model.nTMIS), new SqlParameter("@strTMISName", model.strTMISName) }; return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters) > 0); }