/// <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 NeedToPurchaseDetail 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_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 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); }
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 PurchaseDetail 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_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); }
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); }
/// <summary> /// 检查是否已经评论 /// </summary> /// <param name="MemberId"></param> /// <param name="OrderId"></param> /// <param name="GoodsId"></param> /// <returns></returns> public int CheckIsSubmit(int MemberId, int OrderId, int GoodsId) { string sql = " select * from GoodsComment where 1=1"; if (MemberId > 0) { sql += string.Format(" and MemberId={0} ", MemberId); } if (OrderId > 0) { sql += string.Format(" and OrderId={0} ", OrderId); } if (GoodsId > 0) { sql += string.Format(" and GoodsId={0} ", GoodsId); } DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { return(1); } return(0); }
/// <summary> /// 读取销售业绩表 /// </summary> /// <param name="option"></param> /// <returns></returns> public DataSet ReadSalesTarget(SalesTargetOption option) { string sql = " select * from view_SalesTarget where 1=1 "; if (option.BranchId > 0) { sql += string.Format(" and BranchId={0}", option.BranchId); } if (option.SalesId > 0) { sql += string.Format(" and SalesId={0} ", option.SalesId); } if (option.DeptId > 0) { sql += string.Format(" and DeptId={0} ", option.DeptId); } if (option.StartMonth != new DateTime(1900, 1, 1)) { sql += string.Format(" and YearMonth >= '{0}' ", option.StartMonth.ToShortDateString()); } if (option.EndMonth != new DateTime(1900, 1, 1)) { sql += string.Format(" and YearMonth <='{0}' ", option.EndMonth.AddDays(1).ToShortDateString()); } sql += " order by SalesId,YearMonth "; return(m_dbo.GetDataSet(sql)); }
/// <summary> /// 读取商品品论 /// </summary> /// <param name="option"></param> /// <returns></returns> public DataSet ReadGoodsComment(GoodsCommentOption option) { string sql = " select * from View_GoodsComment where 1=1 "; if (option.EndDate != new DateTime(1900, 1, 1)) { sql += string.Format(" and UpdateTime < '{0}' ", option.EndDate.AddDays(1).ToShortDateString()); } if (option.GoodsId > 0) { sql += string.Format(" and GoodsId={0} ", option.GoodsId); } if (option.KeyWords != "") { sql += string.Format(" and Content like '%{0}%' ", option.KeyWords); } if (option.Label != "") { sql += string.Format(" and Label = '{0}' ", option.Label); } if (option.Level > 0) { switch (option.Level) { case 5: sql += string.Format(" and ( Level = 5 or Level=4)", option.Level); break; case 3: sql += string.Format(" and ( Level = 3 or Level=2)", option.Level); break; case 1: sql += string.Format(" and Level = 1", option.Level); break; default: break; } } if (option.MemberId > 0) { sql += string.Format(" and MemberId={0} ", option.MemberId); } if (option.StartDate != new DateTime(1900, 1, 1)) { sql += string.Format(" and UpdateTime >='{0}' ", option.StartDate.ToShortDateString()); } sql += " order by UpdateTime Desc "; //分页控制 if (option.recordControl.PageSize == 0) { return(m_dbo.GetDataSet(sql)); } else { return(m_dbo.GetDataSet(sql, option.recordControl.StartRecord, option.recordControl.PageSize)); } }
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); }
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> /// /// </summary> /// <param name="option">orderby:0 recommend desc,point;1:point,recommend desc;2:point desc,recommend desc</param> /// <returns></returns> /// public DataSet ReadGift() { string sql = string.Format("select * from View_Gift where IsValid=1"); if (option.Code != "") { sql += string.Format(" and Code like '{0}%' ", option.Code); } if (option.TypeId > 0) { sql += string.Format(" and TypeId={0} ", option.TypeId); } switch (option.OrderBy) { case 0: sql += " order by Recommend Desc,Point "; break; case 1: sql += " order by Point Desc,Recommend Desc "; break; case 2: sql += " order by Point,Recommend Desc "; break; default: sql += " order by Recommend desc, Point"; break; } sql += ";select @@ROWCOUNT"; return(m_dbo.GetDataSet(sql, (option.pageModel.CurrentPage - 1) * option.pageModel.PageSize, option.pageModel.PageSize)); }
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 DataSet ReadByCompany(string supplierName) { string sql = string.Format(@"select SupplierPriceList.Id as SupplierPriceId,Supplier.ID as SupplierId , (select COUNT(*) from dbo.SupplierPriceListDetail where dbo.SupplierPriceListDetail.SupplierPriceListId=dbo.SupplierPriceList.Id) as GoodsCount ,* from dbo.SupplierPriceList inner join dbo.Supplier on dbo.SupplierPriceList.SupplierId=dbo.Supplier.ID where Company like '%{0}%' order by SupplierPriceList.UpdateTime", supplierName); return(m_dbo.GetDataSet(sql)); }
/// <summary> /// 读取公司所有的预算设置,供管理员查看 /// </summary> /// <param name="ComId"></param> /// <returns></returns> public DataSet ReadCompanyBudget(int ComId) { string sql = string.Format(@"select * from Budget where ComId={0} and IsPersonal=1; select * from Budget where ComId={0} and IsDept=1; select * from Budget where ComId={0} and IsPersonal=0 and IsDept=0 and MemberId=0 and DeptId=0", ComId); return(m_dbo.GetDataSet(sql)); }
/// <summary> /// 读取所有待开票记录 /// </summary> /// <returns></returns> public DataSet ReadInvoiceRequire() { string sql = string.Format(@"select * from view_InvoiceRequire where branchId={0} and InvoiceType='增票' and InvoiceStatus='待开票' order by Id ; select * from view_InvoiceRequire where branchId={0} and InvoiceType='普票' and InvoiceStatus='待开票' order by Id ; select * from view_InvoiceRequire where branchId={0} and InvoiceType='收据' and InvoiceStatus='待开票' order by Id ;", Option.BranchId); return(m_dbo.GetDataSet(sql)); }
/// <summary> /// 读取品牌对应的类别,查询出一级,二级,三级的类别名称,code,商品数量 add by quxiaoshan /// </summary> /// <returns></returns> public DataSet ReadGoodsTypeByBrandId() { string sql = string.Format(@"select SUBSTRING ( PCode,1, 2) as PPCode ,(select TypeName from GoodsType where Code= SUBSTRING ( dbo.GoodsType.PCode,1, 2) ) as PPTypeName , PCode,(select TypeName from GoodsType where Code= dbo.GoodsType.PCode ) as PTypeName , Code,TypeName, COUNT(Code) as TypeNum from dbo.Goods join dbo.GoodsType on dbo.Goods.TypeId=dbo.GoodsType.ID where BrandId={0} and IsShelves=1 and Goods.IsVisible =1 group by Code,PCode ,TypeName;", brandOption.BrandId); return(m_dbo.GetDataSet(sql)); }
/// <summary> /// 读取branchId加盟商站点对应仓库 /// 调用;FPurchase.cs /// </summary> /// <param name="branchId">branchId加盟商Id,branchId==0时,读取的是所有的仓库</param> /// <returns></returns> public DataSet ReadStores(int branchId) { string sql = string.Format("select * from Store where 1=1 "); if (branchId > 0) { sql += string.Format(" and BranchId={0} ", branchId); } sql += " order by IsDefault desc,Name "; return(m_dbo.GetDataSet(sql)); }
public bool Load() { string sql = string.Format("select * from OrderPicking where id={0}", Id); DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count == 1) { return(LoadFromRow(ds.Tables[0].Rows[0])); } return(false); }
public bool Load() { string sql = string.Format("select * from StoreZone where id={0}", Id); DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count == 1) { LoadFromRow(ds.Tables[0].Rows[0]); return(true); } return(false); }
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 bool Load() { string sql = string.Format("select * from Notice where Id={0}", Id); DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; return(LoadFromRow(row)); } 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]; } }
public bool Load() { string sql = string.Format("select * from EmailServ where id={0}", Id); DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count == 1) { DataRow row = ds.Tables[0].Rows[0]; LoadFromRow(row); return(true); } return(false); }
/// <summary> /// ERP:FGoods.cs /// </summary> /// <param name="GoodsId"></param> /// <param name="type"></param> /// <returns></returns> public bool Load(int GoodsId, string type) { string sql = string.Format("select * from GoodsPackage where goodsId={0} and Type='{1}' ", GoodsId, type); DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count == 1) { DataRow row = ds.Tables[0].Rows[0]; LoadFromRow(row); return(true); } return(false); }
/// <summary> /// 原版显示省市区,调用地方太多,暂不修改--平台使用 /// 调用:ERP FGoodsAllow.cs /// </summary> /// <returns></returns> public DataSet ReadBranch() { string sql = "select b.*,p.Code,p.level from Sys_Branch b join Province p on b.CityId = p.Id where 1=1 "; if (option.IsUnable > -1) { sql += string.Format(" and IsUnable = {0} ", option.IsUnable); } if (option.Name != "") { sql += string.Format(" and b.Name like '%{0}%' ", option.Name); } sql += " order by Code,CitySort,City "; return(m_dbo.GetDataSet(sql)); }
/// <summary> /// 获取车辆当前驾驶员 /// </summary> /// <param name="CarId"></param> /// <returns></returns> public Sys_Users GetCarUser(int CarId) { string sql = string.Format(" select top 1 * from sys_caruser where CarId={0} order by updatetime desc", CarId); DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count == 1) { Sys_Users su = new Sys_Users(DBTool.GetIntFromRow(ds.Tables[0].Rows[0], "UserId", 0)); return(su); } else { return(null); } }
public bool Load() { string sql = string.Format("select * from GoodsParamType 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", ""); GoodsTypeId = DBTool.GetIntFromRow(row, "GoodsTypeId", 0); return(true); } return(false); }
public bool Load() { string sql = string.Format("select * from CompanyType 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_TypeName = DBTool.GetStringFromRow(row, "TypeName", ""); m_UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime"); 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); }