/// <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);
}
