/// <summary>
/// 更新数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Update(Sys_PD_Module 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 Sys_PD_Module GetModel(string strCondition)
{
List <Sys_PD_Module> list = instance.GetListByWhere(strCondition);
Sys_PD_Module model = new Sys_PD_Module();
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(Sys_PD_Module 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 <Sys_PD_Module> list = instance.GetListByWhere(Condition);
if (list.Count > 0)
{
Sys_PD_Module 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(Sys_PD_Module model)
{
bool result = false;
try
{
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// 获取所有的Sys_PD_Module对象(即:一条记录
/// </summary>
public List <Sys_PD_Module> GetAll()
{
List <Sys_PD_Module> ret = new List <Sys_PD_Module>();
string sql = "SELECT SPM_ID,SPM_Module,SPM_LPrefix,SPM_Name,SPM_LX,SPM_LY,SPM_TX,SPM_TY,SPM_LI,SPM_TI,SPM_CNum,SPM_TPrefix,SPM_Height,Stat FROM Sys_PD_Module where 1=1 AND ((Stat is null) or (Stat=0) ) ";
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
Sys_PD_Module sys_PD_Module = new Sys_PD_Module();
if (dr["SPM_ID"] != DBNull.Value)
{
sys_PD_Module.SPM_ID = Convert.ToInt64(dr["SPM_ID"]);
}
if (dr["SPM_Module"] != DBNull.Value)
{
sys_PD_Module.SPM_Module = Convert.ToString(dr["SPM_Module"]);
}
if (dr["SPM_LPrefix"] != DBNull.Value)
{
sys_PD_Module.SPM_LPrefix = Convert.ToString(dr["SPM_LPrefix"]);
}
if (dr["SPM_Name"] != DBNull.Value)
{
sys_PD_Module.SPM_Name = Convert.ToString(dr["SPM_Name"]);
}
if (dr["SPM_LX"] != DBNull.Value)
{
sys_PD_Module.SPM_LX = Convert.ToInt32(dr["SPM_LX"]);
}
if (dr["SPM_LY"] != DBNull.Value)
{
sys_PD_Module.SPM_LY = Convert.ToInt32(dr["SPM_LY"]);
}
if (dr["SPM_TX"] != DBNull.Value)
{
sys_PD_Module.SPM_TX = Convert.ToInt32(dr["SPM_TX"]);
}
if (dr["SPM_TY"] != DBNull.Value)
{
sys_PD_Module.SPM_TY = Convert.ToInt32(dr["SPM_TY"]);
}
if (dr["SPM_LI"] != DBNull.Value)
{
sys_PD_Module.SPM_LI = Convert.ToInt32(dr["SPM_LI"]);
}
if (dr["SPM_TI"] != DBNull.Value)
{
sys_PD_Module.SPM_TI = Convert.ToInt32(dr["SPM_TI"]);
}
if (dr["SPM_CNum"] != DBNull.Value)
{
sys_PD_Module.SPM_CNum = Convert.ToInt32(dr["SPM_CNum"]);
}
if (dr["SPM_TPrefix"] != DBNull.Value)
{
sys_PD_Module.SPM_TPrefix = Convert.ToString(dr["SPM_TPrefix"]);
}
if (dr["SPM_Height"] != DBNull.Value)
{
sys_PD_Module.SPM_Height = Convert.ToInt32(dr["SPM_Height"]);
}
if (dr["Stat"] != DBNull.Value)
{
sys_PD_Module.Stat = Convert.ToInt32(dr["Stat"]);
}
ret.Add(sys_PD_Module);
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
}
return(ret);
}
/// <summary>
/// 获取指定的Sys_PD_Module对象(即:一条记录
/// </summary>
public Sys_PD_Module GetByKey(Int64 sPM_ID)
{
Sys_PD_Module sys_PD_Module = new Sys_PD_Module();
string sql = "SELECT SPM_ID,SPM_Module,SPM_LPrefix,SPM_Name,SPM_LX,SPM_LY,SPM_TX,SPM_TY,SPM_LI,SPM_TI,SPM_CNum,SPM_TPrefix,SPM_Height,Stat FROM Sys_PD_Module WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND SPM_ID=@SPM_ID ";
idb.AddParameter("@SPM_ID", sPM_ID);
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
if (dr["SPM_ID"] != DBNull.Value)
{
sys_PD_Module.SPM_ID = Convert.ToInt64(dr["SPM_ID"]);
}
if (dr["SPM_Module"] != DBNull.Value)
{
sys_PD_Module.SPM_Module = Convert.ToString(dr["SPM_Module"]);
}
if (dr["SPM_LPrefix"] != DBNull.Value)
{
sys_PD_Module.SPM_LPrefix = Convert.ToString(dr["SPM_LPrefix"]);
}
if (dr["SPM_Name"] != DBNull.Value)
{
sys_PD_Module.SPM_Name = Convert.ToString(dr["SPM_Name"]);
}
if (dr["SPM_LX"] != DBNull.Value)
{
sys_PD_Module.SPM_LX = Convert.ToInt32(dr["SPM_LX"]);
}
if (dr["SPM_LY"] != DBNull.Value)
{
sys_PD_Module.SPM_LY = Convert.ToInt32(dr["SPM_LY"]);
}
if (dr["SPM_TX"] != DBNull.Value)
{
sys_PD_Module.SPM_TX = Convert.ToInt32(dr["SPM_TX"]);
}
if (dr["SPM_TY"] != DBNull.Value)
{
sys_PD_Module.SPM_TY = Convert.ToInt32(dr["SPM_TY"]);
}
if (dr["SPM_LI"] != DBNull.Value)
{
sys_PD_Module.SPM_LI = Convert.ToInt32(dr["SPM_LI"]);
}
if (dr["SPM_TI"] != DBNull.Value)
{
sys_PD_Module.SPM_TI = Convert.ToInt32(dr["SPM_TI"]);
}
if (dr["SPM_CNum"] != DBNull.Value)
{
sys_PD_Module.SPM_CNum = Convert.ToInt32(dr["SPM_CNum"]);
}
if (dr["SPM_TPrefix"] != DBNull.Value)
{
sys_PD_Module.SPM_TPrefix = Convert.ToString(dr["SPM_TPrefix"]);
}
if (dr["SPM_Height"] != DBNull.Value)
{
sys_PD_Module.SPM_Height = Convert.ToInt32(dr["SPM_Height"]);
}
if (dr["Stat"] != DBNull.Value)
{
sys_PD_Module.Stat = Convert.ToInt32(dr["Stat"]);
}
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
}
return(sys_PD_Module);
}
/// <summary>
/// 更新Sys_PD_Module对象(即:一条记录
/// </summary>
public int Update(Sys_PD_Module sys_PD_Module)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE Sys_PD_Module SET ");
if (sys_PD_Module.SPM_Module_IsChanged)
{
sbParameter.Append("SPM_Module=@SPM_Module, ");
}
if (sys_PD_Module.SPM_LPrefix_IsChanged)
{
sbParameter.Append("SPM_LPrefix=@SPM_LPrefix, ");
}
if (sys_PD_Module.SPM_Name_IsChanged)
{
sbParameter.Append("SPM_Name=@SPM_Name, ");
}
if (sys_PD_Module.SPM_LX_IsChanged)
{
sbParameter.Append("SPM_LX=@SPM_LX, ");
}
if (sys_PD_Module.SPM_LY_IsChanged)
{
sbParameter.Append("SPM_LY=@SPM_LY, ");
}
if (sys_PD_Module.SPM_TX_IsChanged)
{
sbParameter.Append("SPM_TX=@SPM_TX, ");
}
if (sys_PD_Module.SPM_TY_IsChanged)
{
sbParameter.Append("SPM_TY=@SPM_TY, ");
}
if (sys_PD_Module.SPM_LI_IsChanged)
{
sbParameter.Append("SPM_LI=@SPM_LI, ");
}
if (sys_PD_Module.SPM_TI_IsChanged)
{
sbParameter.Append("SPM_TI=@SPM_TI, ");
}
if (sys_PD_Module.SPM_CNum_IsChanged)
{
sbParameter.Append("SPM_CNum=@SPM_CNum, ");
}
if (sys_PD_Module.SPM_TPrefix_IsChanged)
{
sbParameter.Append("SPM_TPrefix=@SPM_TPrefix, ");
}
if (sys_PD_Module.SPM_Height_IsChanged)
{
sbParameter.Append("SPM_Height=@SPM_Height, ");
}
if (sys_PD_Module.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 SPM_ID=@SPM_ID; ");
string sql = sb.ToString();
if (sys_PD_Module.SPM_Module_IsChanged)
{
if (string.IsNullOrEmpty(sys_PD_Module.SPM_Module))
{
idb.AddParameter("@SPM_Module", DBNull.Value);
}
else
{
idb.AddParameter("@SPM_Module", sys_PD_Module.SPM_Module);
}
}
if (sys_PD_Module.SPM_LPrefix_IsChanged)
{
if (string.IsNullOrEmpty(sys_PD_Module.SPM_LPrefix))
{
idb.AddParameter("@SPM_LPrefix", DBNull.Value);
}
else
{
idb.AddParameter("@SPM_LPrefix", sys_PD_Module.SPM_LPrefix);
}
}
if (sys_PD_Module.SPM_Name_IsChanged)
{
if (string.IsNullOrEmpty(sys_PD_Module.SPM_Name))
{
idb.AddParameter("@SPM_Name", DBNull.Value);
}
else
{
idb.AddParameter("@SPM_Name", sys_PD_Module.SPM_Name);
}
}
if (sys_PD_Module.SPM_LX_IsChanged)
{
if (sys_PD_Module.SPM_LX == 0)
{
idb.AddParameter("@SPM_LX", 0);
}
else
{
idb.AddParameter("@SPM_LX", sys_PD_Module.SPM_LX);
}
}
if (sys_PD_Module.SPM_LY_IsChanged)
{
if (sys_PD_Module.SPM_LY == 0)
{
idb.AddParameter("@SPM_LY", 0);
}
else
{
idb.AddParameter("@SPM_LY", sys_PD_Module.SPM_LY);
}
}
if (sys_PD_Module.SPM_TX_IsChanged)
{
if (sys_PD_Module.SPM_TX == 0)
{
idb.AddParameter("@SPM_TX", 0);
}
else
{
idb.AddParameter("@SPM_TX", sys_PD_Module.SPM_TX);
}
}
if (sys_PD_Module.SPM_TY_IsChanged)
{
if (sys_PD_Module.SPM_TY == 0)
{
idb.AddParameter("@SPM_TY", 0);
}
else
{
idb.AddParameter("@SPM_TY", sys_PD_Module.SPM_TY);
}
}
if (sys_PD_Module.SPM_LI_IsChanged)
{
if (sys_PD_Module.SPM_LI == 0)
{
idb.AddParameter("@SPM_LI", 0);
}
else
{
idb.AddParameter("@SPM_LI", sys_PD_Module.SPM_LI);
}
}
if (sys_PD_Module.SPM_TI_IsChanged)
{
if (sys_PD_Module.SPM_TI == 0)
{
idb.AddParameter("@SPM_TI", 0);
}
else
{
idb.AddParameter("@SPM_TI", sys_PD_Module.SPM_TI);
}
}
if (sys_PD_Module.SPM_CNum_IsChanged)
{
if (sys_PD_Module.SPM_CNum == 0)
{
idb.AddParameter("@SPM_CNum", 0);
}
else
{
idb.AddParameter("@SPM_CNum", sys_PD_Module.SPM_CNum);
}
}
if (sys_PD_Module.SPM_TPrefix_IsChanged)
{
if (string.IsNullOrEmpty(sys_PD_Module.SPM_TPrefix))
{
idb.AddParameter("@SPM_TPrefix", DBNull.Value);
}
else
{
idb.AddParameter("@SPM_TPrefix", sys_PD_Module.SPM_TPrefix);
}
}
if (sys_PD_Module.SPM_Height_IsChanged)
{
if (sys_PD_Module.SPM_Height == 0)
{
idb.AddParameter("@SPM_Height", 0);
}
else
{
idb.AddParameter("@SPM_Height", sys_PD_Module.SPM_Height);
}
}
if (sys_PD_Module.Stat_IsChanged)
{
if (sys_PD_Module.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", sys_PD_Module.Stat);
}
}
idb.AddParameter("@SPM_ID", sys_PD_Module.SPM_ID);
return(idb.ExeCmd(sql));
}
/// <summary>
/// 添加Sys_PD_Module对象(即:一条记录)
/// </summary>
public int Add(Sys_PD_Module sys_PD_Module)
{
string sql = "INSERT INTO Sys_PD_Module (SPM_Module,SPM_LPrefix,SPM_Name,SPM_LX,SPM_LY,SPM_TX,SPM_TY,SPM_LI,SPM_TI,SPM_CNum,SPM_TPrefix,SPM_Height,Stat) VALUES (@SPM_Module,@SPM_LPrefix,@SPM_Name,@SPM_LX,@SPM_LY,@SPM_TX,@SPM_TY,@SPM_LI,@SPM_TI,@SPM_CNum,@SPM_TPrefix,@SPM_Height,@Stat)";
if (string.IsNullOrEmpty(sys_PD_Module.SPM_Module))
{
idb.AddParameter("@SPM_Module", DBNull.Value);
}
else
{
idb.AddParameter("@SPM_Module", sys_PD_Module.SPM_Module);
}
if (string.IsNullOrEmpty(sys_PD_Module.SPM_LPrefix))
{
idb.AddParameter("@SPM_LPrefix", DBNull.Value);
}
else
{
idb.AddParameter("@SPM_LPrefix", sys_PD_Module.SPM_LPrefix);
}
if (string.IsNullOrEmpty(sys_PD_Module.SPM_Name))
{
idb.AddParameter("@SPM_Name", DBNull.Value);
}
else
{
idb.AddParameter("@SPM_Name", sys_PD_Module.SPM_Name);
}
if (sys_PD_Module.SPM_LX == 0)
{
idb.AddParameter("@SPM_LX", 0);
}
else
{
idb.AddParameter("@SPM_LX", sys_PD_Module.SPM_LX);
}
if (sys_PD_Module.SPM_LY == 0)
{
idb.AddParameter("@SPM_LY", 0);
}
else
{
idb.AddParameter("@SPM_LY", sys_PD_Module.SPM_LY);
}
if (sys_PD_Module.SPM_TX == 0)
{
idb.AddParameter("@SPM_TX", 0);
}
else
{
idb.AddParameter("@SPM_TX", sys_PD_Module.SPM_TX);
}
if (sys_PD_Module.SPM_TY == 0)
{
idb.AddParameter("@SPM_TY", 0);
}
else
{
idb.AddParameter("@SPM_TY", sys_PD_Module.SPM_TY);
}
if (sys_PD_Module.SPM_LI == 0)
{
idb.AddParameter("@SPM_LI", 0);
}
else
{
idb.AddParameter("@SPM_LI", sys_PD_Module.SPM_LI);
}
if (sys_PD_Module.SPM_TI == 0)
{
idb.AddParameter("@SPM_TI", 0);
}
else
{
idb.AddParameter("@SPM_TI", sys_PD_Module.SPM_TI);
}
if (sys_PD_Module.SPM_CNum == 0)
{
idb.AddParameter("@SPM_CNum", 0);
}
else
{
idb.AddParameter("@SPM_CNum", sys_PD_Module.SPM_CNum);
}
if (string.IsNullOrEmpty(sys_PD_Module.SPM_TPrefix))
{
idb.AddParameter("@SPM_TPrefix", DBNull.Value);
}
else
{
idb.AddParameter("@SPM_TPrefix", sys_PD_Module.SPM_TPrefix);
}
if (sys_PD_Module.SPM_Height == 0)
{
idb.AddParameter("@SPM_Height", 0);
}
else
{
idb.AddParameter("@SPM_Height", sys_PD_Module.SPM_Height);
}
if (sys_PD_Module.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", sys_PD_Module.Stat);
}
return(idb.ExeCmd(sql));
}
/// <summary>
/// 获取实体数据
/// </summary>
/// <param name='strCondition'>条件(AND Code='11')</param>
/// <returns>model</returns>
public Sys_PD_Module GetModel(int id)
{
Sys_PD_Module model = instance.GetByKey(id);
return(model);
}
