/// <summary>
/// 更新数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Update(GPS_CarConfig model)
{
bool result = false;
var e = new ModelExceptions();
int _rseult = instance.Update(model);
if (_rseult > 0)
{
result = true;
}
return(result);
}
/// <summary>
/// 获取实体数据
/// </summary>
/// <param name='strCondition'>条件(AND Code='11')</param>
/// <returns>model</returns>
public GPS_CarConfig GetModel(string strCondition)
{
List <GPS_CarConfig> list = instance.GetListByWhere(strCondition);
GPS_CarConfig model = new GPS_CarConfig();
if (list != null && list.Count > 0)
{
model = list[0];
}
else
{
model = null;
}
return(model);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <param name='model'>是否完成验证</param>
/// <returns>bool</returns>
public bool Insert(GPS_CarConfig model, bool IsValid)
{
var e = new ModelExceptions();
bool result = false;
if (e.IsValid && IsValid)
{
//完成了验证，开始更新数据库了
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
return(result);
}
/// <summary>
/// 逻辑删除数据
/// </summary>
/// <param name='model'>model</param>
/// <returns>bool</returns>
public bool Delete(string Condition)
{
bool result = false;
List <GPS_CarConfig> list = instance.GetListByWhere(Condition);
if (list.Count > 0)
{
GPS_CarConfig model = list[0];
model.Stat = 1;
int _rseult = instance.Update(model);
if (_rseult > 0)
{
result = true;
}
}
return(result);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Insert(GPS_CarConfig model)
{
bool result = false;
try
{
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// 获取实体数据
/// </summary>
/// <param name='strCondition'>条件(AND Code='11')</param>
/// <returns>model</returns>
public GPS_CarConfig GetModel(int id)
{
GPS_CarConfig model = instance.GetByKey(id);
return(model);
}
/// <summary>
/// 获取所有的车辆配置表 GPS_CarConfig对象(即:一条记录
/// </summary>
public List <GPS_CarConfig> GetAll()
{
List <GPS_CarConfig> ret = new List <GPS_CarConfig>();
string sql = "SELECT G_ID,Car_No,Car_Icon,Car_CurPerson,Car_CurPersonTel,Car_Address,Car_ShowTxtR,Car_ShowTxt,Car_Staus,Stat FROM GPS_CarConfig where 1=1 AND ((Stat is null) or (Stat=0) ) ";
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
GPS_CarConfig gPS_CarConfig = new GPS_CarConfig();
if (dr["G_ID"] != DBNull.Value)
{
gPS_CarConfig.G_ID = Convert.ToDecimal(dr["G_ID"]);
}
if (dr["Car_No"] != DBNull.Value)
{
gPS_CarConfig.Car_No = Convert.ToString(dr["Car_No"]);
}
if (dr["Car_Icon"] != DBNull.Value)
{
gPS_CarConfig.Car_Icon = Convert.ToString(dr["Car_Icon"]);
}
if (dr["Car_CurPerson"] != DBNull.Value)
{
gPS_CarConfig.Car_CurPerson = Convert.ToString(dr["Car_CurPerson"]);
}
if (dr["Car_CurPersonTel"] != DBNull.Value)
{
gPS_CarConfig.Car_CurPersonTel = Convert.ToString(dr["Car_CurPersonTel"]);
}
if (dr["Car_Address"] != DBNull.Value)
{
gPS_CarConfig.Car_Address = Convert.ToString(dr["Car_Address"]);
}
if (dr["Car_ShowTxtR"] != DBNull.Value)
{
gPS_CarConfig.Car_ShowTxtR = Convert.ToString(dr["Car_ShowTxtR"]);
}
if (dr["Car_ShowTxt"] != DBNull.Value)
{
gPS_CarConfig.Car_ShowTxt = Convert.ToString(dr["Car_ShowTxt"]);
}
if (dr["Car_Staus"] != DBNull.Value)
{
gPS_CarConfig.Car_Staus = Convert.ToString(dr["Car_Staus"]);
}
if (dr["Stat"] != DBNull.Value)
{
gPS_CarConfig.Stat = Convert.ToInt32(dr["Stat"]);
}
ret.Add(gPS_CarConfig);
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
{
idb.GetConnection().Close();
}
}
return(ret);
}
/// <summary>
/// 获取指定的车辆配置表 GPS_CarConfig对象(即:一条记录
/// </summary>
public GPS_CarConfig GetByKey(decimal g_ID)
{
GPS_CarConfig gPS_CarConfig = new GPS_CarConfig();
string sql = "SELECT G_ID,Car_No,Car_Icon,Car_CurPerson,Car_CurPersonTel,Car_Address,Car_ShowTxtR,Car_ShowTxt,Car_Staus,Stat FROM GPS_CarConfig WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND G_ID=@G_ID ";
idb.AddParameter("@G_ID", g_ID);
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
if (dr["G_ID"] != DBNull.Value)
{
gPS_CarConfig.G_ID = Convert.ToDecimal(dr["G_ID"]);
}
if (dr["Car_No"] != DBNull.Value)
{
gPS_CarConfig.Car_No = Convert.ToString(dr["Car_No"]);
}
if (dr["Car_Icon"] != DBNull.Value)
{
gPS_CarConfig.Car_Icon = Convert.ToString(dr["Car_Icon"]);
}
if (dr["Car_CurPerson"] != DBNull.Value)
{
gPS_CarConfig.Car_CurPerson = Convert.ToString(dr["Car_CurPerson"]);
}
if (dr["Car_CurPersonTel"] != DBNull.Value)
{
gPS_CarConfig.Car_CurPersonTel = Convert.ToString(dr["Car_CurPersonTel"]);
}
if (dr["Car_Address"] != DBNull.Value)
{
gPS_CarConfig.Car_Address = Convert.ToString(dr["Car_Address"]);
}
if (dr["Car_ShowTxtR"] != DBNull.Value)
{
gPS_CarConfig.Car_ShowTxtR = Convert.ToString(dr["Car_ShowTxtR"]);
}
if (dr["Car_ShowTxt"] != DBNull.Value)
{
gPS_CarConfig.Car_ShowTxt = Convert.ToString(dr["Car_ShowTxt"]);
}
if (dr["Car_Staus"] != DBNull.Value)
{
gPS_CarConfig.Car_Staus = Convert.ToString(dr["Car_Staus"]);
}
if (dr["Stat"] != DBNull.Value)
{
gPS_CarConfig.Stat = Convert.ToInt32(dr["Stat"]);
}
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
{
idb.GetConnection().Close();
}
}
return(gPS_CarConfig);
}
/// <summary>
/// 添加车辆配置表 GPS_CarConfig对象(即:一条记录)
/// </summary>
public int Add(GPS_CarConfig gPS_CarConfig)
{
string sql = "INSERT INTO GPS_CarConfig (Car_No,Car_Icon,Car_CurPerson,Car_CurPersonTel,Car_Address,Car_ShowTxtR,Car_ShowTxt,Car_Staus,Stat) VALUES (@Car_No,@Car_Icon,@Car_CurPerson,@Car_CurPersonTel,@Car_Address,@Car_ShowTxtR,@Car_ShowTxt,@Car_Staus,@Stat)";
if (string.IsNullOrEmpty(gPS_CarConfig.Car_No))
{
idb.AddParameter("@Car_No", DBNull.Value);
}
else
{
idb.AddParameter("@Car_No", gPS_CarConfig.Car_No);
}
if (string.IsNullOrEmpty(gPS_CarConfig.Car_Icon))
{
idb.AddParameter("@Car_Icon", DBNull.Value);
}
else
{
idb.AddParameter("@Car_Icon", gPS_CarConfig.Car_Icon);
}
if (string.IsNullOrEmpty(gPS_CarConfig.Car_CurPerson))
{
idb.AddParameter("@Car_CurPerson", DBNull.Value);
}
else
{
idb.AddParameter("@Car_CurPerson", gPS_CarConfig.Car_CurPerson);
}
if (string.IsNullOrEmpty(gPS_CarConfig.Car_CurPersonTel))
{
idb.AddParameter("@Car_CurPersonTel", DBNull.Value);
}
else
{
idb.AddParameter("@Car_CurPersonTel", gPS_CarConfig.Car_CurPersonTel);
}
if (string.IsNullOrEmpty(gPS_CarConfig.Car_Address))
{
idb.AddParameter("@Car_Address", DBNull.Value);
}
else
{
idb.AddParameter("@Car_Address", gPS_CarConfig.Car_Address);
}
if (string.IsNullOrEmpty(gPS_CarConfig.Car_ShowTxtR))
{
idb.AddParameter("@Car_ShowTxtR", DBNull.Value);
}
else
{
idb.AddParameter("@Car_ShowTxtR", gPS_CarConfig.Car_ShowTxtR);
}
if (string.IsNullOrEmpty(gPS_CarConfig.Car_ShowTxt))
{
idb.AddParameter("@Car_ShowTxt", DBNull.Value);
}
else
{
idb.AddParameter("@Car_ShowTxt", gPS_CarConfig.Car_ShowTxt);
}
if (string.IsNullOrEmpty(gPS_CarConfig.Car_Staus))
{
idb.AddParameter("@Car_Staus", DBNull.Value);
}
else
{
idb.AddParameter("@Car_Staus", gPS_CarConfig.Car_Staus);
}
if (gPS_CarConfig.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", gPS_CarConfig.Stat);
}
return(idb.ExeCmd(sql));
}
/// <summary>
/// 更新车辆配置表 GPS_CarConfig对象(即:一条记录
/// </summary>
public int Update(GPS_CarConfig gPS_CarConfig)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE GPS_CarConfig SET ");
if (gPS_CarConfig.Car_No_IsChanged)
{
sbParameter.Append("Car_No=@Car_No, ");
}
if (gPS_CarConfig.Car_Icon_IsChanged)
{
sbParameter.Append("Car_Icon=@Car_Icon, ");
}
if (gPS_CarConfig.Car_CurPerson_IsChanged)
{
sbParameter.Append("Car_CurPerson=@Car_CurPerson, ");
}
if (gPS_CarConfig.Car_CurPersonTel_IsChanged)
{
sbParameter.Append("Car_CurPersonTel=@Car_CurPersonTel, ");
}
if (gPS_CarConfig.Car_Address_IsChanged)
{
sbParameter.Append("Car_Address=@Car_Address, ");
}
if (gPS_CarConfig.Car_ShowTxtR_IsChanged)
{
sbParameter.Append("Car_ShowTxtR=@Car_ShowTxtR, ");
}
if (gPS_CarConfig.Car_ShowTxt_IsChanged)
{
sbParameter.Append("Car_ShowTxt=@Car_ShowTxt, ");
}
if (gPS_CarConfig.Car_Staus_IsChanged)
{
sbParameter.Append("Car_Staus=@Car_Staus, ");
}
if (gPS_CarConfig.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and G_ID=@G_ID; ");
string sql = sb.ToString();
if (gPS_CarConfig.Car_No_IsChanged)
{
if (string.IsNullOrEmpty(gPS_CarConfig.Car_No))
{
idb.AddParameter("@Car_No", DBNull.Value);
}
else
{
idb.AddParameter("@Car_No", gPS_CarConfig.Car_No);
}
}
if (gPS_CarConfig.Car_Icon_IsChanged)
{
if (string.IsNullOrEmpty(gPS_CarConfig.Car_Icon))
{
idb.AddParameter("@Car_Icon", DBNull.Value);
}
else
{
idb.AddParameter("@Car_Icon", gPS_CarConfig.Car_Icon);
}
}
if (gPS_CarConfig.Car_CurPerson_IsChanged)
{
if (string.IsNullOrEmpty(gPS_CarConfig.Car_CurPerson))
{
idb.AddParameter("@Car_CurPerson", DBNull.Value);
}
else
{
idb.AddParameter("@Car_CurPerson", gPS_CarConfig.Car_CurPerson);
}
}
if (gPS_CarConfig.Car_CurPersonTel_IsChanged)
{
if (string.IsNullOrEmpty(gPS_CarConfig.Car_CurPersonTel))
{
idb.AddParameter("@Car_CurPersonTel", DBNull.Value);
}
else
{
idb.AddParameter("@Car_CurPersonTel", gPS_CarConfig.Car_CurPersonTel);
}
}
if (gPS_CarConfig.Car_Address_IsChanged)
{
if (string.IsNullOrEmpty(gPS_CarConfig.Car_Address))
{
idb.AddParameter("@Car_Address", DBNull.Value);
}
else
{
idb.AddParameter("@Car_Address", gPS_CarConfig.Car_Address);
}
}
if (gPS_CarConfig.Car_ShowTxtR_IsChanged)
{
if (string.IsNullOrEmpty(gPS_CarConfig.Car_ShowTxtR))
{
idb.AddParameter("@Car_ShowTxtR", DBNull.Value);
}
else
{
idb.AddParameter("@Car_ShowTxtR", gPS_CarConfig.Car_ShowTxtR);
}
}
if (gPS_CarConfig.Car_ShowTxt_IsChanged)
{
if (string.IsNullOrEmpty(gPS_CarConfig.Car_ShowTxt))
{
idb.AddParameter("@Car_ShowTxt", DBNull.Value);
}
else
{
idb.AddParameter("@Car_ShowTxt", gPS_CarConfig.Car_ShowTxt);
}
}
if (gPS_CarConfig.Car_Staus_IsChanged)
{
if (string.IsNullOrEmpty(gPS_CarConfig.Car_Staus))
{
idb.AddParameter("@Car_Staus", DBNull.Value);
}
else
{
idb.AddParameter("@Car_Staus", gPS_CarConfig.Car_Staus);
}
}
if (gPS_CarConfig.Stat_IsChanged)
{
if (gPS_CarConfig.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", gPS_CarConfig.Stat);
}
}
idb.AddParameter("@G_ID", gPS_CarConfig.G_ID);
return(idb.ExeCmd(sql));
}
