public void Update(RoleUserRelation item)
{
if(item.ChangedPropertyCount>0)
{
StringBuilder sqlbuilder = new StringBuilder();
sqlbuilder.Append("UPDATE [RoleUserRelation] SET ");
Dictionary<string,string> cols =new Dictionary<string,string>();
cols.Add("LastUpdateUserUID","[LastUpdateUserUID]");
cols.Add("LastUpdateUserName","[LastUpdateUserName]");
cols.Add("LastUpdateTime","[LastUpdateTime]");
int i = 0;
//UPDATE COLUMNS
foreach (string p in item.ChangedPropertyList)
{
if(!cols.ContainsKey(p))
{
continue;
}
if (i > 0)
{
sqlbuilder.Append(",");
}
sqlbuilder.AppendFormat("{0}=@{1}", cols[p], p);
i++;
}
//WHERE;
sqlbuilder.Append(" WHERE [RoleID]=@RoleID");
List<SqlParameter> SPParams = new List<SqlParameter>();
SPParams.Add(new SqlParameter("@RoleID",item.RoleID));
SPParams.Add(new SqlParameter("@UserUID",item.UserUID));
if(item.IsChanged("LastUpdateUserUID"))
{
SPParams.Add(new SqlParameter("@LastUpdateUserUID",item.LastUpdateUserUID));
}
if(item.IsChanged("LastUpdateUserName"))
{
SPParams.Add(new SqlParameter("@LastUpdateUserName",item.LastUpdateUserName));
}
if(item.IsChanged("LastUpdateTime"))
{
SPParams.Add(new SqlParameter("@LastUpdateTime",item.LastUpdateTime));
}
base.ExecuteNonQuery(sqlbuilder.ToString(), SPParams.ToArray());
}
}
public void Save(RoleUserRelation item)
{
if(item.IsNew)
{
Insert(item);
}
else
{
Update(item);
}
}
public void Insert(RoleUserRelation item)
{
string sql="INSERT INTO [RoleUserRelation] ([RoleID],[UserUID],[LastUpdateUserUID],[LastUpdateUserName],[LastUpdateTime]) VALUES (@RoleID,@UserUID,@LastUpdateUserUID,@LastUpdateUserName,@LastUpdateTime)";
List<SqlParameter> SPParams = new List<SqlParameter>();
SPParams.Add(new SqlParameter("@RoleID",item.RoleID));
SPParams.Add(new SqlParameter("@UserUID",item.UserUID));
SPParams.Add(new SqlParameter("@LastUpdateUserUID",item.LastUpdateUserUID));
SPParams.Add(new SqlParameter("@LastUpdateUserName",item.LastUpdateUserName));
SPParams.Add(new SqlParameter("@LastUpdateTime",item.LastUpdateTime));
base.ExecuteNonQuery(sql, SPParams.ToArray());
}
public List<RoleUserRelation> QueryAll()
{
string sql ="SELECT [RoleID],[UserUID],[LastUpdateUserUID],[LastUpdateUserName],[LastUpdateTime] FROM [RoleUserRelation]";
List<RoleUserRelation> list =new List<RoleUserRelation>();
using(IDataReader reader = base.ExcuteDataReader(sql))
{
while(reader.Read())
{
RoleUserRelation item =new RoleUserRelation();
item.RoleID = reader.GetInt32(0);
item.UserUID = reader.GetString(1);
item.LastUpdateUserUID = reader.GetString(2);
item.LastUpdateUserName = reader.GetString(3);
item.LastUpdateTime = reader.GetDateTime(4);
list.Add(item);
}
}
return list;
}
public RoleUserRelation Get(int key)
{
string sql = "SELECT [RoleID],[UserUID],[LastUpdateUserUID],[LastUpdateUserName],[LastUpdateTime] FROM [RoleUserRelation] WHERE [RoleID]=@RoleID";
SqlParameter p =new SqlParameter("@RoleID",key);
RoleUserRelation item =null;
using(IDataReader reader = base.ExcuteDataReader(sql,p))
{
if(reader.Read())
{
item =new RoleUserRelation();
item.RoleID = reader.GetInt32(0);
item.UserUID = reader.GetString(1);
item.LastUpdateUserUID = reader.GetString(2);
item.LastUpdateUserName = reader.GetString(3);
item.LastUpdateTime = reader.GetDateTime(4);
}
}
return item;
}