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> /// 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 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); }
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", ""); }
/// <summary> /// 超额付清 /// </summary> /// <param name="ChargeOff"></param> /// <param name="ReceiveMoney"></param> private void UpdateOrderPayStatysCEFQ(double ChargeOff, double ReceiveMoney) { //将该对账单所有的订单收款状态初始化 string sql = string.Format(@"update [Order] set PayStatus='已对账',PaidMoney=0,ChargeOff=0 where Id in( select OrderId from OrderStatementDetail where OrderStatementId={0})", this.Id); m_dbo.ExecuteNonQuery(sql); //读取改对账单对应的所用订单列表 sql = string.Format("select * from View_OrderStatementDetail where OrderStatementId={0} order by OrderId ", this.Id); DataSet ds = m_dbo.GetDataSet(sql); //循环 订单列表,按照时间先后进行销账处理 double allchargeoff = ChargeOff; double allreceivemoney = ReceiveMoney; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow row = ds.Tables[0].Rows[i]; int orderId = DBTool.GetIntFromRow(row, "OrderId", 0); double summoney = Math.Round(DBTool.GetDoubleFromRow(row, "SumMoney", 0), 2); string paystatus = CommenClass.PayStatus.已付款.ToString(); double chargeoff = summoney; double paidmoney = summoney; allchargeoff -= chargeoff; allreceivemoney -= paidmoney; if (i == ds.Tables[0].Rows.Count - 1) { paidmoney = summoney + allreceivemoney; } sql = string.Format("update [Order] set PayStatus='{0}',PaidMoney={1},ChargeOff={2} where Id={3}", paystatus, paidmoney, chargeoff, orderId); m_dbo.ExecuteNonQuery(sql); } }
/// <summary> /// 读取分页的总条数 /// </summary> /// <returns></returns> public int PageNewsListTotalRows(int branchId) { string sql = ""; if (branchId == -2) { //仅网站首页展示新闻信息用到 GetNewsWhere() sql += string.Format("select COUNT(*) as count from dbo.View_News where 1=1 {0} ", GetNewsWhere()); } else { sql += string.Format("select COUNT(*) as count from dbo.View_News where 1=1 {0} ", GetNewsSqlWhere()); } if (branchId >= 0) { sql += string.Format(" and branchId={0}", branchId); } DataRowCollection collection = dbOperate.GetDataSet(sql).Tables[0].Rows; if (collection.Count > 0) { return(DBTool.GetIntFromRow(collection[0], "count", 0)); } return(0); }
/// <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); }
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 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 CrawInfo 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); BiddingName = DBTool.GetStringFromRow(row, "BiddingName", ""); BiddingUrl = DBTool.GetStringFromRow(row, "BiddingUrl", ""); Biddingcharset = DBTool.GetStringFromRow(row, "Biddingcharset", ""); Brddingrecording = DBTool.GetStringFromRow(row, "Brddingrecording", ""); CrawlUrl = DBTool.GetStringFromRow(row, "CrawlUrl", ""); Crawtitle = DBTool.GetStringFromRow(row, "Crawtitle", ""); Istitle = DBTool.GetIntFromRow(row, "Istitle", 0); Crawarea = DBTool.GetStringFromRow(row, "Crawarea", ""); CrawTime = DBTool.GetStringFromRow(row, "CrawTime", ""); CrawPosition = DBTool.GetStringFromRow(row, "CrawPosition", ""); Crawfrequency = DBTool.GetIntFromRow(row, "Crawfrequency", 0); Remark = DBTool.GetStringFromRow(row, "Remark", ""); return(true); } return(false); }
/// <summary> /// 重新计算订单毛利 //该方法位置有问题 /// </summary> /// <returns></returns> public bool CalcGrossProfit() { string sql = ""; this.Load(); OrderManager om = new OrderManager(); DataSet details = om.ReadOrderDetail(this.Id); foreach (DataRow row in details.Tables[0].Rows) { //循环订单明细 int goodsId = DBTool.GetIntFromRow(row, "GoodsId", 0); sql = string.Format("select AC, TaxAC from View_GoodsStore where BranchId={0} and GoodsId={1} and IsDefault=1 order by IsAvalible desc ", this.BranchId, goodsId); //更新商品成本 DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { double AC = DBTool.GetDoubleFromRow(ds.Tables[0].Rows[0], "AC", 0); double TaxAC = DBTool.GetDoubleFromRow(ds.Tables[0].Rows[0], "TaxAC", 0); sql = string.Format(@"update OrderDetail set AC={0} ,TaxAC={3} where OrderId={1} and GoodsId={2} ", AC, this.Id, goodsId, TaxAC); m_dbo.ExecuteNonQuery(sql); } } //更新订单毛利 sql = string.Format(@"update [Order] set GrossProfit = SumMoney/(1+TaxRate)-(select isnull(SUM(AC*Num),0) from OrderDetail where OrderId ={0}), TaxGrossProfit = SumMoney - (select isnull(SUM(TaxAC*Num),0) from OrderDetail where OrderId ={0}) where Id ={0}", this.Id); return(m_dbo.ExecuteNonQuery(sql)); }
public int ReadVIPGoodsCount() { string sql = "select count(*) as GoodsCount from Goods where Recommend =6"; DataSet ds = m_dbo.GetDataSet(sql); return(DBTool.GetIntFromRow(ds.Tables[0].Rows[0], "GoodsCount", 0)); }
/// <summary> /// 读取订单有多少 图片归档 /// </summary> /// <returns></returns> public int ReadPhotoNum() { string sql = string.Format("select COUNT(OrderId) as num from orderphoto where OrderId={0} ", this.OrderId); DataSet ds = m_dbo.GetDataSet(sql); return(DBTool.GetIntFromRow(ds.Tables[0].Rows[0], "num", 0)); }
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); }
public bool Load() { string sql = string.Format("select * from Sys_Branch 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", ""); ShortName = DBTool.GetStringFromRow(row, "ShortName", ""); City = DBTool.GetStringFromRow(row, "City", ""); Address = DBTool.GetStringFromRow(row, "Address", ""); Telphone = DBTool.GetStringFromRow(row, "Telphone", ""); LinkMan = DBTool.GetStringFromRow(row, "LinkMan", ""); Bank = DBTool.GetStringFromRow(row, "Bank", ""); Account = DBTool.GetStringFromRow(row, "Account", ""); Complain_hotline = DBTool.GetStringFromRow(row, "Complain_hotline", ""); Print_title = DBTool.GetStringFromRow(row, "Print_title", ""); Province = DBTool.GetStringFromRow(row, "Province", ""); IsUnable = DBTool.GetIntFromRow(row, "IsUnable", 0); ProvinceSort = DBTool.GetIntFromRow(row, "ProvinceSort", 0); CitySort = DBTool.GetIntFromRow(row, "CitySort", 0); IsUseSiteGoods = DBTool.GetIntFromRow(row, "IsUseSiteGoods", 0); CityId = DBTool.GetIntFromRow(row, "CityId", 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() { 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 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); }
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 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); }
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(int pId, int goodsId) { string sql = string.Format("select * from PurchaseDetail where PurchaseId={0} and GoodsId={1}", pId, 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_PurchaseId = DBTool.GetIntFromRow(row, "PurchaseId", 0); m_GoodsId = DBTool.GetIntFromRow(row, "GoodsId", 0); m_StoreId = DBTool.GetIntFromRow(row, "StoreId", 0); m_Model = DBTool.GetStringFromRow(row, "Model", ""); m_BillsPrice = DBTool.GetDoubleFromRow(row, "BillsPrice", 0); m_InPrice = DBTool.GetDoubleFromRow(row, "InPrice", 0); m_Num = DBTool.GetIntFromRow(row, "Num", 0); m_Amount = DBTool.GetDoubleFromRow(row, "Amount", 0); m_OldStore = DBTool.GetIntFromRow(row, "OldStore", 0); m_OldAC = DBTool.GetDoubleFromRow(row, "OldAC", 0); m_ReceivedNum = DBTool.GetIntFromRow(row, "ReceivedNum", 0); m_Emergency = DBTool.GetIntFromRow(row, "Emergency", 0); TaxInPrice = DBTool.GetDoubleFromRow(row, "TaxInPrice", 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 MemberAddress 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_MemberId = DBTool.GetIntFromRow(row, "MemberId", 0); m_RealName = DBTool.GetStringFromRow(row, "RealName", ""); m_Address = DBTool.GetStringFromRow(row, "Address", ""); m_Province = DBTool.GetStringFromRow(row, "Province", ""); m_City = DBTool.GetStringFromRow(row, "City", ""); m_Area = DBTool.GetStringFromRow(row, "Area", ""); m_Street = DBTool.GetStringFromRow(row, "Street", ""); m_Mansion = DBTool.GetStringFromRow(row, "Mansion", ""); m_Room = DBTool.GetStringFromRow(row, "Room", ""); m_TelPhone = DBTool.GetStringFromRow(row, "TelPhone", ""); m_Mobile = DBTool.GetStringFromRow(row, "Mobile", ""); m_Email = DBTool.GetStringFromRow(row, "Email", ""); m_IsDefault = DBTool.GetIntFromRow(row, "IsDefault", 0); m_IdCard = DBTool.GetStringFromRow(row, "IdCard", ""); 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); }
public bool OrderModifyPurchaseSave(DataTable dtNeedToPurchaseDetail, int branchId, int StoreId, string OrderModifyIdTable) { DataTable dt = dtNeedToPurchaseDetail.DefaultView.ToTable(true, "SupplierId", "UserId", "PurchaseType"); if (dt.Rows.Count > 0) { int SId = 0; foreach (DataRow drSupplier in dt.Rows) { int SupplierId = DBTool.GetIntFromRow(drSupplier, "SupplierId", 0); if (SId == SupplierId && SupplierId != 0) { continue; } int UserId = DBTool.GetIntFromRow(drSupplier, "UserId", 0); string PurchaseType = DBTool.GetStringFromRow(drSupplier, "PurchaseType", ""); Purchase p = new Purchase(); p.BranchId = branchId; p.NeedToPurchaseId = NeedToPurchaseId; p.PurchaseStatus = CommenClass.PurchaseStatus.未处理.ToString(); p.PurchaseType = PurchaseType; p.UserId = 0; p.StoreId = StoreId; p.SupplierId = SupplierId; p.PurchaseUserId = UserId; int purchaseId = p.Save(); if (purchaseId > 0) { string sql = string.Format("SupplierId='{0}'", SupplierId); DataRow[] drw = dtNeedToPurchaseDetail.Select(sql); foreach (DataRow dr in drw) { PurchaseDetail pd = new PurchaseDetail(); pd.PurchaseId = purchaseId; pd.GoodsId = DBTool.GetIntFromRow(dr, "GoodsId", 0); pd.StoreId = StoreId; pd.Model = ""; pd.BillsPrice = DBTool.GetDoubleFromRow(dr, "InPrice", 0); pd.InPrice = DBTool.GetDoubleFromRow(dr, "InPrice", 0); pd.Num = DBTool.GetIntFromRow(dr, "LackNum", 0); pd.Amount = pd.InPrice * pd.Num; pd.Save(); } SId = SupplierId; PurchaseManager pm = new PurchaseManager(); pm.UpdatePurchaseSumMoney(purchaseId); } } if (SId > 0) { OrderModify om = new OrderModify(); return(om.UpdatePurchaseType(OrderModifyIdTable)); } } return(false); }