public OrderModify()
{
m_Id = 0;
m_OrderId = 0;
m_GoodsId = 0;
m_Model = "";
m_OldNum = 0;
m_NewNum = 0;
m_OldPrice = 0;
m_NewPrice = 0;
m_UserId = 0;
m_PurchaseType = "";
m_UpdateTime = DateTime.Now;
m_dbo = new DBOperate();
}
public Sys_BranchActivity()
{
Id = 0;
BranchId = 0;
Title = "";
Content = "";
PhotoPath = "";
StartDateTime = DateTime.Now.Date;
EndDateTime = DateTime.Now.Date;
UpdateDateTime = DateTime.Now;
IsAvailable = 0;
Link = "";
Background = "";
m_dbo = new DBOperate();
}
public News()
{
m_Id = 0;
m_Title = "";
m_NewsTypeId = 0;
m_NewsKeywords = "";
m_Author = "";
m_PublishDate = DateTime.Now;
m_ImageUrl = "";
m_Content = "";
m_Recommend = 0;
m_Describe = "";
m_IsCheck = 0;
m_dbo = new DBOperate();
}
public StoreCustomerMeg()
{
Id = 0;
GoodsId = 0;
DisplayName = "";
Num = 0;
Price = 0;
UpdateTime = DateTime.Now;
DeptId = 0;
ComId = 0;
SDeptId = 0;
SMemberId = 0;
Allow = 0;
m_dbo = new DBOperate();
m_pageModel = new PageModel();//分页
}
public Goodspackagelog()
{
Id = 0;
GoodsId = 0;
Type = "";
OldNum = 0;
Num = 0;
OldName = "";
Name = "";
IsDefault = 0;
OldBarCode = "";
BarCode = "";
UserId = 0;
UpdateTime = DateTime.Now;
m_dbo = new DBOperate();
}
} //quxiaoshan 2015-5-21
public Dept()
{
m_Id = 0;
m_ComId = 0;
m_Name = "";
m_Code = "";
m_PCode = "";
m_Level = 0;
m_IsCalc = 0;
m_UpdateTime = DateTime.Now;
m_BranchId = 1;
m_IsSepareOrder = 0;
ExportDate = Convert.ToDateTime("1900-01-01 00:00:00.000");
m_SecrecyId = 0;
m_dbo = new DBOperate();
}
} //add by quxiaoshan 2014-11-07
public OrderReceiveMoney()
{
m_Id = 0;
m_BranchId = 0;
m_OrderStatementId = 0;
m_ReceiveMoney = 0;
//m_YouHui = 0;
m_PayStatus = "";
m_BankAccountId = 0;
m_PayType = "";
m_Memo = "";
m_UserId = 0;
m_UpdateTime = DateTime.Now;
m_ChargeOff = 0;
m_dbo = new DBOperate();
}
public PurchasePay()
{
m_Id = 0;
m_BranchId = 0;
m_PurchaseStatementId = 0;
m_PayMoney = 0;
m_PayStatus = "";
m_BankAccountId = 0;
m_PayType = "";
m_Memo = "";
m_UserId = 0;
m_PayDate = DateTime.Now;
m_UpdateTime = DateTime.Now;
m_ChargeOff = 0;
m_dbo = new DBOperate();
}
public TPI_Category()
{
Id = 0;
ProjectId = 0;
Category1 = "";
Category2 = "";
Category = "";
CategoryId = 0;
TypeName = "";
TypeId = 0;
UpdateTime = DateTime.Now;
CategoryCode = "";
Discount = 0;
UserId = 0;
m_dbo = new DBOperate();
}
public OrderStatement()
{
m_Id = 0;
m_BranchId = 0;
m_ComId = 0;
m_Memo = "";
m_SumMoney = 0;
m_PaidMoney = 0;
m_PayStatus = "";
m_UserId = 0;
m_PrintNum = 0;
m_UpdateTime = DateTime.Now;
m_InvoiceMoney = 0;
m_NeedToInvoice = 0;
m_dbo = new DBOperate();
}
public PurchaseDetailLog()
{
m_Id = 0;
m_PurchaseId = 0;
m_StoreId = 0;
m_UserId = 0;
m_GoodsId = 0;
m_OldNum = 0;
m_Num = 0;
m_NewNum = 0;
m_OldPrice = 0;
m_NewPrice = 0;
m_Memo = "";
m_UpdateTime = DateTime.Now;
m_dbo = new DBOperate();
}
public GoodStoreInventoryDetail()
{
ID = 0;
FK_GSDetail_ID = 0;
FK_Goods_ID = 0;
FK_Store_ID = 0;
OldNum = 0;
NewNum = 0;
AC = 0;
CreateUser = 0;
CreateTime = DateTime.Now;
OldSumMoney = 0;
NewSumMoney = 0;
FK_GSInventory_ID = 0;
m_dbo = new DBOperate();
}
public Budget()
{
Id = 0;
ComId = 0;
DeptId = 0;
MemberId = 0;
IsDept = 0;
IsPersonal = 0;
YearBudget = 0;
MonthBudget = 0;
MaxOrderNum = 0;
StartDate = DateTime.Now;
EndDate = DateTime.Now;
UpdateTime = DateTime.Now;
m_dbo = new DBOperate();
}
public TPI_Project()
{
Id = 0;
Name = "";
UpdateTime = DateTime.Now;
IsUseTypeCompare = 0;
IsUseBrandCompare = 0;
BranchId = 1;
Developers = "";
PortNumber = 0;
Note = "";
Url = "";
PushType = 0;
IsDiscount = 0;
m_dbo = new DBOperate();
}
public Supplier()
{
m_Id = 0;
m_AddTime = DateTime.Now;
m_UpdateTime = DateTime.Now;
m_Company = "";
m_ShortName = "";
m_Type = "";
m_Attitude = "";
m_PriceSheet = 0;
m_InvoiceType = "";
m_PayType = "";
m_YearTarget = 0;
m_MonthAmount = 0;
m_LinkMan1 = "";
m_LinkMan2 = "";
m_TelPhone1 = "";
m_TelPhone2 = "";
m_Mobile1 = "";
m_Mobile2 = "";
m_QQ1 = "";
m_QQ2 = "";
m_Address = "";
m_MainBrand = "";
m_Major = "";
m_BillsDiscount = 100;
m_Branchid = 0;
m_ContractType = "";
m_IsChangRefund = "";
m_PurchasRewards = "";
m_PaymentMethod = "";
m_AccountNum = "";
m_TaxpayerIdentificationCode = "";
m_OpenBank = "";
m_FinancialLinkMan = "";
m_FinancialTelPhone = "";
m_Other = "";
m_GoodsTypeId = 0;
m_PY = "";
m_TaxRate = 0;
m_WarhouseAddress = "";
m_OfficeAddress = "";
m_Delivery = "";
m_DeliveryRegion = "";
m_dbo = new DBOperate();
}
public InvoiceRequire()
{
m_Id = 0;
m_ComId = 0;
m_StatementId = 0;
m_InvoiceName = "";
m_InvoiceType = "";
m_InvoiceContent = "";
m_InvoiceAmount = 0;
m_InvoiceMemo = "";
m_UserId = 0;
m_UpdateTime = DateTime.Now;
m_InvoiceStatus = CommenClass.InvoiceStatus.待开票.ToString();
m_MemberInvoiceId = 0;
m_applicationNo = "";
m_dbo = new DBOperate();
}
public bool Delete()
{
DBOperate dbOperate = new DBOperate();
if (m_Id > 0)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("Id", m_Id)
};
return(dbOperate.DeleteAt("News", param));
}
else
{
return(false);
}
}
public TPI_Users()
{
Id = 0;
AppKey = "";
AppSecret = "";
Sign = "";
InterfaceVersion = "";
Name = "";
Token = "";
State = 0;
CallDate = DateTime.Now;
EndDate = DateTime.Now;
ProjectId = 0;
AppPassword = "";
ClientSecret = "";
m_dbo = new DBOperate();
}
public GoodsBrowse()
{
Id = 0;
GoodsId = 0;
LoginName = "";
Company = "";
IsIntheCart = 0;
Ip = "";
Port = "";
Province = "";
City = "";
BrowseType = "";
ClientMark = "";
Guid = "";
UpdateTime = DateTime.Now;
m_dbo = new DBOperate();
}
public Transfer()
{
Id = 0;
OutBranchId = 0;
InBranchId = 0;
OutStoreId = 0;
OutStoreUserId = 0;
InStoreId = 0;
InStoreUserId = 0;
Memo = "";
UpdateDate = DateTime.Now;
OutStoreDate = new DateTime(1900, 1, 1);
InStoreDate = new DateTime(1900, 1, 1);
Status = "";
IsInner = 0;
m_dbo = new DBOperate();
}
public Invoice()
{
m_Id = 0;
m_BranchId = 0;
m_ComId = 0;
m_OrderStatementId = 0;
m_InvoiceRequireId = 0;
m_InvoiceDate = DateTime.Now;
m_InvoiceNo = "";
m_InvoiceType = "";
m_InvoiceMoney = 0;
m_Memo = "";
m_UpdateTime = DateTime.Now;
m_UserId = 0;
m_PrintNum = 0;
m_PrintTime = DateTime.Now;
m_dbo = new DBOperate();
}
public TPI_Goods()
{
Id = 0;
Sku = "";
SkuName = "";
ReferencePrice = 0;
AgreementPrice = 0;
GoodsId = 0;
IshaveImage = 0;
IsUnitAgreement = 0;
State = 0;
ProjectId = 0;
Stock = 0;
PushState = -2;
ResultMsg = "";
AddTime = DateTime.Now;
m_dbo = new DBOperate();
}
public GoodsBranch()
{
Id = 0;
GoodsId = 0;
BranchId = 0;
IsVisible = 0;
IsAllow = 0;
IsPublic = 0;
UserId = 0;
UpdateTime = DateTime.Now;
IsWeb = 0;
Price = 0;
PriceRate = 0;
IsChangePrice = 0;
IsChangeRecommend = 0;
Recommend = 1;
m_dbo = new DBOperate();
}
public GoodsStoreDetail()
{
m_Id = 0;
m_StoreId = 0;
m_GoodsId = 0;
m_Model = "";
m_OldNum = 0;
m_Num = 0;
m_NewNum = 0;
m_Operate = "";
m_RelationId = 0;
m_Memo = "";
m_UserId = 0;
m_AC = 0;
TaxAC = 0;
m_UpdateTime = DateTime.Now;
m_dbo = new DBOperate();
}
public PurchaseDetail()
{
m_Id = 0;
m_PurchaseId = 0;
m_GoodsId = 0;
m_StoreId = 0;
m_Model = "";
m_BillsPrice = 0;
m_InPrice = 0;
m_Num = 0;
m_Amount = 0;
m_OldStore = 0;
m_OldAC = 0;
m_ReceivedNum = 0;
m_Emergency = 0;
TaxInPrice = 0;
m_dbo = new DBOperate();
}
public Sys_BranchDetail(int branchId)
{
m_dbo = new DBOperate();
string sql = string.Format("select * from Sys_BranchDetail where branchid={0}", branchId);
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);
BranchId = DBTool.GetIntFromRow(row, "BranchId", 0);
Square = DBTool.GetIntFromRow(row, "Square", 0);
Car = DBTool.GetIntFromRow(row, "Car", 0);
Introduction = DBTool.GetStringFromRow(row, "Introduction", "");
EnIntroduction = DBTool.GetStringFromRow(row, "EnIntroduction", "");
PeopleNum = DBTool.GetIntFromRow(row, "PeopleNum", 0);
UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime");
}
}
public MemberAddress()
{
m_Id = 0;
m_MemberId = 0;
m_RealName = "";
m_Address = "";
m_Province = "";
m_City = "";
m_Area = "";
m_Street = "";
m_Mansion = "";
m_Room = "";
m_TelPhone = "";
m_Mobile = "";
m_Email = "";
m_IdCard = "";
m_dbo = new DBOperate();
m_IsDefault = 0;
}
/// <summary>
/// 检查短信验证码
/// cml：20170710
/// </summary>
/// <param name="telnumber">手机号</param>
/// <param name="code">短信验证码</param>
/// <returns></returns>
public static bool CheckSmsverifycode(string telnumber, string code)
{
bool result = false;
if (!string.IsNullOrEmpty(telnumber) && !string.IsNullOrEmpty(code))
{
DBOperate dbo = new DBOperate();
string sqlStr = "select SMSCode from Smsstore where Mobile='" + telnumber + "'";
DataTable dt = dbo.GetDataSet(sqlStr).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
if (dt.Rows[0][0].ToString() == code)
{
result = true;
}
}
}
return(result);
}
public GoodsType(string connectionString)
{
m_Id = 0;
m_TypeName = "";
m_EnTypeName = "";
m_Code = "";
m_PCode = "";
m_Level = 0;
m_PriceRate = 100;
m_Alias = "";
m_IsVisible = 1;
m_Rate = 100;
m_BieMing = "";
m_GuiGe = "";
m_JiaGe = "";
m_UpdateTime = DateTime.Now;
m_PY = "";
pageModel = new PageModel();
m_dbo = new DBOperate(connectionString);
}
public TPI_Supplierorder()
{
Id = 0;
OrderId = 0;
RealName = "";
Address = "";
DetailStreet = "";
ZipCode = "";
Telephone = "";
Mobile = "";
Email = "";
Memo = "";
Amount = 0;
ShipFree = 0;
GoodsList = "";
UpdateTime = DateTime.Now;
UsersId = 0;
// Distribution = 0;
m_dbo = new DBOperate();
}