public override void UpdateCorporation(CorporationInfo entity) { SerializerData data = entity.GetSerializerData(); string sql = @" UPDATE ComOpp_Corporation set Name = @Name ,PropertyNames=@PropertyNames ,PropertyValues=@PropertyValues WHERE ID=@ID"; SqlParameter[] parameters = { new SqlParameter("@ID", entity.ID), new SqlParameter("@Name", entity.Name), new SqlParameter("@PropertyNames", data.Keys), new SqlParameter("@PropertyValues", data.Values) }; SqlHelper.ExecuteNonQuery(_con, CommandType.Text, sql, parameters); }
public override void AddCorporation(CorporationInfo entity) { string sql = @"INSERT INTO ComOpp_Corporation( [Name] ,[Sort] ,[PropertyNames] ,[PropertyValues] )VALUES( @Name ,(SELECT ISNULL(MAX([Sort]),0) + 1 FROM ComOpp_Corporation) ,@PropertyNames ,@PropertyValues )"; SerializerData data = entity.GetSerializerData(); SqlParameter[] p = { new SqlParameter("@Name",entity.Name), new SqlParameter("@PropertyNames", data.Keys), new SqlParameter("@PropertyValues", data.Values) }; SqlHelper.ExecuteNonQuery(_con, CommandType.Text, sql, p); }