static List <AutoObject> DataReaderToAutoObject(SqlDataReader reader)
{
List <AutoObject> lst = new List <AutoObject>();
while (reader.Read())
{
List <AutoItem> items = new List <AutoItem>();
for (int i = 0; i < reader.FieldCount; i++)
{
AutoItem p = new AutoItem();
p.CSharpType = reader.GetFieldType(i).FullName;
p.Name = reader.GetName(i); //p.SqlType = Lambda.Framework.BMIConvert.GetSqlTypeFromStringType(reader.GetDataTypeName(i));
//p.SqlType = reader.GetDataTypeName(i);
var value = reader.GetValue(i);
p.Value = value;
if (p.Value == DBNull.Value)
{
p.Value = null;
}
items.Add(p);
}
AutoObject d = new AutoObject();
d.Items = items;
lst.Add(d);
}
reader.Close();
return(lst);
}
//public static List<T> CreateListBus<T>(List<AutoObject> items) where T : Bus
//{
// List<T> listBus = new List<T>();
// for (int i = 0; i < items.Count; i++)
// {
// T x = (T)Activator.CreateInstance(typeof(T), items[i]);
// x.MakeUnchange();
// listBus.Add(x);
// }
// return listBus;
//}
//public static List<AutoObject> CreateListAuto<T>(List<T> listBus) where T : Bus
//{
// var listAuto = new List<AutoObject>();
// for (int i = 0; i < listBus.Count; i++)
// {
// listAuto.Add(listBus[i].DataToAutoObject());
// }
// return listAuto;
//}
//public static List<T> GetListWithState<T>(List<T> listBus, RowState state) where T : Bus
//{
// var result = new List<T>();
// for (int i = 0; i < listBus.Count; i++)
// if ((listBus[i].State & state) == listBus[i].State)
// result.Add(listBus[i]);
// return result;
//}
//static List<AutoObject> CreateListAutoParams<T>(params List<T>[] arraylistBus) where T : Bus
//{
// var result = new List<AutoObject>();
// for (int i = 0; i < arraylistBus.Length; i++)
// {
// //result.AddRange(CreateListAuto(GetListWithState(arraylistBus[i],RowState.Insert | RowState.Update | RowState.Delete)));
// var tmp = BusinessAction.GetBusinessObjectWithState(arraylistBus[i], RowState.Insert | RowState.Update | RowState.Delete);
// result.AddRange(BusinessAction.ToAutoObject(tmp));
// }
// return result;
//}
#region Get
public List <T> Get <T>(AutoObject item, bool?isCache = null, long?MinuteToCache = null) where T : Bus
{
//return CreateListBus<T>(GetInvoke(item,isCache,MinuteToCache));
var result = GetInvoke(item, isCache, MinuteToCache);
return(BusinessAction.ToBusinessObject <T>(result));
}
private static AutoItem FindVersion(AutoObject dataItem)
{
if (dataItem == null)
{
return(null);
}
for (int i = 0; i < dataItem.Items.Count; i++)
{
if (dataItem.Items[i].SqlType == SqlDbType.Timestamp)
{
return(dataItem.Items[i]);
}
}
return(null);
}
public static string ExecuteQueryToTableXML(string ConnectionStringName, AutoObject item)
{
using (SqlConnection con = GetConnection(ConnectionStringName))
{
con.Open();
List <SqlParameter> Sqlparam = item.Items.ToSqlParameter();
var reader = ExecuteReader(item.SpName, Sqlparam, con);
var table = new DataTable(item.SpName);
table.Load(reader);
reader.Close();
con.Close();
using (StringWriter sw = new StringWriter())
{
table.WriteXml(sw, XmlWriteMode.WriteSchema);
return(sw.ToString());
}
}
}
protected virtual List <AutoObject> GetInvoke(AutoObject item, bool?isCache = null, long?MinuteToCache = null)
{
var p = Proxy;
Request request = new Request();
request.DataItem = item;
PreRequest(request, isCache, MinuteToCache);
var response = p.GetData(request);
if (response.Acknowledge == AcknowledgeType.Failure)
{
throw new Exception(response.Message);
}
if (request.RequestId != response.CorrelationId)
{
throw new Exception(string.Format("ReservationId:{0}", response.ReservationId));
}
return(response.DataItems);
}
public static List <AutoObject> ExecuteQuery(string ConnectionStringName, AutoObject item, bool Caching = false, long MinuteToCache = 60)
{
List <AutoObject> data;
string key = AutoMemCached.MakeKey(ConnectionStringName, item);
if (Caching == true)
{
data = AutoMemCached.Get(key);
if (data != null && data.Count > 0)
{
return(data);
}
}
//Get data from database
data = ExecuteQuery(ConnectionStringName, item.SpName, item.Items);
AutoMemCached.Add(key, data, DateTimeOffset.Now.AddMinutes(MinuteToCache));
return(data);
}
public static string MakeKey(string ConnectionStringName, AutoObject item)
{
return(MakeKey(ConnectionStringName, item.SpName, item.Items));
}
public ServiceItem(AutoObject value)
{
OnCreating();
DataFromAutoObject(value);
OnCreated();
}
public DataTable GetDataTable(AutoObject item, bool?isCache = null, long?MinuteToCache = null)
{
return(DataTableFromAutoObject(GetInvoke(item), item.SpName));
}
public int SetAutoObject(AutoObject item, string KeyService = null)
{
var response = SetInvoke(item, KeyService);
return(response.RowsAffected);
}
protected Response SetInvoke(AutoObject item, string KeyService = null)
{
return(SetInvoke(new List <AutoObject> {
item
}, KeyService));
}
public List <AutoObject> GetAutoObject(AutoObject item, bool?isCache = null, long?MinuteToCache = null)
{
return(GetInvoke(item, isCache, MinuteToCache));
}
public BanggiaModel(AutoObject value)
{
OnCreating();
DataFromAutoObject(value);
OnCreated();
}
public ChitietHoadonModel(AutoObject value)
{
OnCreating();
DataFromAutoObject(value);
OnCreated();
}
public _UserModel(AutoObject value)
{
OnCreating();
DataFromAutoObject(value);
OnCreated();
}
public NhomHanghoaModel(AutoObject value)
{
OnCreating();
DataFromAutoObject(value);
OnCreated();
}
