/// <summary>
/// 添加Sys_DictKey对象(即:一条记录)
/// </summary>
public object AddWithReturn(Sys_DictKey sys_DictKey)
{
string sql = "INSERT INTO Sys_DictKey (TABLENAME,TABLEID,ModuleCode,PrefixCode,CodeLenth) VALUES (@TABLENAME,@TABLEID,@ModuleCode,@PrefixCode,@CodeLenth);SELECT @@IDENTITY AS ReturnID;";
if (string.IsNullOrEmpty(sys_DictKey.TABLEID))
{
idb.AddParameter("@TABLEID", "''");
}
else
{
idb.AddParameter("@TABLEID", sys_DictKey.TABLEID);
}
if (string.IsNullOrEmpty(sys_DictKey.ModuleCode))
{
idb.AddParameter("@ModuleCode", DBNull.Value);
}
else
{
idb.AddParameter("@ModuleCode", sys_DictKey.ModuleCode);
}
if (string.IsNullOrEmpty(sys_DictKey.PrefixCode))
{
idb.AddParameter("@PrefixCode", DBNull.Value);
}
else
{
idb.AddParameter("@PrefixCode", sys_DictKey.PrefixCode);
}
if (sys_DictKey.CodeLenth == 0)
{
idb.AddParameter("@CodeLenth", 0);
}
else
{
idb.AddParameter("@CodeLenth", sys_DictKey.CodeLenth);
}
return idb.ReturnValue(sql);
}
/// <summary>
/// 添加Sys_DictKey对象(即:一条记录)
/// </summary>
public int Add(Sys_DictKey sys_DictKey)
{
string sql = "INSERT INTO Sys_DictKey (TABLENAME,TABLEID,ModuleCode,PrefixCode,CodeLenth) VALUES (@TABLENAME,@TABLEID,@ModuleCode,@PrefixCode,@CodeLenth)";
if (string.IsNullOrEmpty(sys_DictKey.TABLEID))
{
idb.AddParameter("@TABLEID", "''");
}
else
{
idb.AddParameter("@TABLEID", sys_DictKey.TABLEID);
}
if (string.IsNullOrEmpty(sys_DictKey.ModuleCode))
{
idb.AddParameter("@ModuleCode", DBNull.Value);
}
else
{
idb.AddParameter("@ModuleCode", sys_DictKey.ModuleCode);
}
if (string.IsNullOrEmpty(sys_DictKey.PrefixCode))
{
idb.AddParameter("@PrefixCode", DBNull.Value);
}
else
{
idb.AddParameter("@PrefixCode", sys_DictKey.PrefixCode);
}
if (sys_DictKey.CodeLenth == 0)
{
idb.AddParameter("@CodeLenth", 0);
}
else
{
idb.AddParameter("@CodeLenth", sys_DictKey.CodeLenth);
}
return idb.ExeCmd(sql);
}
/// <summary>
/// 更新Sys_DictKey对象(即:一条记录
/// </summary>
public int Update(Sys_DictKey sys_DictKey)
{
StringBuilder sbParameter=new StringBuilder();
StringBuilder sb=new StringBuilder();
sb.Append(@"UPDATE Sys_DictKey SET ");
if(sys_DictKey.TABLEID_IsChanged){sbParameter.Append("TABLEID=@TABLEID, ");}
if(sys_DictKey.ModuleCode_IsChanged){sbParameter.Append("ModuleCode=@ModuleCode, ");}
if(sys_DictKey.PrefixCode_IsChanged){sbParameter.Append("PrefixCode=@PrefixCode, ");}
if(sys_DictKey.CodeLenth_IsChanged){sbParameter.Append("CodeLenth=@CodeLenth ");}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append( " WHERE 1=1 AND ((Stat is null) or (Stat=0)) and TABLENAME=@TABLENAME; " );
string sql=sb.ToString();
if(sys_DictKey.TABLEID_IsChanged)
{
if (string.IsNullOrEmpty(sys_DictKey.TABLEID))
{
idb.AddParameter("@TABLEID", "''");
}
else
{
idb.AddParameter("@TABLEID", sys_DictKey.TABLEID);
}
}
if(sys_DictKey.ModuleCode_IsChanged)
{
if (string.IsNullOrEmpty(sys_DictKey.ModuleCode))
{
idb.AddParameter("@ModuleCode", DBNull.Value);
}
else
{
idb.AddParameter("@ModuleCode", sys_DictKey.ModuleCode);
}
}
if(sys_DictKey.PrefixCode_IsChanged)
{
if (string.IsNullOrEmpty(sys_DictKey.PrefixCode))
{
idb.AddParameter("@PrefixCode", DBNull.Value);
}
else
{
idb.AddParameter("@PrefixCode", sys_DictKey.PrefixCode);
}
}
if(sys_DictKey.CodeLenth_IsChanged)
{
if (sys_DictKey.CodeLenth == 0)
{
idb.AddParameter("@CodeLenth", 0);
}
else
{
idb.AddParameter("@CodeLenth", sys_DictKey.CodeLenth);
}
}
idb.AddParameter("@TABLENAME", sys_DictKey.TABLENAME);
return idb.ExeCmd(sql);
/// <summary>
/// 获取指定的Sys_DictKey对象集合
/// </summary>
public List<Sys_DictKey> GetListByWhere(string strCondition)
{
List<Sys_DictKey> ret = new List<Sys_DictKey>();
string sql = "SELECT TABLENAME,TABLEID,ID,ModuleCode,PrefixCode,CodeLenth FROM Sys_DictKey WHERE 1=1 AND ((Stat is null) or (Stat=0) ) ";
if(!string.IsNullOrEmpty(strCondition))
{
strCondition.Replace('\'','"'); //防sql注入
sql += strCondition ;
}
sql += " ORDER BY TABLENAME DESC ";
SqlDataReader dr=null;
try {
dr=(SqlDataReader)idb.ReturnReader(sql);
while(dr.Read())
{
Sys_DictKey sys_DictKey = new Sys_DictKey();
if (dr["TABLENAME"] != DBNull.Value) sys_DictKey.TABLENAME = Convert.ToString(dr["TABLENAME"]);
if (dr["TABLEID"] != DBNull.Value) sys_DictKey.TABLEID = Convert.ToString(dr["TABLEID"]);
if (dr["ID"] != DBNull.Value) sys_DictKey.ID = Convert.ToInt32(dr["ID"]);
if (dr["ModuleCode"] != DBNull.Value) sys_DictKey.ModuleCode = Convert.ToString(dr["ModuleCode"]);
if (dr["PrefixCode"] != DBNull.Value) sys_DictKey.PrefixCode = Convert.ToString(dr["PrefixCode"]);
if (dr["CodeLenth"] != DBNull.Value) sys_DictKey.CodeLenth = Convert.ToInt32(dr["CodeLenth"]);
ret.Add(sys_DictKey);
}
}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>
/// 获取指定的Sys_DictKey对象(即:一条记录
/// </summary>
public Sys_DictKey GetByKey(string tABLENAME)
{
Sys_DictKey sys_DictKey = new Sys_DictKey();
string sql = "SELECT TABLENAME,TABLEID,ID,ModuleCode,PrefixCode,CodeLenth FROM Sys_DictKey WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND TABLENAME=@TABLENAME ";
idb.AddParameter("@TABLENAME", tABLENAME);
SqlDataReader dr=null;
try {
dr=(SqlDataReader)idb.ReturnReader(sql);
while(dr.Read())
{
if (dr["TABLENAME"] != DBNull.Value) sys_DictKey.TABLENAME = Convert.ToString(dr["TABLENAME"]);
if (dr["TABLEID"] != DBNull.Value) sys_DictKey.TABLEID = Convert.ToString(dr["TABLEID"]);
if (dr["ID"] != DBNull.Value) sys_DictKey.ID = Convert.ToInt32(dr["ID"]);
if (dr["ModuleCode"] != DBNull.Value) sys_DictKey.ModuleCode = Convert.ToString(dr["ModuleCode"]);
if (dr["PrefixCode"] != DBNull.Value) sys_DictKey.PrefixCode = Convert.ToString(dr["PrefixCode"]);
if (dr["CodeLenth"] != DBNull.Value) sys_DictKey.CodeLenth = Convert.ToInt32(dr["CodeLenth"]);
}
}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 sys_DictKey;
}
/// <summary>
/// 获取所有的Sys_DictKey对象(即:一条记录
/// </summary>
public List<Sys_DictKey> GetAll()
{
List<Sys_DictKey> ret = new List<Sys_DictKey>();
string sql = "SELECT TABLENAME,TABLEID,ID,ModuleCode,PrefixCode,CodeLenth FROM Sys_DictKey where 1=1 AND ((Stat is null) or (Stat=0) ) order by TABLENAME desc ";
SqlDataReader dr=null;
try {
dr=(SqlDataReader)idb.ReturnReader(sql);
while(dr.Read())
{
Sys_DictKey sys_DictKey = new Sys_DictKey();
if (dr["TABLENAME"] != DBNull.Value) sys_DictKey.TABLENAME = Convert.ToString(dr["TABLENAME"]);
if (dr["TABLEID"] != DBNull.Value) sys_DictKey.TABLEID = Convert.ToString(dr["TABLEID"]);
if (dr["ID"] != DBNull.Value) sys_DictKey.ID = Convert.ToInt32(dr["ID"]);
if (dr["ModuleCode"] != DBNull.Value) sys_DictKey.ModuleCode = Convert.ToString(dr["ModuleCode"]);
if (dr["PrefixCode"] != DBNull.Value) sys_DictKey.PrefixCode = Convert.ToString(dr["PrefixCode"]);
if (dr["CodeLenth"] != DBNull.Value) sys_DictKey.CodeLenth = Convert.ToInt32(dr["CodeLenth"]);
ret.Add(sys_DictKey);
}
}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;
}
