public virtual SqlCommand GetSqlCommandForGetGetCustomValues(DescriptorColection colection, string tableName)
{
string selectCustom = @"SELECT * FROM " + tableName + " ";
if (colection.ListField != null && colection.ListField.Count > 0)
{
//Truong hop chi lay 1 vai truong cu the
var field = "";
for (int i = 0; i < colection.ListField.Count; i++)
{
if (i == colection.ListField.Count - 1)
{
field += colection.ListField[i]; //Bo qua dau phay cuoi cung
}
else
{
field += colection.ListField[i] + ",";
}
}
if (!string.IsNullOrEmpty(field))
{
selectCustom = string.Format(@"SELECT {0} FROM " + tableName + " ", field);
}
}
if (colection != null && colection.Descriptors.Count > 0)
{
selectCustom += DescriptorUtil.GetWhereString(colection);
}
var sqlcommand = new SqlCommand {
CommandType = CommandTypeText, CommandText = selectCustom
};
return(sqlcommand);
}
public static List <MemberInfo> GetListMemberInCustomerVangLai()
{
//Lay tat ca member la nhom khach hang
try
{
//Select * from MemberInfo where MemberType = 3 and CustomerGroup = 3
var entityQry = new EntityQuery
{
EntityName = MemberInfo.EntityName(),
QueryAction = EntityGet.GetCustomValues
};
var colection = new DescriptorColection
{
Logical = LogicalOperator.AND
};
var descriptorSession = new Descriptor {
Logical = LogicalOperator.AND
};
descriptorSession.Descriptors.Add(new Descriptor
{
FieldName = MemberInfo.MemberInfoFields.MemberType.ToString(),
FieldValue = Descriptor.GetInputValue((int)MemberType.Customer),
Operator = DataOperator.IsEqualTo
});
descriptorSession.Descriptors.Add(new Descriptor
{
FieldName = MemberInfo.MemberInfoFields.CustomerGroup.ToString(),
FieldValue = Descriptor.GetInputValue((int)CustomerGroup.VL),
Operator = DataOperator.IsEqualTo
});
colection.Descriptors.Add(descriptorSession);
entityQry.DescriptorColection = colection;
entityQry = GetEntityQuery(entityQry);
if (entityQry.ReturnValue != null)
{
var listValue = entityQry.ReturnValue.Select(baseEntity =>
baseEntity.GetEntity() as MemberInfo).ToList();
return(listValue);
}
}
catch (Exception ex)
{
LogTo.Error(ex.ToString());
}
return(new List <MemberInfo>());
}
public static string GetWhereString(DescriptorColection colection)
{
try
{
if (colection == null)
{
return(string.Empty);
}
var agrs = GetStringByList(colection.Logical, colection.Descriptors);
if (string.IsNullOrWhiteSpace(agrs))
{
return(string.Empty);
}
return(" WHERE " + agrs);
}
catch (Exception ex)
{
LogTo.Error(ex.ToString());
}
return(string.Empty);
}
