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