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