public bool Load() { string sql = string.Format("select * from TPI_Goods where GoodsId={0} and ProjectId={1}", GoodsId, ProjectId); DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; Id = DBTool.GetIntFromRow(row, "Id", 0); Sku = DBTool.GetStringFromRow(row, "Sku", ""); SkuName = DBTool.GetStringFromRow(row, "SkuName", ""); ReferencePrice = DBTool.GetDoubleFromRow(row, "ReferencePrice", 0); AgreementPrice = DBTool.GetDoubleFromRow(row, "AgreementPrice", 0); GoodsId = DBTool.GetIntFromRow(row, "GoodsId", 0); IshaveImage = DBTool.GetIntFromRow(row, "IshaveImage", 0); IsUnitAgreement = DBTool.GetIntFromRow(row, "IsUnitAgreement", 0); State = DBTool.GetIntFromRow(row, "State", 0); ProjectId = DBTool.GetIntFromRow(row, "ProjectId", 0); Stock = DBTool.GetIntFromRow(row, "Stock", 0); PushState = DBTool.GetIntFromRow(row, "PushState", 0); ResultMsg = DBTool.GetStringFromRow(row, "ResultMsg", ""); AddTime = DBTool.GetDateTimeFromRow(row, "AddTime"); return(true); } return(false); }
/// <summary> /// ERP FSysUserInfo.cs 中调用 /// </summary> /// <returns></returns> public bool Load() { string sql = string.Format("select * from Sys_Users inner join Sys_Branch on Sys_Users.BranchId = Sys_Branch.Id where Sys_Users.Id={0} ", Id); DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; Id = DBTool.GetIntFromRow(row, "Id", 0); LoginName = DBTool.GetStringFromRow(row, "LoginName", ""); PassWord = DBTool.GetStringFromRow(row, "PassWord", ""); Name = DBTool.GetStringFromRow(row, "Name", ""); BranchId = DBTool.GetIntFromRow(row, "BranchId", 0); DeptId = DBTool.GetIntFromRow(row, "DeptId", 0); IsSales = DBTool.GetIntFromRow(row, "IsSales", 0); Telphone = DBTool.GetStringFromRow(row, "Telphone", ""); Mobile = DBTool.GetStringFromRow(row, "Mobile", ""); BirthDay = DBTool.GetDateTimeFromRow(row, "BirthDay"); IsYinLi = DBTool.GetIntFromRow(row, "IsYinLi", 0); JoinDate = DBTool.GetDateTimeFromRow(row, "JoinDate"); IDCard = DBTool.GetStringFromRow(row, "IDCard", ""); ModifyTime = DBTool.GetDateTimeFromRow(row, "ModifyTime"); IsValid = DBTool.GetIntFromRow(row, "IsValid", 0); Position = DBTool.GetStringFromRow(row, "Position", ""); SN1 = DBTool.GetStringFromRow(row, "SN1", ""); SN2 = DBTool.GetStringFromRow(row, "SN2", ""); IsAdmin = DBTool.GetIntFromRow(row, "IsAdmin", 0); token = DBTool.GetStringFromRow(row, "token", ""); tokenEndDate = DBTool.GetDateTimeFromRow(row, "tokenEndDate"); return(true); } return(false); }
public bool Load() { string sql = string.Format("select * from InvoiceRequire where id={0}", m_Id); DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; m_Id = DBTool.GetIntFromRow(row, "Id", 0); m_ComId = DBTool.GetIntFromRow(row, "ComId", 0); m_StatementId = DBTool.GetIntFromRow(row, "StatementId", 0); m_InvoiceName = DBTool.GetStringFromRow(row, "InvoiceName", ""); m_InvoiceType = DBTool.GetStringFromRow(row, "InvoiceType", ""); m_InvoiceContent = DBTool.GetStringFromRow(row, "InvoiceContent", ""); m_InvoiceAmount = DBTool.GetDoubleFromRow(row, "InvoiceAmount", 0); m_InvoiceMemo = DBTool.GetStringFromRow(row, "InvoiceMemo", ""); m_UserId = DBTool.GetIntFromRow(row, "UserId", 0); m_UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime"); m_InvoiceStatus = DBTool.GetStringFromRow(row, "InvoiceStatus", ""); m_MemberInvoiceId = DBTool.GetIntFromRow(row, "MemberInvoiceId", 0); m_applicationNo = DBTool.GetStringFromRow(row, "applicationNo", ""); return(true); } return(false); }
private void LoadFromRow(DataRow row) { Id = DBTool.GetIntFromRow(row, "Id", 0); ThirdPartyOrderId = DBTool.GetStringFromRow(row, "ThirdPartyOrderId", ""); ProjectId = DBTool.GetIntFromRow(row, "ProjectId", 0); RealName = DBTool.GetStringFromRow(row, "RealName", ""); Province = DBTool.GetStringFromRow(row, "Province", ""); City = DBTool.GetStringFromRow(row, "City", ""); County = DBTool.GetStringFromRow(row, "County", ""); Town = DBTool.GetStringFromRow(row, "Town", ""); Address = DBTool.GetStringFromRow(row, "Address", ""); Zip = DBTool.GetStringFromRow(row, "Zip", ""); Phone = DBTool.GetStringFromRow(row, "Phone", ""); Mobile = DBTool.GetStringFromRow(row, "Mobile", ""); Email = DBTool.GetStringFromRow(row, "Email", ""); Remark = DBTool.GetStringFromRow(row, "Remark", ""); InvoiceTitle = DBTool.GetStringFromRow(row, "InvoiceTitle", ""); InvoiceState = DBTool.GetIntFromRow(row, "InvoiceState", 0); InvoiceType = DBTool.GetIntFromRow(row, "InvoiceType", 0); InvoiceContent = DBTool.GetIntFromRow(row, "InvoiceContent", 0); Amount = DBTool.GetDecimalFromRow(row, "Amount", 0); Freight = DBTool.GetIntFromRow(row, "Freight", 0); Payment = DBTool.GetStringFromRow(row, "Payment", ""); ReviewId = DBTool.GetIntFromRow(row, "ReviewId", 0); OrderStatus = DBTool.GetStringFromRow(row, "OrderStatus", ""); IsTransformation = DBTool.GetIntFromRow(row, "IsTransformation", 0); OrderTime = DBTool.GetDateTimeFromRow(row, "OrderTime"); ItemDeliveryId = DBTool.GetStringFromRow(row, "ItemDeliveryId", ""); DeliveryCode = DBTool.GetStringFromRow(row, "DeliveryCode", ""); PrId = DBTool.GetStringFromRow(row, "PrId", ""); }
public bool Load() { string sql = string.Format("select * from News where id={0}", m_Id); DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; m_Id = DBTool.GetIntFromRow(row, "Id", 0); m_Title = DBTool.GetStringFromRow(row, "Title", ""); m_NewsTypeId = DBTool.GetIntFromRow(row, "NewsTypeId", 0); m_NewsKeywords = DBTool.GetStringFromRow(row, "NewsKeywords", ""); m_Author = DBTool.GetStringFromRow(row, "Author", ""); m_PublishDate = DBTool.GetDateTimeFromRow(row, "PublishDate"); m_ImageUrl = DBTool.GetStringFromRow(row, "ImageUrl", ""); m_Content = DBTool.GetStringFromRow(row, "Content", ""); m_Recommend = DBTool.GetIntFromRow(row, "Recommend", 0); m_Describe = DBTool.GetStringFromRow(row, "Describe", ""); m_BranchId = DBTool.GetIntFromRow(row, "BranchId", 0); m_IsCheck = DBTool.GetIntFromRow(row, "IsCheck", 0); return(true); } return(false); }
/// <summary> /// 通过ProjectId获取项目信息 /// </summary> /// <returns>bool 返回单条记录的对象</returns> public bool Load() { string sql = string.Format("select * from TPI_Project where Id={0}", Id); DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; Id = DBTool.GetIntFromRow(row, "Id", 0); Name = DBTool.GetStringFromRow(row, "Name", ""); UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime"); IsUseTypeCompare = DBTool.GetIntFromRow(row, "IsUseTypeCompare", 0); IsUseBrandCompare = DBTool.GetIntFromRow(row, "IsUseBrandCompare", 0); BranchId = DBTool.GetIntFromRow(row, "BranchId", 0); Developers = DBTool.GetStringFromRow(row, "Developers", ""); PortNumber = DBTool.GetIntFromRow(row, "PortNumber", 0); Note = DBTool.GetStringFromRow(row, "Note", ""); Url = DBTool.GetStringFromRow(row, "Url", ""); PushType = DBTool.GetIntFromRow(row, "PushType", 0); IsDiscount = DBTool.GetIntFromRow(row, "IsDiscount", 0); return(true); } return(false); }
public bool Load(int NeedToPurchaseId, int GoodsId) { string sql = string.Format("select * from NeedToPurchaseDetail where NeedToPurchaseId ={0} and GoodsId={1}", NeedToPurchaseId, GoodsId); DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; m_Id = DBTool.GetIntFromRow(row, "Id", 0); m_NeedToPurchaseId = DBTool.GetIntFromRow(row, "NeedToPurchaseId", 0); m_GoodsId = DBTool.GetIntFromRow(row, "GoodsId", 0); m_Model = DBTool.GetStringFromRow(row, "Model", ""); m_Num = DBTool.GetIntFromRow(row, "Num", 0); m_UserId = DBTool.GetIntFromRow(row, "UserId", 0); m_PurchaseType = DBTool.GetStringFromRow(row, "PurchaseType", ""); m_PurchaseMemo = DBTool.GetStringFromRow(row, "PurchaseMemo", ""); m_CreditCard = DBTool.GetStringFromRow(row, "CreditCard", ""); m_UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime"); m_LackNum = DBTool.GetIntFromRow(row, "LackNum", 0); m_Emergency = DBTool.GetIntFromRow(row, "Emergency", 0); m_GoodsMemo = DBTool.GetStringFromRow(row, "GoodsMemo", ""); m_SupplierId = DBTool.GetIntFromRow(row, "SupplierId", 0); m_InPrice = DBTool.GetDoubleFromRow(row, "InPrice", 0); SprInvoiceType = DBTool.GetStringFromRow(row, "SprInvoiceType", ""); SprTaxRate = DBTool.GetDoubleFromRow(row, "SprTaxRate", 0); return(true); } return(false); }
public bool Load() { string sql = string.Format("select * from Invoice where id={0}", m_Id); DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; m_Id = DBTool.GetIntFromRow(row, "Id", 0); m_BranchId = DBTool.GetIntFromRow(row, "BranchId", 0); m_ComId = DBTool.GetIntFromRow(row, "ComId", 0); m_OrderStatementId = DBTool.GetIntFromRow(row, "OrderStatementId", 0); m_InvoiceRequireId = DBTool.GetIntFromRow(row, "InvoiceRequireId", 0); m_InvoiceDate = DBTool.GetDateTimeFromRow(row, "InvoiceDate"); m_InvoiceNo = DBTool.GetStringFromRow(row, "InvoiceNo", ""); m_InvoiceType = DBTool.GetStringFromRow(row, "InvoiceType", ""); m_InvoiceMoney = DBTool.GetDoubleFromRow(row, "InvoiceMoney", 0); m_Memo = DBTool.GetStringFromRow(row, "Memo", ""); m_UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime"); m_UserId = DBTool.GetIntFromRow(row, "UserId", 0); m_PrintNum = DBTool.GetIntFromRow(row, "PrintNum", 0); m_PrintTime = DBTool.GetDateTimeFromRow(row, "PrintTime"); return(true); } return(false); }
public bool Load() { string sql = string.Format("select * from GoodsBrowse where id={0}", Id); DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; Id = DBTool.GetIntFromRow(row, "Id", 0); GoodsId = DBTool.GetIntFromRow(row, "GoodsId", 0); LoginName = DBTool.GetStringFromRow(row, "LoginName", ""); Company = DBTool.GetStringFromRow(row, "Company", ""); IsIntheCart = DBTool.GetIntFromRow(row, "IsIntheCart", 0); Ip = DBTool.GetStringFromRow(row, "Ip", ""); Port = DBTool.GetStringFromRow(row, "Port", ""); Province = DBTool.GetStringFromRow(row, "Province", ""); City = DBTool.GetStringFromRow(row, "City", ""); BrowseType = DBTool.GetStringFromRow(row, "BrowseType", ""); ClientMark = DBTool.GetStringFromRow(row, "ClientMark", ""); Guid = DBTool.GetStringFromRow(row, "Guid", ""); UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime"); return(true); } return(false); }
public bool Load() { string sql = string.Format("select * from TPI_SupplierOrder where id={0}", Id); DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; Id = DBTool.GetIntFromRow(row, "Id", 0); OrderId = DBTool.GetIntFromRow(row, "OrderId", 0); RealName = DBTool.GetStringFromRow(row, "RealName", ""); Address = DBTool.GetStringFromRow(row, "Address", ""); DetailStreet = DBTool.GetStringFromRow(row, "DetailStreet", ""); ZipCode = DBTool.GetStringFromRow(row, "ZipCode", ""); Telephone = DBTool.GetStringFromRow(row, "Telephone", ""); Mobile = DBTool.GetStringFromRow(row, "Mobile", ""); Email = DBTool.GetStringFromRow(row, "Email", ""); Memo = DBTool.GetStringFromRow(row, "Memo", ""); Amount = DBTool.GetDoubleFromRow(row, "Amount", 0); ShipFree = DBTool.GetDoubleFromRow(row, "ShipFree", 0); GoodsList = DBTool.GetStringFromRow(row, "GoodsList", ""); UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime"); UsersId = DBTool.GetIntFromRow(row, "UsersId", 0); //Distribution = DBTool.GetIntFromRow(row, "Distribution", 0); return(true); } return(false); }
private void LoadFromRow(DataRow row) { Id = DBTool.GetIntFromRow(row, "Id", 0); Email = DBTool.GetStringFromRow(row, "Email", ""); PassWord = DBTool.GetStringFromRow(row, "PassWord", ""); LastSendTime = DBTool.GetDateTimeFromRow(row, "LastSendTime"); }
public bool Load() { string sql = string.Format("select * from GoodStoreInventoryDetail where id={0}", ID); DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; ID = DBTool.GetIntFromRow(row, "ID", 0); FK_GSDetail_ID = DBTool.GetIntFromRow(row, "FK_GSDetail_ID", 0); FK_Goods_ID = DBTool.GetIntFromRow(row, "FK_Goods_ID", 0); FK_Store_ID = DBTool.GetIntFromRow(row, "FK_Store_ID", 0); OldNum = DBTool.GetIntFromRow(row, "OldNum", 0); NewNum = DBTool.GetIntFromRow(row, "NewNum", 0); AC = DBTool.GetDoubleFromRow(row, "AC", 0); CreateUser = DBTool.GetIntFromRow(row, "CreateUser", 0); CreateTime = DBTool.GetDateTimeFromRow(row, "CreateTime"); OldSumMoney = DBTool.GetDoubleFromRow(row, "OldSumMoney", 0); NewSumMoney = DBTool.GetDoubleFromRow(row, "NewSumMoney", 0); FK_GSInventory_ID = DBTool.GetIntFromRow(row, "FK_GSInventory_ID", 0); return(true); } return(false); }
public bool Load() { string sql = string.Format("select * from Transfer where id={0}", Id); DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; Id = DBTool.GetIntFromRow(row, "Id", 0); OutBranchId = DBTool.GetIntFromRow(row, "OutBranchId", 0); InBranchId = DBTool.GetIntFromRow(row, "InBranchId", 0); OutStoreId = DBTool.GetIntFromRow(row, "OutStoreId", 0); OutStoreUserId = DBTool.GetIntFromRow(row, "OutStoreUserId", 0); InStoreId = DBTool.GetIntFromRow(row, "InStoreId", 0); InStoreUserId = DBTool.GetIntFromRow(row, "InStoreUserId", 0); Memo = DBTool.GetStringFromRow(row, "Memo", ""); UpdateDate = DBTool.GetDateTimeFromRow(row, "UpdateDate"); OutStoreDate = DBTool.GetDateTimeFromRow(row, "OutStoreDate"); InStoreDate = DBTool.GetDateTimeFromRow(row, "InStoreDate"); Status = DBTool.GetStringFromRow(row, "Status", ""); IsInner = DBTool.GetIntFromRow(row, "IsInner", 0); return(true); } return(false); }
public bool Load() { string sql = string.Format("select * from GoodsStoreDetail where id={0}", m_Id); DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; m_Id = DBTool.GetIntFromRow(row, "Id", 0); m_StoreId = DBTool.GetIntFromRow(row, "StoreId", 0); m_GoodsId = DBTool.GetIntFromRow(row, "GoodsId", 0); m_Model = DBTool.GetStringFromRow(row, "Model", ""); m_OldNum = DBTool.GetIntFromRow(row, "OldNum", 0); m_Num = DBTool.GetIntFromRow(row, "Num", 0); m_NewNum = DBTool.GetIntFromRow(row, "NewNum", 0); m_Operate = DBTool.GetStringFromRow(row, "Operate", ""); m_RelationId = DBTool.GetIntFromRow(row, "RelationId", 0); m_Memo = DBTool.GetStringFromRow(row, "Memo", ""); m_UserId = DBTool.GetIntFromRow(row, "UserId", 0); m_AC = DBTool.GetDoubleFromRow(row, "AC", 0); TaxAC = DBTool.GetDoubleFromRow(row, "TaxAC", 0); m_UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime"); return(true); } return(false); }
private bool LoadFromRow(DataRow row) { Id = DBTool.GetIntFromRow(row, "Id", 0); SalesId = DBTool.GetIntFromRow(row, "SalesId", 0); YearMonth = DBTool.GetDateTimeFromRow(row, "YearMonth"); Target = DBTool.GetIntFromRow(row, "Target", 0); Finish = DBTool.GetDoubleFromRow(row, "Finish", 0); FinishRatio = DBTool.GetDoubleFromRow(row, "FinishRatio", 0); NewCustomer = DBTool.GetDoubleFromRow(row, "NewCustomer", 0); OldCustormer = DBTool.GetDoubleFromRow(row, "OldCustormer", 0); NewGrossProfit = DBTool.GetDoubleFromRow(row, "NewGrossProfit", 0); OldGrossProfit = DBTool.GetDoubleFromRow(row, "OldGrossProfit", 0); GrossProfit = DBTool.GetDoubleFromRow(row, "GrossProfit", 0); NormalCost = DBTool.GetDoubleFromRow(row, "NormalCost", 0); DLHSCost = DBTool.GetDoubleFromRow(row, "DLHSCost", 0); SaleCost = DBTool.GetDoubleFromRow(row, "SaleCost", 0); ProfitRatio = DBTool.GetDoubleFromRow(row, "ProfitRatio", 0); ProfitFactor = DBTool.GetDoubleFromRow(row, "ProfitFactor", 0); Commission = DBTool.GetDoubleFromRow(row, "Commission", 0); CommissionConfirm = DBTool.GetIntFromRow(row, "CommissionConfirm", 0); DeadLine = DBTool.GetDateTimeFromRow(row, "DeadLine"); OverdueFactor = DBTool.GetDoubleFromRow(row, "OverdueFactor", 0); Ammount = DBTool.GetDoubleFromRow(row, "Ammount", 0); AmmountConfirm = DBTool.GetIntFromRow(row, "AmmountConfirm", 0); UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime"); return(true); }
public bool Load() { string sql = string.Format("select * from Purchase where id={0}", m_Id); DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; m_Id = DBTool.GetIntFromRow(row, "Id", 0); m_BranchId = DBTool.GetIntFromRow(row, "BranchId", 0); m_StoreId = DBTool.GetIntFromRow(row, "StoreId", 0); m_SupplierId = DBTool.GetIntFromRow(row, "SupplierId", 0); m_PurchaseType = DBTool.GetStringFromRow(row, "PurchaseType", ""); m_SumMoney = DBTool.GetDoubleFromRow(row, "SumMoney", 0); m_PurchaseDate = DBTool.GetDateTimeFromRow(row, "PurchaseDate"); m_PurchaseUserId = DBTool.GetIntFromRow(row, "PurchaseUserId", 0); m_IsPaid = DBTool.GetIntFromRow(row, "IsPaid", 0); m_IsTax = DBTool.GetIntFromRow(row, "IsTax", 0); m_IsConfirm = DBTool.GetIntFromRow(row, "IsConfirm", 0); m_IsCashConfirm = DBTool.GetIntFromRow(row, "IsCashConfirm", 0); m_Memo = DBTool.GetStringFromRow(row, "Memo", ""); m_UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime"); m_UserId = DBTool.GetIntFromRow(row, "UserId", 0); m_PurchaseStatus = DBTool.GetStringFromRow(row, "PurchaseStatus", ""); m_NeedToPurchaseId = DBTool.GetIntFromRow(row, "NeedToPurchaseId", 0); m_ReceiptUserId = DBTool.GetIntFromRow(row, "ReceiptUserId", 0); m_ConfirmDate = DBTool.GetDateTimeFromRow(row, "ConfirmDate"); Tax = DBTool.GetDoubleFromRow(row, "Tax", 0); TaxRate = DBTool.GetDoubleFromRow(row, "TaxRate", 0); return(true); } return(false); }
/// <summary>tpi_project /// 验证某项目的账号密码和开关设置等。 /// </summary> /// <returns></returns> public bool LoadTPI_Users() { DataTable dt = GetTPI_Users(); if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; Option.ProjectId = DBTool.GetIntFromRow(row, "ProjectId", 0); Option.ProjectName = DBTool.GetStringFromRow(row, "ProjectName", ""); Option.BranchId = DBTool.GetIntFromRow(row, "BranchId", 0); Option.IsUseTypeCompare = DBTool.GetIntFromRow(row, "IsUseTypeCompare", 0); Option.Developers = DBTool.GetStringFromRow(row, "Developers", ""); Option.AppKey = DBTool.GetStringFromRow(row, "AppKey", ""); Option.AppPassword = DBTool.GetStringFromRow(row, "AppPassword", ""); Option.AppSecret = DBTool.GetStringFromRow(row, "AppSecret", ""); Option.Token = DBTool.GetStringFromRow(row, "Token", ""); Option.CallDate = DBTool.GetDateTimeFromRow(row, "CallDate"); Option.EndDate = DBTool.GetDateTimeFromRow(row, "EndDate"); Option.State = DBTool.GetIntFromRow(row, "State", 0); Option.interfaceVersion = DBTool.GetStringFromRow(row, "InterfaceVersion", ""); Option.Sign = DBTool.GetStringFromRow(row, "Sign", ""); return(true); } return(false); }
private bool LoadFromRow(DataRow row) { Id = DBTool.GetIntFromRow(row, "Id", 0); ReleaseName = DBTool.GetStringFromRow(row, "ReleaseName", ""); MessageContent = DBTool.GetStringFromRow(row, "MessageContent", ""); UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime"); return(true); }
private void LoadFromRow(DataRow row) { Id = DBTool.GetIntFromRow(row, "Id", 0); BranchId = DBTool.GetIntFromRow(row, "BranchId", 0); Plate = DBTool.GetStringFromRow(row, "Plate", ""); IsEnable = DBTool.GetIntFromRow(row, "IsEnable", 0); Memo = DBTool.GetStringFromRow(row, "Memo", ""); UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime"); }
private bool LoadFromRow(DataRow row) { Id = DBTool.GetIntFromRow(row, "Id", 0); NoticeId = DBTool.GetIntFromRow(row, "NoticeId", 0); UserId = DBTool.GetIntFromRow(row, "UserId", 0); IsHaveSee = DBTool.GetIntFromRow(row, "IsHaveSee", 0); UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime"); return(true); }
private void LoadFromRow(DataRow row) { Id = DBTool.GetIntFromRow(row, "Id", 0); OrderId = DBTool.GetIntFromRow(row, "OrderId", 0); Page = DBTool.GetIntFromRow(row, "Page", 0); PhotoUrl = DBTool.GetStringFromRow(row, "PhotoUrl", ""); SaveNum = DBTool.GetIntFromRow(row, "SaveNum", 0); UserId = DBTool.GetIntFromRow(row, "UserId", 0); UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime"); }
/// <summary> /// Load方法:参数值:用户名/密钥/接口版本 /// </summary> /// <returns></returns> public bool Load() { string sql = "select * from TPI_Users where State=1 "; if (AppKey != null && AppKey != "") { sql += string.Format("and AppKey='{0}'", AppKey); } if (AppPassword != null && AppPassword != "") { sql += string.Format("and AppPassword='******'", AppPassword); } if (Token != null && Token != "") { sql += string.Format("and Token ='{0}'", Token); } if (InterfaceVersion != null && InterfaceVersion != "") { sql += string.Format("and InterfaceVersion like '%{0}%'", InterfaceVersion); } if (Sign != null && Sign != "") { sql += string.Format("and Sign='{0}'", Sign); } if (ProjectId > 0) { sql += string.Format("and ProjectId={0}", ProjectId); } if (AppSecret != null && AppSecret != "") { sql += string.Format("and AppSecret='{0}'", AppSecret); } DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; Id = DBTool.GetIntFromRow(row, "Id", 0); AppKey = DBTool.GetStringFromRow(row, "AppKey", ""); AppSecret = DBTool.GetStringFromRow(row, "AppSecret", ""); Sign = DBTool.GetStringFromRow(row, "Sign", ""); InterfaceVersion = DBTool.GetStringFromRow(row, "InterfaceVersion", ""); Name = DBTool.GetStringFromRow(row, "Name", ""); Token = DBTool.GetStringFromRow(row, "Token", ""); State = DBTool.GetIntFromRow(row, "State", 0); CallDate = DBTool.GetDateTimeFromRow(row, "CallDate"); EndDate = DBTool.GetDateTimeFromRow(row, "EndDate"); ProjectId = DBTool.GetIntFromRow(row, "ProjectId", 0); AppPassword = DBTool.GetStringFromRow(row, "AppPassword", ""); ClientSecret = DBTool.GetStringFromRow(row, "ClientSecret", ""); return(true); } return(false); }
public void LoadFromRow(DataRow row) { Id = DBTool.GetIntFromRow(row, "Id", 0); OrderId = DBTool.GetIntFromRow(row, "OrderId", 0); BoxId = DBTool.GetIntFromRow(row, "BoxId", 0); Status = DBTool.GetStringFromRow(row, "Status", ""); PrintNum = DBTool.GetIntFromRow(row, "PrintNum", 0); StoreZone = DBTool.GetStringFromRow(row, "StoreZone", ""); UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime"); OrderBoxStatus = DBTool.GetStringFromRow(row, "OrderBoxStatus", ""); }
public bool Load() { string sql = string.Format("select * from Supplier where id={0}", m_Id); DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; m_Id = DBTool.GetIntFromRow(row, "Id", 0); m_AddTime = DBTool.GetDateTimeFromRow(row, "AddTime"); m_UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime"); m_Company = DBTool.GetStringFromRow(row, "Company", ""); m_ShortName = DBTool.GetStringFromRow(row, "ShortName", ""); m_Type = DBTool.GetStringFromRow(row, "Type", ""); m_Attitude = DBTool.GetStringFromRow(row, "Attitude", ""); m_PriceSheet = DBTool.GetIntFromRow(row, "PriceSheet", 0); m_InvoiceType = DBTool.GetStringFromRow(row, "InvoiceType", ""); m_PayType = DBTool.GetStringFromRow(row, "PayType", ""); m_YearTarget = DBTool.GetIntFromRow(row, "YearTarget", 0); m_MonthAmount = DBTool.GetDoubleFromRow(row, "MonthAmount", 0); m_LinkMan1 = DBTool.GetStringFromRow(row, "LinkMan1", ""); m_LinkMan2 = DBTool.GetStringFromRow(row, "LinkMan2", ""); m_TelPhone1 = DBTool.GetStringFromRow(row, "TelPhone1", ""); m_TelPhone2 = DBTool.GetStringFromRow(row, "TelPhone2", ""); m_Mobile1 = DBTool.GetStringFromRow(row, "Mobile1", ""); m_Mobile2 = DBTool.GetStringFromRow(row, "Mobile2", ""); m_QQ1 = DBTool.GetStringFromRow(row, "QQ1", ""); m_QQ2 = DBTool.GetStringFromRow(row, "QQ2", ""); m_Address = DBTool.GetStringFromRow(row, "Address", ""); m_MainBrand = DBTool.GetStringFromRow(row, "MainBrand", ""); m_Major = DBTool.GetStringFromRow(row, "Major", ""); m_BillsDiscount = DBTool.GetIntFromRow(row, "BillsDiscount", 100); m_Branchid = DBTool.GetIntFromRow(row, "BranchId", 1); m_ContractType = DBTool.GetStringFromRow(row, "ContractType", ""); m_IsChangRefund = DBTool.GetStringFromRow(row, "IsChangRefund", ""); m_PurchasRewards = DBTool.GetStringFromRow(row, "PurchasRewards", ""); m_PaymentMethod = DBTool.GetStringFromRow(row, "PaymentMethod", ""); m_AccountNum = DBTool.GetStringFromRow(row, "AccountNum", ""); m_TaxpayerIdentificationCode = DBTool.GetStringFromRow(row, "TaxpayerIdentificationCode", ""); m_OpenBank = DBTool.GetStringFromRow(row, "OpenBank", ""); m_FinancialLinkMan = DBTool.GetStringFromRow(row, "FinancialLinkMan", ""); m_FinancialTelPhone = DBTool.GetStringFromRow(row, "FinancialTelPhone", ""); m_Other = DBTool.GetStringFromRow(row, "Other", ""); m_GoodsTypeId = DBTool.GetIntFromRow(row, "GoodsTypeId", 0); m_PY = DBTool.GetStringFromRow(row, "PY", ""); m_TaxRate = DBTool.GetDoubleFromRow(row, "TaxRate", 0); m_OfficeAddress = DBTool.GetStringFromRow(row, "OfficeAddress", ""); m_WarhouseAddress = DBTool.GetStringFromRow(row, "WarhouseAddress", ""); m_Delivery = DBTool.GetStringFromRow(row, "Delivery", ""); m_DeliveryRegion = DBTool.GetStringFromRow(row, "DeliveryRegion", ""); return(true); } return(false); }
private void LoadFromRow(DataRow row) { Id = DBTool.GetIntFromRow(row, "Id", 0); GoodsId = DBTool.GetIntFromRow(row, "GoodsId", 0); StoreId = DBTool.GetIntFromRow(row, "StoreId", 0); Num = DBTool.GetIntFromRow(row, "Num", 0); AC = DBTool.GetDoubleFromRow(row, "AC", 0); UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime"); StoreZone = DBTool.GetStringFromRow(row, "StoreZone", ""); CargoNum = DBTool.GetIntFromRow(row, "CargoNum", 0); TaxAC = DBTool.GetDoubleFromRow(row, "TaxAC", 0); }
public bool Load() { string sql = string.Format("select * from TPI_Refund where 1=1 "); if (Id > 0) { sql += string.Format("and id={0} ", Id); } if (projectId > 0) { sql += string.Format("and projectId={0} ", projectId); } if (OrderRefundId != "") { sql += string.Format("and OrderRefundId={0} ", OrderRefundId); } DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; Id = DBTool.GetIntFromRow(row, "Id", 0); projectId = DBTool.GetIntFromRow(row, "projectId", 0); createTime = DBTool.GetDateTimeFromRow(row, "createTime"); OrderRefundId = DBTool.GetStringFromRow(row, "OrderRefundId", ""); OrigOrderId = DBTool.GetStringFromRow(row, "OrigOrderId", ""); CommodityId = DBTool.GetStringFromRow(row, "CommodityId", ""); SkuId = DBTool.GetStringFromRow(row, "SkuId", ""); CustomerId = DBTool.GetStringFromRow(row, "CustomerId", ""); RefundNum = DBTool.GetIntFromRow(row, "RefundNum", 0); RefundAmt = DBTool.GetDoubleFromRow(row, "RefundAmt", 0); RefundTime = DBTool.GetDateTimeFromRow(row, "RefundTime"); RefundReason = DBTool.GetStringFromRow(row, "RefundReason", ""); RefundName = DBTool.GetStringFromRow(row, "RefundName", ""); RefundMobile = DBTool.GetStringFromRow(row, "RefundMobile", ""); RefundTelephone = DBTool.GetStringFromRow(row, "RefundTelephone", ""); RefundProvince = DBTool.GetStringFromRow(row, "RefundProvince", ""); RefundCity = DBTool.GetStringFromRow(row, "RefundCity", ""); RefundCounty = DBTool.GetStringFromRow(row, "RefundCounty", ""); RefundAddressDetail = DBTool.GetStringFromRow(row, "RefundAddressDetail", ""); RefundDescription = DBTool.GetStringFromRow(row, "RefundDescription", ""); RefundType = DBTool.GetIntFromRow(row, "RefundType", 0); StoreId = DBTool.GetStringFromRow(row, "StoreId", ""); RefundIntelAmt = DBTool.GetDoubleFromRow(row, "RefundIntelAmt", 0); RefundCouponAmt = DBTool.GetDoubleFromRow(row, "RefundCouponAmt", 0); RefundResult = DBTool.GetIntFromRow(row, "RefundResult", 0); OrderRefundTime = DBTool.GetDateTimeFromRow(row, "OrderRefundTime"); OrderRefundDesc = DBTool.GetStringFromRow(row, "OrderRefundDesc", ""); orderId = DBTool.GetIntFromRow(row, "orderId", 0); return(true); } return(false); }
public OrderPrintView(int orderId) : this() { LeadingClass.Order order = new Order(orderId); order.PrintDateTime = DateTime.Now; order.Save(); this.ComplainUrl = CommenClass.SiteUrl.ComplainUrl() + order.GUID; Customer customer = new Customer(order.ComId); this.IsArchive = customer.IsArchive; DBOperate dbo = new DBOperate(); string sql = string.Format(" select * from view_order where orderId={0} ", orderId); DataSet ds = dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count == 1) { DataRow row = ds.Tables[0].Rows[0]; this.OrderId = DBTool.GetIntFromRow(row, "OrderId", 0); this.SumMoney = DBTool.GetDoubleFromRow(row, "SumMoney", 0); this.Emergency = DBTool.GetIntFromRow(row, "Emergency", 0); this.OrderTime = DBTool.GetDateTimeFromRow(row, "OrderTime"); this.PlanDate = DBTool.GetDateTimeFromRow(row, "PlanDate"); this.StoreFinishTime = DBTool.GetDateTimeFromRow(row, "StoreFinishTime"); this.PrintTime = DBTool.GetDateTimeFromRow(row, "PrintDateTime"); this.RowNum = DBTool.GetIntFromRow(row, "RowNum", 0); this.PackageNum = DBTool.GetIntFromRow(row, "PackageNum", 0); this.Company = DBTool.GetStringFromRow(row, "Company", ""); this.ComId = DBTool.GetIntFromRow(row, "ComId", 0); this.RealName = DBTool.GetStringFromRow(row, "RealName", ""); this.DeptName = DBTool.GetStringFromRow(row, "DeptName", ""); this.Mobile = DBTool.GetStringFromRow(row, "Mobile", ""); this.Telphone = DBTool.GetStringFromRow(row, "Telphone", ""); this.Address = DBTool.GetStringFromRow(row, "Address", ""); this.SalesName = DBTool.GetStringFromRow(row, "SalesName", ""); this.ServiceName = DBTool.GetStringFromRow(row, "ServiceName", ""); this.PickingUserId = DBTool.GetIntFromRow(row, "PickingUserId", 0); this.PickingName = DBTool.GetStringFromRow(row, "PickingName", ""); this.PayMethod = DBTool.GetStringFromRow(row, "Pay_Method", ""); this.Memo = DBTool.GetStringFromRow(row, "Memo", ""); StoreManager sm = new StoreManager(); Store store = new Store(sm.GetUserDefaultStore(this.PickingUserId)); this.StoreName = store.Name; sql = string.Format(@" select ROW_NUMBER() over(order by Id) as RowNumber,GoodsId,Left(DisplayName,40) as DisplayName,Unit,Num,SalePrice,Amount from View_OrderDetail where OrderId={0} and IsShow=1 order by Id ", this.OrderId); Details = dbo.GetDataSet(sql).Tables[0]; } }
private bool LoadFromRow(DataRow row) { Id = DBTool.GetIntFromRow(row, "Id", 0); ComId = DBTool.GetIntFromRow(row, "ComId", 0); ModelId = DBTool.GetIntFromRow(row, "ModelId", 0); Level = DBTool.GetIntFromRow(row, "Level", 0); SalesId = DBTool.GetIntFromRow(row, "SalesId", 0); ServiceId = DBTool.GetIntFromRow(row, "ServiceId", 0); StatementManId = DBTool.GetIntFromRow(row, "StatementManId", 0); StatementMan = DBTool.GetStringFromRow(row, "StatementMan", ""); MonthSales = DBTool.GetDoubleFromRow(row, "MonthSales", 0); OrderMemo = DBTool.GetStringFromRow(row, "OrderMemo", ""); PackageType = DBTool.GetStringFromRow(row, "PackageType", ""); PackageMemo = DBTool.GetStringFromRow(row, "PackageMemo", ""); Sign = DBTool.GetStringFromRow(row, "Sign", ""); DeliveryMemo = DBTool.GetStringFromRow(row, "DeliveryMemo", ""); PayType = DBTool.GetStringFromRow(row, "PayType", ""); PayMethod = DBTool.GetStringFromRow(row, "PayMethod", ""); Credit = DBTool.GetDoubleFromRow(row, "Credit", 0); CreditDays = DBTool.GetIntFromRow(row, "CreditDays", 0); StatementMemo = DBTool.GetStringFromRow(row, "StatementMemo", ""); InvoiceType = DBTool.GetStringFromRow(row, "InvoiceType", ""); Invoice_Name = DBTool.GetStringFromRow(row, "Invoice_Name", ""); Invoice_Content = DBTool.GetStringFromRow(row, "Invoice_Content", ""); Invoice_TaxNo = DBTool.GetStringFromRow(row, "Invoice_TaxNo", ""); Invoice_Address = DBTool.GetStringFromRow(row, "Invoice_Address", ""); Invoice_Phone = DBTool.GetStringFromRow(row, "Invoice_Phone", ""); Invoice_Bank = DBTool.GetStringFromRow(row, "Invoice_Bank", ""); Invoice_BankAccount = DBTool.GetStringFromRow(row, "Invoice_BankAccount", ""); InvoiceMemo = DBTool.GetStringFromRow(row, "InvoiceMemo", ""); AddTime = DBTool.GetDateTimeFromRow(row, "AddTime"); UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime"); StartOrder = DBTool.GetIntFromRow(row, "StartOrder", 0); IsSPAssess = DBTool.GetIntFromRow(row, "IsSPAssess", 0); BranchId = DBTool.GetIntFromRow(row, "BranchId", 0); IsNational = DBTool.GetIntFromRow(row, "IsNational", 0); ConfirmLevel = DBTool.GetIntFromRow(row, "ConfirmLevel", 0); IsPass = DBTool.GetIntFromRow(row, "IsPass", 0); IsAgainConfirm = DBTool.GetIntFromRow(row, "IsAgainConfirm", 0); IsManyNum = DBTool.GetIntFromRow(row, "IsManyNum", 0); IsComfirmOrder = DBTool.GetIntFromRow(row, "IsComfirmOrder", 0); IsCounter = DBTool.GetIntFromRow(row, "IsCounter", 0); IsBudget = DBTool.GetIntFromRow(row, "IsBudget", 0); IsArchive = DBTool.GetIntFromRow(row, "IsArchive", 0); OrderPrintNum = DBTool.GetIntFromRow(row, "OrderPrintNum", 0); IsBuyOutCounter = DBTool.GetIntFromRow(row, "IsBuyOutCounter", 0); IsDownloadOrder = DBTool.GetIntFromRow(row, "IsDownloadOrder", 0); IsStoreManager = DBTool.GetIntFromRow(row, "IsStoreManager", 0); //库存管理 IsBanningOrders = DBTool.GetStringFromRow(row, "IsBanningOrders", ""); //客户下单管理 IsOrderConfig = DBTool.GetIntFromRow(row, "IsOrderConfig", 0); TaxRate = DBTool.GetDoubleFromRow(row, "TaxRate", 0); return(true); }
private bool LoadFromRow(DataRow row) { Id = DBTool.GetIntFromRow(row, "Id", 0); GoodsId = DBTool.GetIntFromRow(row, "GoodsId", 0); Point = DBTool.GetIntFromRow(row, "Point", 0); MaxNum = DBTool.GetIntFromRow(row, "MaxNum", 0); IsValid = DBTool.GetIntFromRow(row, "IsValid", 1); GiftName = DBTool.GetStringFromRow(row, "GiftName", ""); UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime"); UserId = DBTool.GetIntFromRow(row, "UserId", 0); return(true); }
private void LoadFromRow(DataRow row) { Id = DBTool.GetIntFromRow(row, "Id", 0); StoreId = DBTool.GetIntFromRow(row, "StoreId", 0); Type = DBTool.GetStringFromRow(row, "Type", ""); Name = DBTool.GetStringFromRow(row, "Name", ""); Code = DBTool.GetStringFromRow(row, "Code", ""); PCode = DBTool.GetStringFromRow(row, "PCode", ""); Memo = DBTool.GetStringFromRow(row, "Memo", ""); AddTime = DBTool.GetDateTimeFromRow(row, "AddTime"); UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime"); }