public void Update(Privilege item)
{
if(item.ChangedPropertyCount>0)
{
StringBuilder sqlbuilder = new StringBuilder();
sqlbuilder.Append("UPDATE [Privileges] SET ");
Dictionary<string,string> cols =new Dictionary<string,string>();
cols.Add("PrivilegeName","[PrivilegeName]");
cols.Add("PrivilegeType","[PrivilegeType]");
cols.Add("Remark","[Remark]");
cols.Add("ParentID","[ParentID]");
cols.Add("Uri","[Uri]");
cols.Add("Sequence","[Sequence]");
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 [PrivilegeCode]=@PrivilegeCode");
List<SqlParameter> SPParams = new List<SqlParameter>();
SPParams.Add(new SqlParameter("@PrivilegeCode",item.PrivilegeCode));
if(item.IsChanged("PrivilegeName"))
{
SPParams.Add(new SqlParameter("@PrivilegeName",item.PrivilegeName));
}
if(item.IsChanged("PrivilegeType"))
{
SPParams.Add(new SqlParameter("@PrivilegeType",item.PrivilegeType));
}
if(item.IsChanged("Remark"))
{
SPParams.Add(new SqlParameter("@Remark",item.Remark));
}
if(item.IsChanged("ParentID"))
{
SPParams.Add(new SqlParameter("@ParentID",item.ParentID));
}
if(item.IsChanged("Uri"))
{
SPParams.Add(new SqlParameter("@Uri",item.Uri));
}
if(item.IsChanged("Sequence"))
{
SPParams.Add(new SqlParameter("@Sequence",item.Sequence));
}
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());
}
}
