public GoodsCommentOption()
{
GoodsId = 0;
MemberId = 0;
Level = 0;
Label = "";
StartDate = new DateTime(1900, 1, 1);
EndDate = new DateTime(1900, 1, 1);
KeyWords = "";
recordControl = new RecordControl();
}
public VIPCounterOption()
{
m_Key = "";
m_Code = "";
m_ComId = 0;
m_IsUseRecordControl = 0;
m_CounterId = 0;
m_IsVisible = 1;
m_KeyWords = "";
m_recordControl = new RecordControl();
m_BranchId = 0;
}
public DataSet ReadVIPGoods(string keyWords, string code, RecordControl rc)
{
string sql = string.Format(" select * from view_comgoods where comId={0} and IsVisible >=0 ", m_Id);
if (keyWords != "")
{
if (keyWords.Length > 2)
{
keyWords = CommenClass.StringTools.SplitKeyWords(keyWords);
}
char[] sep = { ' ' };
string[] kws = keyWords.Split(sep, StringSplitOptions.RemoveEmptyEntries);
if (kws.Length == 1)
{
if (kws[0].Length <= 2)//关键字太短的时候，只从 SN和GoodsName中筛选
{
sql += string.Format(" and ((SN like '%{0}%') or (PY like '%{0}%') or (goodsName like '%{0}%')) ", kws[0]);
}
else
{
sql += string.Format(" and ((SN like '%{0}%') or (goodsName like '%{0}%') or (PY like '%{0}%') or (Feature like '%{0}%')) ", kws[0]);
}
}
else
{
for (int i = 0; i < kws.Length; i++)
{
sql += string.Format(" and ((SN like '%{0}%') or (goodsName like '%{0}%') or (PY like '%{0}%') or (Feature like '%{0}%')) ", kws[i]);
}
}
}
if (code != "")
{
sql += string.Format(" and code like '{0}%' ", code);
}
sql += " order by recommend desc,Code ";
return(m_dbo.GetDataSet(sql, rc.StartRecord, rc.PageSize));
}
public GoodsOption()
{
TypeId = 0;
IsVisible = 1;
PCode = "";
KeyWords = "";
Order = 0;
ComId = 0;
Cuxiao = 0;
New = 0;
Hot = 0;
IsVIP = 0;
BrandId = 0;
Description = 0;
EndPrice = 0;
StartPrice = 0;
StartMaolilv = -1;
EndMaolilv = -1;
NoPhoto = 0;
HomePhoto = 0;
DetailPhoto = 0;
NoBarCode = 0;
ShortageBarCode = 0;
IsUseRecorControl = 0;
recordContorl = new RecordControl();
GoodsId = 0;
IsAllow = -1;
IsPublic = -1;
IsShelves = -1;
BranchId = 0;
ParentId = 0;//一般情况下读取的是基本商品 q
AddTime = new DateTime(1900, 1, 1);
IsUseSiteGoods = 0;
IsHideParentGoods = 0;
Memo = "";
GoodsIds = "0";
}
