/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override SupplierGroupInfo DataReaderToEntity(IDataReader dataReader)
{
SupplierGroupInfo info = new SupplierGroupInfo();
SmartDataReader reader = new SmartDataReader(dataReader);
info.ID = reader.GetString("ID");
info.PID = reader.GetString("PID");
info.HandNo = reader.GetString("HandNo");
info.Name = reader.GetString("Name");
info.Note = reader.GetString("Note");
info.Creator = reader.GetString("Creator");
info.CreateTime = reader.GetDateTime("CreateTime");
info.Editor = reader.GetString("Editor");
info.EditTime = reader.GetDateTime("EditTime");
info.Dept_ID = reader.GetString("Dept_ID");
info.Company_ID = reader.GetString("Company_ID");
return(info);
}
//-----------------------------------------------------------
#region Method
private List <Customers> Init(SqlCommand cmd)
{
SqlConnection con = db.getConnection();
cmd.Connection = con;
List <Customers> l_Customers = new List <Customers>();
try
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
SmartDataReader smartReader = new SmartDataReader(reader);
while (smartReader.Read())
{
Customers m_Customers = new Customers();
m_Customers.CustomerId = smartReader.GetInt32("CustomerId");
m_Customers.FullName = smartReader.GetString("FullName");
m_Customers.Mobile = smartReader.GetString("Mobile");
m_Customers.Email = smartReader.GetString("Email");
m_Customers.Address = smartReader.GetString("Address");
m_Customers.GenderId = smartReader.GetByte("GenderId");
m_Customers.CustomerGroupId = smartReader.GetInt16("CustomerGroupId");
m_Customers.Note = smartReader.GetString("Note");
m_Customers.StatusId = smartReader.GetByte("StatusId");
m_Customers.DebitBalance = smartReader.GetFloat("DebitBalance");
m_Customers.PaymentLimit = smartReader.GetFloat("PaymentLimit");
m_Customers.DateOfBirth = smartReader.GetDateTime("DateOfBirth");
m_Customers.LastTradingDay = smartReader.GetDateTime("LastTradingDay");
m_Customers.CrDateTime = smartReader.GetDateTime("CrDateTime");
l_Customers.Add(m_Customers);
}
reader.Close();
return(l_Customers);
}
catch (SqlException err)
{
throw new ApplicationException("Data error: " + err.Message);
}
finally
{
db.closeConnection(con);
}
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override Mst_GoodsInfo DataReaderToEntity(IDataReader dataReader)
{
Mst_GoodsInfo info = new Mst_GoodsInfo();
SmartDataReader reader = new SmartDataReader(dataReader);
info.F_ProDate = reader.GetDateTime("F_ProDate");
info.F_ExpiratDate = reader.GetDateTime("F_ExpiratDate");
info.F_Id = reader.GetString("F_Id");
info.F_GoodsId = reader.GetString("F_GoodsId");
info.F_Batch = reader.GetString("F_Batch");
info.F_EnCode = reader.GetString("F_EnCode");
info.F_FullName = reader.GetString("F_FullName");
info.F_CategoryID = reader.GetString("F_CategoryID");
info.F_SpecifModel = reader.GetString("F_SpecifModel");
info.F_Unit = reader.GetString("F_Unit");
info.F_Pic = reader.GetString("F_Pic");
info.F_ShelfLife = reader.GetString("F_ShelfLife");
info.F_SellingPrice = reader.GetString("F_SellingPrice");
info.F_PurchasePrice = reader.GetString("F_PurchasePrice");
info.F_BasicRate = reader.GetString("F_BasicRate");
info.F_SerialNum = reader.GetString("F_SerialNum");
info.F_FreeTerm2 = reader.GetString("F_FreeTerm2");
info.F_Long = reader.GetString("F_Long");
info.F_Wide = reader.GetString("F_Wide");
info.F_Height = reader.GetString("F_Height");
info.F_NetWeight = reader.GetString("F_NetWeight");
info.F_GrossWeight = reader.GetString("F_GrossWeight");
info.F_Volume = reader.GetString("F_Volume");
info.F_SortCode = reader.GetInt32("F_SortCode");
info.F_Description = reader.GetString("F_Description");
info.F_DeleteMark = reader.GetBoolean("F_DeleteMark");
info.F_EnabledMark = reader.GetBoolean("F_EnabledMark");
info.F_OpenConfigure = reader.GetBoolean("F_OpenConfigure");
info.F_OpenBatch = reader.GetBoolean("F_OpenBatch");
info.F_CreatorTime = reader.GetDateTime("F_CreatorTime");
info.F_CreatorUserId = reader.GetString("F_CreatorUserId");
info.F_LastModifyUserId = reader.GetString("F_LastModifyUserId");
info.F_LastModifyTime = reader.GetDateTime("F_LastModifyTime");
info.F_DeleteTime = reader.GetDateTime("F_DeleteTime");
info.F_DeleteUserId = reader.GetString("F_DeleteUserId");
return(info);
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override ComingCallInfo DataReaderToEntity(IDataReader dataReader)
{
ComingCallInfo info = new ComingCallInfo();
SmartDataReader reader = new SmartDataReader(dataReader);
info.ID = reader.GetInt32("ID");
info.Customer_ID = reader.GetString("Customer_ID");
info.Contact = reader.GetString("Contact");
info.CallNumber = reader.GetString("CallNumber");
info.CallDate = reader.GetDateTime("CallDate");
info.Note = reader.GetString("Note");
info.Creator = reader.GetString("Creator");
info.CreateTime = reader.GetDateTime("CreateTime");
info.Editor = reader.GetString("Editor");
info.EditTime = reader.GetDateTime("EditTime");
info.Dept_ID = reader.GetString("Dept_ID");
info.Company_ID = reader.GetString("Company_ID");
return(info);
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override YH_DeviceControlInfo DataReaderToEntity(IDataReader dataReader)
{
YH_DeviceControlInfo info = new YH_DeviceControlInfo();
SmartDataReader reader = new SmartDataReader(dataReader);
info.ID = reader.GetString("ID");
info.Ip = reader.GetString("ip");
info.Port = reader.GetInt32("port");
info.Appid = reader.GetString("appid");
info.Appsecret = reader.GetString("appsecret");
info.Serviceid = reader.GetString("serviceid");
info.Deviceid = reader.GetString("deviceid");
info.Cmd = reader.GetString("cmd");
info.Attribute = reader.GetString("attribute");
info.Ifint = reader.GetBoolean("ifint");
info.Data = reader.GetString("data");
return(info);
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override SO_HeadInfo DataReaderToEntity(IDataReader dataReader)
{
SO_HeadInfo info = new SO_HeadInfo();
SmartDataReader reader = new SmartDataReader(dataReader);
info.F_AuditingUser = reader.GetString("F_AuditingUser");
info.F_Description = reader.GetString("F_Description");
info.F_VeriDate = reader.GetDateTime("F_VeriDate");
info.F_CustomerId = reader.GetString("F_CustomerId");
info.F_Address = reader.GetString("F_Address");
info.F_Operator = reader.GetString("F_Operator");
info.F_Status = reader.GetString("F_Status");
info.F_Date = reader.GetDateTime("F_Date");
info.F_WarehouseId = reader.GetString("F_WarehouseId");
info.F_WarehouseName = reader.GetString("F_WarehouseName");
info.F_TelePhone = reader.GetString("F_TelePhone");
info.F_Contacts = reader.GetString("F_Contacts");
info.F_Id = reader.GetString("F_Id");
info.F_EnCode = reader.GetString("F_EnCode");
info.F_OutSMark = reader.GetString("F_OutSMark");
info.F_CustomerName = reader.GetString("F_CustomerName");
info.F_SortCode = reader.GetInt32("F_SortCode");
info.F_DeleteMark = reader.GetBoolean("F_DeleteMark");
info.F_EnabledMark = reader.GetBoolean("F_EnabledMark");
info.F_CreatorTime = reader.GetDateTime("F_CreatorTime");
info.F_CreatorUserId = reader.GetString("F_CreatorUserId");
info.F_LastModifyUserId = reader.GetString("F_LastModifyUserId");
info.F_LastModifyTime = reader.GetDateTime("F_LastModifyTime");
info.F_DeleteTime = reader.GetDateTime("F_DeleteTime");
info.F_DeleteUserId = reader.GetString("F_DeleteUserId");
info.F_FreeTerm1 = reader.GetString("F_FreeTerm1");
info.F_FreeTerm2 = reader.GetString("F_FreeTerm2");
info.F_FreeTerm3 = reader.GetString("F_FreeTerm3");
info.F_FreeTerm4 = reader.GetString("F_FreeTerm4");
info.F_FreeTerm5 = reader.GetString("F_FreeTerm5");
info.F_FreeTerm6 = reader.GetString("F_FreeTerm6");
info.F_FreeTerm7 = reader.GetString("F_FreeTerm7");
info.F_FreeTerm8 = reader.GetString("F_FreeTerm8");
info.F_FreeTerm9 = reader.GetString("F_FreeTerm9");
info.F_FreeTerm10 = reader.GetString("F_FreeTerm10");
return(info);
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override PurchaseHeaderInfo DataReaderToEntity(IDataReader dataReader)
{
PurchaseHeaderInfo purchaseHeaderInfo = new PurchaseHeaderInfo();
SmartDataReader reader = new SmartDataReader(dataReader);
purchaseHeaderInfo.ID = reader.GetInt32("ID");
purchaseHeaderInfo.HandNo = reader.GetString("HandNo");
purchaseHeaderInfo.OperationType = reader.GetString("OperationType");
purchaseHeaderInfo.Manufacture = reader.GetString("Manufacture");
purchaseHeaderInfo.WareHouse = reader.GetString("WareHouse");
purchaseHeaderInfo.CostCenter = reader.GetString("CostCenter");
purchaseHeaderInfo.Note = reader.GetString("Note");
purchaseHeaderInfo.CreateDate = reader.GetDateTime("CreateDate");
purchaseHeaderInfo.Creator = reader.GetString("Creator");
purchaseHeaderInfo.CreateYear = reader.GetInt32("CreateYear");
purchaseHeaderInfo.CreateMonth = reader.GetInt32("CreateMonth");
purchaseHeaderInfo.PickingPeople = reader.GetString("PickingPeople");
return(purchaseHeaderInfo);
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override FileUploadInfo DataReaderToEntity(IDataReader dataReader)
{
FileUploadInfo info = new FileUploadInfo();
SmartDataReader reader = new SmartDataReader(dataReader);
info.ID = reader.GetString("ID");
info.AttachmentGUID = reader.GetString("AttachmentGUID");
info.FileName = reader.GetString("FileName");
info.BasePath = reader.GetString("BasePath");
info.SavePath = reader.GetString("SavePath");
info.Category = reader.GetString("Category");
info.FileSize = reader.GetInt32("FileSize");
info.FileExtend = reader.GetString("FileExtend");
info.Editor = reader.GetString("Editor");
info.AddTime = reader.GetDateTime("AddTime");
info.DeleteFlag = reader.GetInt32("DeleteFlag");
return(info);
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override LoginLogInfo DataReaderToEntity(IDataReader dataReader)
{
LoginLogInfo info = new LoginLogInfo();
SmartDataReader reader = new SmartDataReader(dataReader);
info.ID = reader.GetInt32("ID");
info.User_ID = reader.GetString("User_ID");
info.LoginName = reader.GetString("LoginName");
info.FullName = reader.GetString("FullName");
info.Company_ID = reader.GetString("Company_ID");
info.CompanyName = reader.GetString("CompanyName");
info.Note = reader.GetString("Note");
info.IPAddress = reader.GetString("IPAddress");
info.MacAddress = reader.GetString("MacAddress");
info.LastUpdated = reader.GetDateTime("LastUpdated");
info.SystemType_ID = reader.GetString("SystemType_ID");
return(info);
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override OperationLogInfo DataReaderToEntity(IDataReader dataReader)
{
OperationLogInfo info = new OperationLogInfo();
SmartDataReader reader = new SmartDataReader(dataReader);
info.Id = reader.GetInt32("Id"); //ID序号
info.UserId = reader.GetInt32("UserId"); //用户Id
info.Name = reader.GetString("Name"); //名称
info.LoginName = reader.GetString("LoginName"); //登录名
info.CompanyId = reader.GetInt32("CompanyId"); //公司Id
info.CompanyName = reader.GetString("CompanyName"); //公司名字
info.TableName = reader.GetString("TableName"); //表名
info.OperationType = reader.GetInt16("OperationType"); //操作类型
info.Remark = reader.GetString("Remark"); //备注
info.IP = reader.GetString("IP"); //IP地址
info.Mac = reader.GetString("Mac"); //Mac地址
info.CreatorTime = reader.GetDateTime("CreatorTime"); //创建时间
return(info);
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override Entity.MidConcentrator DataReaderToEntity(IDataReader dataReader)
{
Entity.MidConcentrator info = new Entity.MidConcentrator();
SmartDataReader reader = new SmartDataReader(dataReader);
info.VcClientIP = reader.GetString("VcClientIP");
info.NvcName = reader.GetString("NvcName");
info.NvcAddr = reader.GetString("NvcAddr");
info.VcAddr = reader.GetString("VcAddr");
info.IntProtocol = reader.GetInt32("IntProtocol");
info.IntCount = reader.GetInt32("IntCount");
info.IntCommMode = reader.GetInt32("IntCommMode");
info.IntCOM = reader.GetInt32("IntCOM");
info.VcParam = reader.GetString("VcParam");
info.VcSimNo = reader.GetString("VcSimNo");
info.IntStatus = reader.GetInt32("IntStatus");
return info;
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override YH08A_DeviceInfoRecInfo DataReaderToEntity(IDataReader dataReader)
{
YH08A_DeviceInfoRecInfo info = new YH08A_DeviceInfoRecInfo();
SmartDataReader reader = new SmartDataReader(dataReader);
info.Rowid = reader.GetInt32("rowid");
info.Timestamp = reader.GetString("timestamp");
info.Stamptime = reader.GetDateTime("stamptime");
info.Appid = reader.GetString("appid");
info.Serviceid = reader.GetString("serviceid");
info.Deviceid = reader.GetString("deviceid");
info.Dob0 = reader.GetString("DOB0");
info.Dob1 = reader.GetString("DOB1");
info.Dob2 = reader.GetString("DOB2");
info.Dob3 = reader.GetString("DOB3");
info.Dob4 = reader.GetString("DOB4");
info.Dob5 = reader.GetString("DOB5");
info.Dob6 = reader.GetString("DOB6");
info.Dob7 = reader.GetString("DOB7");
info.Dob8 = reader.GetString("DOB8");
info.Dob9 = reader.GetString("DOB9");
info.DeviceNo = reader.GetString("deviceNo");
info.P = reader.GetString("P");
info.T = reader.GetString("T");
info.PressType = reader.GetString("PressType");
info.M_lCfC12_0 = reader.GetString("m_lCfC12_0");
info.M_lCfC12_1 = reader.GetString("m_lCfC12_1");
info.M_lCfC12_2 = reader.GetString("m_lCfC12_2");
info.M_lCfC12_3 = reader.GetString("m_lCfC12_3");
info.M_lCfC12_4 = reader.GetString("m_lCfC12_4");
info.M_lCfC12_5 = reader.GetString("m_lCfC12_5");
info.M_lCfC13_0 = reader.GetString("m_lCfC13_0");
info.M_lCfC13_1 = reader.GetString("m_lCfC13_1");
info.M_lCfC13_2 = reader.GetString("m_lCfC13_2");
info.M_lCfC13_3 = reader.GetString("m_lCfC13_3");
info.M_lCfC13_4 = reader.GetString("m_lCfC13_4");
info.M_lCfC13_5 = reader.GetString("m_lCfC13_5");
info.Aver = reader.GetString("Aver");
info.Se = reader.GetString("SE");
info.Recordtime = reader.GetDateTime("recordtime");
return(info);
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override XmlbInfo DataReaderToEntity(IDataReader dataReader)
{
XmlbInfo info = new XmlbInfo();
SmartDataReader reader = new SmartDataReader(dataReader);
info.ID = reader.GetString("ID");
info.PID = reader.GetString("PID");
info.Code = reader.GetString("Code");
info.Name = reader.GetString("Name");
info.ZXZD_ID = reader.GetString("ZXZD_ID");
info.LayerNumber = reader.GetInt32("LayerNumber");
info.Note = reader.GetString("Note");
info.Creator = reader.GetString("Creator");
info.CreateTime = reader.GetDateTime("CreateTime");
info.Editor = reader.GetString("Editor");
info.EditTime = reader.GetDateTime("EditTime");
return(info);
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override Entity.AccDetail DataReaderToEntity(IDataReader dataReader)
{
Entity.AccDetail info = new Entity.AccDetail();
SmartDataReader reader = new SmartDataReader(dataReader);
info.IntFeeID = reader.GetInt32("IntFeeID");
info.IntCustNo = reader.GetInt32("IntCustNo");
info.IntYearMon = reader.GetInt32("IntYearMon");
info.DteFee = reader.GetDateTime("DteFee");
info.VcAddr = reader.GetString("VcAddr");
info.IntStepOrd = reader.GetInt32("IntStepOrd");
info.IntType = reader.GetInt32("IntType");
info.NumFee = reader.GetDecimal("NumFee");
info.IntInvFlag = reader.GetInt32("IntInvFlag");
info.VcDesc = reader.GetString("VcDesc");
info.DtCreate = reader.GetDateTime("DtCreate");
return(info);
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override LoginLogInfo DataReaderToEntity(IDataReader dataReader)
{
LoginLogInfo info = new LoginLogInfo();
SmartDataReader reader = new SmartDataReader(dataReader);
info.Id = reader.GetInt32("Id");
info.UserId = reader.GetInt32("UserId");
info.LoginName = reader.GetString("LoginName");
info.FullName = reader.GetString("FullName");
info.CompanyId = reader.GetInt32("CompanyId");
info.CompanyName = reader.GetString("CompanyName");
info.Remark = reader.GetString("Remark");
info.IP = reader.GetString("IP");
info.Mac = reader.GetString("Mac");
info.LastUpdateTime = reader.GetDateTime("LastUpdateTime");
info.SystemtypeId = reader.GetString("SystemtypeId");
return(info);
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override FileUploadInfo DataReaderToEntity(IDataReader dataReader)
{
FileUploadInfo info = new FileUploadInfo();
SmartDataReader reader = new SmartDataReader(dataReader);
info.ID = reader.GetString("ID");
info.AttachmentGUID = reader.GetString("ATTACHMENTGUID");
info.FileName = reader.GetString("FILENAME");
info.BasePath = reader.GetString("BASEPATH");
info.SavePath = reader.GetString("SAVEPATH");
info.Category = reader.GetString("CATEGORY");
info.FileSize = reader.GetInt32("FILESIZE");
info.FileExtend = reader.GetString("FILEEXTEND");
info.Editor = reader.GetString("EDITOR");
info.AddTime = reader.GetDateTime("ADDTIME");
info.DeleteFlag = reader.GetInt32("DELETEFLAG");
return(info);
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override AddressGroupInfo DataReaderToEntity(IDataReader dataReader)
{
AddressGroupInfo info = new AddressGroupInfo();
SmartDataReader reader = new SmartDataReader(dataReader);
info.Id = reader.GetInt32("Id");
info.Pid = reader.GetInt32("Pid");
info.AddressType = Convert(reader.GetString("AddressType"));
info.Name = reader.GetString("Name");
info.Remark = reader.GetString("Note");
info.Seq = reader.GetString("Seq");
info.CreatorId = reader.GetInt32("CreatorId");
info.CreatorTime = reader.GetDateTime("CreateTime");
info.EditorId = reader.GetInt32("EditorId");
info.LastUpdateTime = reader.GetDateTime("EditTime");
info.DeptId = reader.GetInt32("DeptId");
info.CompanyId = reader.GetInt32("CompanyId");
return(info);
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override InStock_HeadInfo DataReaderToEntity(IDataReader dataReader)
{
InStock_HeadInfo info = new InStock_HeadInfo();
SmartDataReader reader = new SmartDataReader(dataReader);
info.F_Id = reader.GetString("F_Id");
info.F_EnCode = reader.GetString("F_EnCode");
info.F_OrganizationId = reader.GetString("F_OrganizationId");
info.F_WarehouseId = reader.GetString("F_WarehouseId");
info.F_SupplierId = reader.GetString("F_SupplierId");
info.F_SrTypeId = reader.GetString("F_SrTypeId");
info.F_OwnershipId = reader.GetString("F_OwnershipId");
info.F_Maker = reader.GetString("F_Maker");
info.F_Date = reader.GetDateTime("F_Date");
info.F_Verifier = reader.GetString("F_Verifier");
info.F_Veridate = reader.GetDateTime("F_Veridate");
info.F_Status = reader.GetInt32("F_Status");
info.F_SourceId = reader.GetString("F_SourceId");
info.F_SourceType = reader.GetString("F_SourceType");
info.F_SourceNo = reader.GetString("F_SourceNo");
info.F_Define1 = reader.GetString("F_Define1");
info.F_Define2 = reader.GetString("F_Define2");
info.F_Define3 = reader.GetString("F_Define3");
info.F_Define4 = reader.GetString("F_Define4");
info.F_Define5 = reader.GetString("F_Define5");
info.F_Define6 = reader.GetString("F_Define6");
info.F_Define7 = reader.GetString("F_Define7");
info.F_Define8 = reader.GetString("F_Define8");
info.F_Define9 = reader.GetString("F_Define9");
info.F_Define10 = reader.GetString("F_Define10");
info.F_Description = reader.GetString("F_Description");
info.F_SortCode = reader.GetInt32("F_SortCode");
info.F_DeleteMark = reader.GetBoolean("F_DeleteMark");
info.F_EnabledMark = reader.GetBoolean("F_EnabledMark");
info.F_CreatorTime = reader.GetDateTime("F_CreatorTime");
info.F_CreatorUserId = reader.GetString("F_CreatorUserId");
info.F_LastModifyTime = reader.GetDateTime("F_LastModifyTime");
info.F_LastModifyUserId = reader.GetString("F_LastModifyUserId");
info.F_DeleteTime = reader.GetDateTime("F_DeleteTime");
info.F_DeleteUserId = reader.GetString("F_DeleteUserId");
return(info);
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override Entity.AccDepositDetail DataReaderToEntity(IDataReader dataReader)
{
Entity.AccDepositDetail info = new Entity.AccDepositDetail();
SmartDataReader reader = new SmartDataReader(dataReader);
info.IntID = reader.GetInt32("IntID");
info.IntCustNo = reader.GetInt32("IntCustNo");
info.MonAmount = reader.GetDecimal("MonAmount");
info.IntType = reader.GetInt32("IntType");
info.VcFlowNo = reader.GetString("VcFlowNo");
info.VcUserID = reader.GetString("VcUserID");
info.VcReceiptNo = reader.GetString("VcReceiptNo");
info.DteAccount = reader.GetDateTime("DteAccount");
info.IntFlag = reader.GetInt32("IntFlag");
info.VcDesc = reader.GetString("VcDesc");
info.DtCreate = reader.GetDateTime("DtCreate");
return(info);
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override V_PACKLISTSELInfo DataReaderToEntity(IDataReader dataReader)
{
V_PACKLISTSELInfo info = new V_PACKLISTSELInfo();
SmartDataReader reader = new SmartDataReader(dataReader);
//info.F_Id = reader.GetString("F_Id");
//info.F_EnCode = reader.GetString("F_EnCode");
//info.F_FullName = reader.GetString("F_FullName");
info.F_ProductCode = reader.GetString("F_ProductCode");
info.F_ProductName = reader.GetString("F_ProductName");
info.F_ProductStandard = reader.GetString("F_ProductStandard");
info.F_ProdcuntBatchManagement = reader.GetString("F_ProdcuntBatchManagement");
info.F_Unit = reader.GetString("F_Unit");
info.F_Batch = reader.GetString("F_Batch");
info.F_WarehouseId = reader.GetString("F_WarehouseId");
info.F_WarehouseCode = reader.GetString("F_WarehouseCode");
info.F_WarehouseName = reader.GetString("F_WarehouseName");
info.F_PositionId = reader.GetString("F_PositionId");
info.F_PositionCode = reader.GetString("F_PositionCode");
info.F_PositionName = reader.GetString("F_PositionName");
info.F_ExpiryDate = reader.GetDateTime("F_ExpiryDate");
info.F_MadeDate = reader.GetDateTime("F_MadeDate");
info.F_HeadId = reader.GetString("F_HeadId");
info.F_Quantity = reader.GetDecimal("F_Quantity");
info.F_ProductId = reader.GetString("F_ProductId");
//info.F_Description = reader.GetString("F_Description");
//info.F_SortCode = reader.GetInt32("F_SortCode");
//info.F_DeleteMark = reader.GetBoolean("F_DeleteMark");
//info.F_EnabledMark = reader.GetBoolean("F_EnabledMark");
//info.F_CreatorTime = reader.GetDateTime("F_CreatorTime");
//info.F_CreatorUserId = reader.GetString("F_CreatorUserId");
//info.F_LastModifyTime = reader.GetDateTime("F_LastModifyTime");
//info.F_LastModifyUserId = reader.GetString("F_LastModifyUserId");
//info.F_DeleteTime = reader.GetDateTime("F_DeleteTime");
//info.F_DeleteUserId = reader.GetString("F_DeleteUserId");
return(info);
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override TableMappingInfo DataReaderToEntity(IDataReader dataReader)
{
TableMappingInfo info = new TableMappingInfo();
SmartDataReader reader = new SmartDataReader(dataReader);
info.ID = reader.GetString("ID");
info.TargetTable = reader.GetString("TargetTable");
info.SourceTable = reader.GetString("SourceTable");
info.ColYear = reader.GetString("ColYear");
info.ColMonth = reader.GetString("ColMonth");
info.ColDataConfig = reader.GetString("ColDataConfig");
info.Note = reader.GetString("Note");
info.Creator = reader.GetString("Creator");
info.CreateTime = reader.GetDateTime("CreateTime");
info.Editor = reader.GetString("Editor");
info.EditTime = reader.GetDateTime("EditTime");
return(info);
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override AddressGroupInfo DataReaderToEntity(IDataReader dataReader)
{
AddressGroupInfo info = new AddressGroupInfo();
SmartDataReader reader = new SmartDataReader(dataReader);
info.ID = reader.GetString("ID");
info.PID = reader.GetString("PID");
info.AddressType = Convert(reader.GetString("AddressType"));
info.Name = reader.GetString("Name");
info.Note = reader.GetString("Note");
info.Seq = reader.GetString("Seq");
info.Creator = reader.GetString("Creator");
info.CreateTime = reader.GetDateTime("CreateTime");
info.Editor = reader.GetString("Editor");
info.EditTime = reader.GetDateTime("EditTime");
info.Dept_ID = reader.GetString("Dept_ID");
info.Company_ID = reader.GetString("Company_ID");
return(info);
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override GwzdInfo DataReaderToEntity(IDataReader dataReader)
{
GwzdInfo info = new GwzdInfo();
SmartDataReader reader = new SmartDataReader(dataReader);
info.ID = reader.GetString("ID");
info.Code = reader.GetString("Code");
info.Name = reader.GetString("Name");
info.ZxzdId = reader.GetString("ZXZD_ID");
info.Ratio = reader.GetDecimal("Ratio");
info.Creator = reader.GetString("Creator");
info.CreateTime = reader.GetDateTime("CreateTime");
info.Editor = reader.GetString("Editor");
info.EditTime = reader.GetDateTime("EditTime");
info.Enabled = reader.GetString("Enabled");
info.Note = reader.GetString("Note");
return(info);
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override StockInfo DataReaderToEntity(IDataReader dataReader)
{
StockInfo stockInfo = new StockInfo();
SmartDataReader reader = new SmartDataReader(dataReader);
stockInfo.ID = reader.GetInt32("ID");
stockInfo.ItemNo = reader.GetString("ItemNo");
stockInfo.ItemName = reader.GetString("ItemName");
stockInfo.ItemBigType = reader.GetString("ItemBigType");
stockInfo.ItemType = reader.GetString("ItemType");
stockInfo.StockQuantity = reader.GetInt32("StockQuantity");
stockInfo.StockMoney = reader.GetString("StockMoney");
stockInfo.LowWarning = reader.GetInt32("LowWarning");
stockInfo.HighWarning = reader.GetInt32("HighWarning");
stockInfo.WareHouse = reader.GetString("WareHouse");
stockInfo.Note = reader.GetString("Note");
return(stockInfo);
}
public List <BaiViet> GetList(string TieuDe, string NgayDangMin, string NgayDangMax, byte ChuDeID)
{
SqlConnection con = db.getConnection();
List <BaiViet> l_BaiViet = new List <BaiViet>();
try
{
SqlCommand cmd = new SqlCommand("BaiViet_timkiem");
cmd.Connection = con;
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@TieuDe", TieuDe));
cmd.Parameters.Add(new SqlParameter("@NgayDangMin", NgayDangMin));
cmd.Parameters.Add(new SqlParameter("@NgayDangMax", NgayDangMax));
cmd.Parameters.Add(new SqlParameter("@ChuDeID", ChuDeID));
SqlDataReader reader = cmd.ExecuteReader();
SmartDataReader smartReader = new SmartDataReader(reader);
while (smartReader.Read())
{
BaiViet bv = new BaiViet();
bv.ID = smartReader.GetInt32("ID");
bv.TieuDe = smartReader.GetString("TieuDe");
bv.NgayDang = smartReader.GetString("NgayDang");
bv.LuotXem = smartReader.GetInt32("LuotXem");
bv.TenChuDe = smartReader.GetString("TenChuDe");
bv.URL = smartReader.GetString("URL");
bv.IP = smartReader.GetString("IP");
bv.LopHocID = smartReader.GetInt32("lophocid");
l_BaiViet.Add(bv);
}
smartReader.disposeReader(reader);
}
catch (Exception ex)
{
throw ex;
}
finally
{
db.closeConnection(con);
}
return(l_BaiViet);
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override SO_StockMakeHeadInfo DataReaderToEntity(IDataReader dataReader)
{
SO_StockMakeHeadInfo info = new SO_StockMakeHeadInfo();
SmartDataReader reader = new SmartDataReader(dataReader);
info.F_Id = reader.GetString("F_Id");
info.F_EnCode = reader.GetString("F_EnCode");
info.F_DeleteMark = reader.GetBoolean("F_DeleteMark");
info.F_DeleteMark = reader.GetBoolean("F_DeleteMark");
info.F_EnabledMark = reader.GetBoolean("F_EnabledMark");
info.F_CreatorTime = reader.GetDateTime("F_CreatorTime");
info.F_CreatorUserId = reader.GetString("F_CreatorUserId");
info.F_LastModifyUserId = reader.GetString("F_LastModifyUserId");
info.F_LastModifyTime = reader.GetDateTime("F_LastModifyTime");
info.F_DeleteTime = reader.GetDateTime("F_DeleteTime");
info.F_DeleteUserId = reader.GetString("F_DeleteUserId");
info.F_FreeTerm1 = reader.GetString("F_FreeTerm1");
info.F_FreeTerm2 = reader.GetString("F_FreeTerm2");
info.F_FreeTerm3 = reader.GetString("F_FreeTerm3");
info.F_FreeTerm4 = reader.GetString("F_FreeTerm4");
info.F_FreeTerm5 = reader.GetString("F_FreeTerm5");
info.F_FreeTerm6 = reader.GetString("F_FreeTerm6");
info.F_FreeTerm7 = reader.GetString("F_FreeTerm7");
info.F_FreeTerm8 = reader.GetString("F_FreeTerm8");
info.F_FreeTerm9 = reader.GetString("F_FreeTerm9");
info.F_FreeTerm10 = reader.GetString("F_FreeTerm10");
info.F_WarehouseName = reader.GetString("F_WarehouseName");
info.F_date = reader.GetString("F_date");
info.F_WarehouseId = reader.GetString("F_WarehouseId");
info.F_Operator = reader.GetString("F_Operator");
info.F_CargoPositionId = reader.GetString("F_CargoPositionId");
info.F_CargoPositionName = reader.GetString("F_CargoPositionName");
info.F_Status = reader.GetInt32("F_Status");
info.F_Description = reader.GetString("F_Description");
info.F_State = reader.GetString("F_State");
info.F_Verify = reader.GetString("F_Verify");
info.F_VeriDate = reader.GetString("F_VeriDate");
return(info);
}
//-----------------------------------------------------------
#region Method
private List <Users> Init(SqlCommand cmd)
{
SqlConnection con = db.GetConnection();
cmd.Connection = con;
List <Users> l_Users = new List <Users>();
try
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
SmartDataReader smartReader = new SmartDataReader(reader);
while (smartReader.Read())
{
Users m_Users = new Users();
m_Users.UserId = smartReader.GetInt32("UserId");
m_Users.UserName = smartReader.GetString("UserName");
m_Users.Password = smartReader.GetString("Password");
m_Users.FullName = smartReader.GetString("FullName");
m_Users.Email = smartReader.GetString("Email");
m_Users.Address = smartReader.GetString("Address");
m_Users.Mobile = smartReader.GetString("Mobile");
m_Users.GenderId = smartReader.GetByte("GenderId");
m_Users.UserStatusId = smartReader.GetByte("UserStatusId");
m_Users.UserTypeId = smartReader.GetByte("UserTypeId");
m_Users.DefaultActionId = smartReader.GetInt16("DefaultActionId");
m_Users.BirthDay = smartReader.GetDateTime("BirthDay");
m_Users.CrDateTime = smartReader.GetDateTime("CrDateTime");
l_Users.Add(m_Users);
}
reader.Close();
return(l_Users);
}
catch (SqlException err)
{
throw new ApplicationException("Data error: " + err.Message);
}
finally
{
db.closeConnection(con);
}
}
public LopHoc FindByID(short ID)
{
LopHoc lh = new LopHoc();
SqlConnection con = db.getConnection();
try
{
SqlCommand cmd = new SqlCommand("LopHoc_chitiet");
cmd.Connection = con;
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", ID));
SqlDataReader reader = cmd.ExecuteReader();
SmartDataReader smartReader = new SmartDataReader(reader);
while (smartReader.Read())
{
lh.ID = smartReader.GetInt16("ID");
lh.TenLopHoc = smartReader.GetString("TenLopHoc");
lh.SoLuong = smartReader.GetInt16("SoLuong");
lh.NgayNhan = smartReader.GetString("NgayNhan");
lh.HanChot = smartReader.GetString("HanChot");
lh.NgayNhapHoc = smartReader.GetString("NgayNhapHoc");
lh.MonHocID = smartReader.GetByte("MonHocID");
lh.HocPhi = smartReader.GetDecimal("HocPhi");
lh.LichHoc = smartReader.GetString("LichHoc");
lh.MoTa = smartReader.GetString("MoTa");
lh.NhanHocVien = smartReader.GetBoolean("NhanHocVien");
lh.LoaiHocPhiID = smartReader.GetByte("LoaiHocPhiID");
lh.Khoi = smartReader.GetByte("Khoi");
}
smartReader.disposeReader(reader);
}
catch (Exception ex)
{
throw ex;
}
finally
{
db.closeConnection(con);
}
return(lh);
}
//-----------------------------------------------------------------
private List <Sites> Init(SqlCommand cmd)
{
SqlConnection con = db.GetConnection();
cmd.Connection = con;
List <Sites> l_Sites = new List <Sites>();
try
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
SmartDataReader smartReader = new SmartDataReader(reader);
while (smartReader.Read())
{
Sites m_Sites = new Sites(db.ConnectionString);
m_Sites.SiteId = smartReader.GetInt16("SiteId");
m_Sites.SiteName = smartReader.GetString("SiteName");
m_Sites.SiteDesc = smartReader.GetString("SiteDesc");
m_Sites.MetaTitle = smartReader.GetString("MetaTitle");
m_Sites.MetaDesc = smartReader.GetString("MetaDesc");
m_Sites.MetaKeyword = smartReader.GetString("MetaKeyword");
m_Sites.MetaTagAll = smartReader.GetString("MetaTagAll");
m_Sites.CanonicalTag = smartReader.GetString("CanonicalTag");
m_Sites.H1Tag = smartReader.GetString("H1Tag");
m_Sites.SeoFooter = smartReader.GetString("SeoFooter");
m_Sites.CrUserId = smartReader.GetInt32("CrUserId");
m_Sites.CrDateTime = smartReader.GetDateTime("CrDateTime");
l_Sites.Add(m_Sites);
}
reader.Close();
return(l_Sites);
}
catch (SqlException err)
{
throw new ApplicationException("Data error: " + err.Message);
}
finally
{
db.closeConnection(con);
}
}
/// <summary>
/// 将DataReader的属性值转化为实体类的属性值，返回实体类
/// </summary>
/// <param name="dr">有效的DataReader对象</param>
/// <returns>实体类对象</returns>
protected override OperationLogInfo DataReaderToEntity(IDataReader dataReader)
{
OperationLogInfo info = new OperationLogInfo();
SmartDataReader reader = new SmartDataReader(dataReader);
info.Id = reader.GetInt32("ID");
info.UserId = reader.GetInt32("User_ID");
info.LoginName = reader.GetString("LoginName");
info.FullName = reader.GetString("FullName");
info.CompanyId = reader.GetInt32("CompanyId");
info.CompanyName = reader.GetString("CompanyName");
info.TableName = reader.GetString("TableName");
info.OperationType = reader.GetString("OperationType");
info.Remark = reader.GetString("Remark");
info.IP = reader.GetString("IP");
info.Mac = reader.GetString("Mac");
info.CreatorTime = reader.GetDateTime("CreatorTime");
return(info);
}
