private void setParameter(iSqlParameter[] parms, CategoryattrInfo info)
{
try
{
int i = -1;
parms[++i].Value = CFunctions.SetDBString(info.Code);
parms[++i].Value = CFunctions.SetDBString(info.Name);
parms[++i].Value = CFunctions.SetDBString(info.Note);
parms[++i].Value = CFunctions.SetDBString(info.Url);
parms[++i].Value = CFunctions.SetDBString(info.Filepreview);
parms[++i].Value = info.Cid;
parms[++i].Value = info.Orderd == 0 ? info.Id : info.Orderd;
parms[++i].Value = info.Status;
parms[++i].Value = info.Markas;
parms[++i].Value = info.Iconex;
parms[++i].Value = CFunctions.SetDBDatetime(info.Timeupdate);
parms[++i].Value = CFunctions.SetDBString(info.Username);
parms[++i].Value = info.Pis;
parms[++i].Value = info.Pid;
parms[++i].Value = info.Depth;
parms[++i].Value = CFunctions.install_keyword(info.Name) + " " + CFunctions.install_keyword(info.Note);
parms[++i].Value = info.Id;
return;
}
catch (Exception ex)
{
throw ex;
}
}
public bool Updatestr(string id, string column, object value)
{
try
{
if (CFunctions.IsNullOrEmpty(id)) return false;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = "UPDATE " + TABLENAME + " SET " + column + "=@PARM_VALUE WHERE id IN(" + id + ")";
iSqlParameter[] parms = new iSqlParameter[]{
new iSqlParameter("PARM_VALUE", iSqlType.Field_tString),
};
int i = -1;
parms[++i].Value = value.ToString();
HELPER.executeNonQuery(iConn, iCommandType.Text, SQL, parms);
iConn.Close();
}
return true;
}
catch (Exception ex)
{
throw ex;
}
}
public MemberInfo Wcmm_Getinfo(int id)
{
if (id == -1) return null;
try
{
MemberInfo info = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFO + " AND A.id=@ID";
iSqlParameter[] parms = new iSqlParameter[]{
new iSqlParameter(PARM_ID, iSqlType.Field_tInterger),
};
int i = -1;
parms[++i].Value = id;
using (iSqlDataReader dar = HELPER.executeReader(iConn, iCommandType.Text, SQL, parms))
{
if (dar.Read())
{
info = this.getDataReader(dar);
}
}
iConn.Close();
}
return info;
}
catch (Exception ex)
{
throw ex;
}
}
private void setParameter(iSqlParameter[] parms, MeCreditcardHistoryInfo info)
{
try
{
int i = -1;
parms[++i].Value = info.Memberid;
parms[++i].Value = info.Creditcardid;
parms[++i].Value = info.Balance;
parms[++i].Value = info.Amount;
parms[++i].Value = info.Addorsub;
parms[++i].Value = CFunctions.SetDBString(info.Note);
parms[++i].Value = info.Status;
parms[++i].Value = CFunctions.SetDBDatetime(info.Timeupdate);
parms[++i].Value = CFunctions.install_keyword(info.iMember.Username) + " " + CFunctions.install_keyword(info.iMember.Fullname);
parms[++i].Value = info.Id;
return;
}
catch (Exception ex)
{
throw ex;
}
}
public bool ChangePwd(MemberInfo info)
{
try
{
if (info == null) return false;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
iSqlParameter[] parms = new iSqlParameter[]{
new iSqlParameter(PARM_PASSWORD, iSqlType.Field_tString),
new iSqlParameter(PARM_ID, iSqlType.Field_tInterger)
};
parms[0].Value = info.Password;
parms[1].Value = info.Id;
HELPER.executeNonQuery(iConn, iCommandType.Text, SQL_CHANGE_PWD, parms);
iConn.Close();
}
return true;
}
catch (Exception ex)
{
throw ex;
}
}
private void setParameter(iSqlParameter[] parms, MeCreditcardInfo info)
{
try
{
int i = -1;
parms[++i].Value = CFunctions.SetDBString(info.Firstname);
parms[++i].Value = CFunctions.SetDBString(info.Lastname);
parms[++i].Value = CFunctions.SetDBString(info.Cardnumber);
parms[++i].Value = CFunctions.SetDBString(info.Cardtype);
parms[++i].Value = info.Expirationmonth;
parms[++i].Value = info.Expirationyear;
parms[++i].Value = CFunctions.SetDBString(info.Address);
parms[++i].Value = CFunctions.SetDBString(info.City);
parms[++i].Value = CFunctions.SetDBString(info.State);
parms[++i].Value = CFunctions.SetDBString(info.Zipcode);
parms[++i].Value = info.Memberid;
parms[++i].Value = info.Balance;
parms[++i].Value = info.Status;
parms[++i].Value = info.Id;
return;
}
catch (Exception ex)
{
throw ex;
}
}
public List<MeCreditcardHistoryInfo> Getlist(int memberid, ListOptions options, out int numResults)
{
try
{
List<MeCreditcardHistoryInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFOPAGING.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
SQL += " AND A.memberid=@MEMBERID";
SQL = "SELECT * FROM(" + SQL + ") AS T WHERE id<>0 " + CFunctions.Expression_GetLimit(options.PageIndex, options.PageSize);
iSqlParameter[] parms = new iSqlParameter[]{
new iSqlParameter(PARM_MEMBERID, iSqlType.Field_tInterger),
};
int i = -1;
parms[++i].Value = memberid;
using (iSqlDataReader dar = HELPER.executeReader(iConn, iCommandType.Text, SQL, parms))
{
while (dar.Read())
{
MeCreditcardHistoryInfo info = this.getDataReader(dar);
if (arr == null)
arr = new List<MeCreditcardHistoryInfo>();
arr.Add(info);
}
dar.Close();
}
numResults = this.Getlistcount(iConn, memberid);
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}
private void setParameter(iSqlParameter[] parms, FeedbackInfo info)
{
try
{
int i = -1;
parms[++i].Value = CFunctions.SetDBString(info.Name);
parms[++i].Value = CFunctions.SetDBString(info.Description);
parms[++i].Value = CFunctions.SetDBString(info.Sender_Name);
parms[++i].Value = CFunctions.SetDBString(info.Sender_Address);
parms[++i].Value = CFunctions.SetDBString(info.Sender_Email);
parms[++i].Value = CFunctions.SetDBString(info.Sender_Phone);
parms[++i].Value = info.Status;
parms[++i].Value = info.Markas;
parms[++i].Value = CFunctions.SetDBDatetime(info.Timeupdate);
parms[++i].Value = info.Pis;
parms[++i].Value = info.Pid;
parms[++i].Value = info.Depth;
parms[++i].Value = info.Viewcounter;
parms[++i].Value = CFunctions.install_keyword(info.Sender_Name) + " " + CFunctions.install_keyword(info.Name) + " " + CFunctions.install_keyword(info.Description);
parms[++i].Value = info.Id;
return;
}
catch (Exception ex)
{
throw ex;
}
}
private iSqlParameter[] getParameter(string query)
{
try
{
iSqlParameter[] parms = HELPER.getCachedParameters(query);
if (parms == null)
{
parms = new iSqlParameter[]{
new iSqlParameter(PARM_NAME, iSqlType.Field_tString),
new iSqlParameter(PARM_PATH, iSqlType.Field_tString),
new iSqlParameter(PARM_NOTE, iSqlType.Field_tString),
new iSqlParameter(PARM_SUBJECT, iSqlType.Field_tString),
new iSqlParameter(PARM_URL, iSqlType.Field_tString),
new iSqlParameter(PARM_SIZED, iSqlType.Field_tBigInt),
new iSqlParameter(PARM_TYPED, iSqlType.Field_tInterger),
new iSqlParameter(PARM_ORDERD, iSqlType.Field_tInterger),
new iSqlParameter(PARM_STATUS, iSqlType.Field_tInterger),
new iSqlParameter(PARM_MARKAS, iSqlType.Field_tInterger),
new iSqlParameter(PARM_ICONEX, iSqlType.Field_tString),
new iSqlParameter(PARM_TIMEUPDATE, iSqlType.Field_tDate),
new iSqlParameter(PARM_USERNAME, iSqlType.Field_tString),
new iSqlParameter(PARM_BELONGTO, iSqlType.Field_tInterger),
new iSqlParameter(PARM_IID, iSqlType.Field_tInterger),
new iSqlParameter(PARM_ID, iSqlType.Field_tInterger),
};
HELPER.cacheParameters(query, parms);
}
return parms;
}
catch (Exception ex)
{
throw ex;
}
}
private void setParameter(iSqlParameter[] parms, CommentInfo info)
{
try
{
int i = -1;
parms[++i].Value = CFunctions.SetDBString(info.Name);
parms[++i].Value = CFunctions.SetDBString(info.Introduce);
parms[++i].Value = CFunctions.SetDBString(info.Description);
parms[++i].Value = info.Orderd == 0 ? info.Id : info.Orderd;
parms[++i].Value = info.Status;
parms[++i].Value = info.Markas;
parms[++i].Value = CFunctions.SetDBString(info.Iconex);
parms[++i].Value = CFunctions.SetDBDatetime(info.Timecreate);
parms[++i].Value = CFunctions.SetDBDatetime(info.Timeupdate);
parms[++i].Value = CFunctions.SetDBString(info.Username);
parms[++i].Value = info.Iid;
parms[++i].Value = info.Belongto;
parms[++i].Value = info.Viewcounter;
parms[++i].Value = info.Rating;
parms[++i].Value = CFunctions.SetDBString(info.Sender_Name);
parms[++i].Value = CFunctions.SetDBString(info.Sender_Address);
parms[++i].Value = CFunctions.SetDBString(info.Sender_Email);
parms[++i].Value = CFunctions.SetDBString(info.Sender_Phone);
parms[++i].Value = CFunctions.install_keyword(info.Name) + " " + CFunctions.install_keyword(info.Introduce) + " " + CFunctions.install_keyword(info.Description) + " " + CFunctions.install_keyword(info.Sender_Name) + " " + CFunctions.install_keyword(info.Sender_Address) + " " + CFunctions.install_keyword(info.Sender_Email) + " " + CFunctions.install_keyword(info.Sender_Phone);
parms[++i].Value = info.Id;
return;
}
catch (Exception ex)
{
throw ex;
}
}
private iSqlParameter[] getParameter(string query)
{
try
{
iSqlParameter[] parms = HELPER.getCachedParameters(query);
if (parms == null)
{
parms = new iSqlParameter[]{
new iSqlParameter(PARM_NAME, iSqlType.Field_tString),
new iSqlParameter(PARM_DESCRIPTION, iSqlType.Field_tText),
new iSqlParameter(PARM_SENDER_NAME, iSqlType.Field_tString),
new iSqlParameter(PARM_SENDER_ADDRESS, iSqlType.Field_tString),
new iSqlParameter(PARM_SENDER_EMAIL, iSqlType.Field_tString),
new iSqlParameter(PARM_SENDER_PHONE, iSqlType.Field_tString),
new iSqlParameter(PARM_STATUS, iSqlType.Field_tInterger),
new iSqlParameter(PARM_MARKAS, iSqlType.Field_tInterger),
new iSqlParameter(PARM_TIMEUPDATE, iSqlType.Field_tDate),
new iSqlParameter(PARM_PIS, iSqlType.Field_tInterger),
new iSqlParameter(PARM_PID, iSqlType.Field_tInterger),
new iSqlParameter(PARM_DEPTH, iSqlType.Field_tInterger),
new iSqlParameter(PARM_VIEWCOUNTER, iSqlType.Field_tInterger),
new iSqlParameter(PARM_FORSEARCH, iSqlType.Field_tString),
new iSqlParameter(PARM_ID, iSqlType.Field_tInterger),
};
HELPER.cacheParameters(query, parms);
}
return parms;
}
catch (Exception ex)
{
throw ex;
}
}
public BannerInfo Getinfo(string code)
{
try
{
BannerInfo info = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFO + " AND A.code=@CODE";
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
iSqlParameter[] parms = new iSqlParameter[]{
new iSqlParameter(PARM_CODE, iSqlType.Field_tString),
};
int i = -1;
parms[++i].Value = code;
using (iSqlDataReader dar = HELPER.executeReader(iConn, iCommandType.Text, SQL, parms))
{
if (dar.Read())
{
info = this.getDataReader(dar);
}
}
iConn.Close();
}
return info;
}
catch (Exception ex)
{
throw ex;
}
}
public CommentInfo Getinforating(int belongto, int pid)
{
if (belongto == 0 || pid == 0) return null;
try
{
CommentInfo info = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = "SELECT COUNT(id), SUM(rating) FROM " + TABLENAME + " AS A WHERE id<>0";
SQL += " AND A.iid=@IID";
SQL += " AND A.belongto=@BELONGTO";
SQL += " AND A.status=" + (int)CConstants.State.Status.Actived;
iSqlParameter[] parms = new iSqlParameter[]{
new iSqlParameter(PARM_IID, iSqlType.Field_tInterger),
new iSqlParameter(PARM_BELONGTO, iSqlType.Field_tInterger),
};
int i = -1;
parms[++i].Value = pid;
parms[++i].Value = belongto;
using (iSqlDataReader dar = HELPER.executeReader(iConn, iCommandType.Text, SQL, parms))
{
if (dar.Read())
{
i = -1;
info = new CommentInfo();
info.Viewcounter = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Rating = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
}
dar.Close();
}
iConn.Close();
}
return info;
}
catch (Exception ex)
{
throw ex;
}
}
public bool Checkdupphone(int belongto, int pid, string phone)
{
try
{
bool vlreturn = false;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = "SELECT A.id FROM " + TABLENAME + " AS A WHERE A.id<>0"
+ " AND A.belongto=@BELONGTO AND A.iid=@IID AND A.sender_phone=@SENDER_PHONE";
iSqlParameter[] parms = new iSqlParameter[]{
new iSqlParameter(PARM_BELONGTO, iSqlType.Field_tInterger),
new iSqlParameter(PARM_IID, iSqlType.Field_tInterger),
new iSqlParameter(PARM_SENDER_PHONE, iSqlType.Field_tString),
};
int i = -1;
parms[++i].Value = belongto;
parms[++i].Value = pid;
parms[++i].Value = phone;
using (iSqlDataReader dar = HELPER.executeReader(iConn, iCommandType.Text, SQL, parms))
{
if (dar.Read())
{
vlreturn = true;
}
}
iConn.Close();
}
return vlreturn;
}
catch (Exception ex)
{
throw ex;
}
}
private void setParameter(iSqlParameter[] parms, LibrariesInfo info)
{
try
{
int i = -1;
parms[++i].Value = CFunctions.SetDBString(info.Code);
parms[++i].Value = CFunctions.SetDBString(info.Name);
parms[++i].Value = CFunctions.SetDBString(info.Introduce);
parms[++i].Value = CFunctions.SetDBString(info.Description);
parms[++i].Value = CFunctions.SetDBString(info.Filepreview);
parms[++i].Value = info.Cid;
parms[++i].Value = info.Orderd == 0 ? info.Id : info.Orderd;
parms[++i].Value = info.Status;
parms[++i].Value = info.Markas;
parms[++i].Value = CFunctions.SetDBString(info.Iconex);
parms[++i].Value = CFunctions.SetDBDatetime(info.Timecreate);
parms[++i].Value = CFunctions.SetDBDatetime(info.Timeupdate);
parms[++i].Value = CFunctions.SetDBString(info.Username);
parms[++i].Value = info.Allowcomment;
parms[++i].Value = info.Album;
parms[++i].Value = info.Viewcounter;
parms[++i].Value = CFunctions.SetDBString(info.Relateditem);
parms[++i].Value = CFunctions.install_keyword(info.Code) + " " + CFunctions.install_keyword(info.Name) + " " + CFunctions.install_keyword(info.Introduce) + " " + CFunctions.install_keyword(info.Description) + " " + CFunctions.install_keyword(info.Cname);
parms[++i].Value = info.Id;
return;
}
catch (Exception ex)
{
throw ex;
}
}
private void setParameter(iSqlParameter[] parms, FileattachInfo info)
{
try
{
int i = -1;
parms[++i].Value = CFunctions.SetDBString(info.Name);
parms[++i].Value = CFunctions.SetDBString(info.Path);
parms[++i].Value = CFunctions.SetDBString(info.Note);
parms[++i].Value = CFunctions.SetDBString(info.Subject);
parms[++i].Value = CFunctions.SetDBString(info.Url);
parms[++i].Value = info.Sized;
parms[++i].Value = info.Typed;
parms[++i].Value = info.Orderd == 0 ? info.Id : info.Orderd;
parms[++i].Value = info.Status;
parms[++i].Value = info.Markas;
parms[++i].Value = CFunctions.SetDBString(info.Iconex);
parms[++i].Value = CFunctions.SetDBDatetime(info.Timeupdate);
parms[++i].Value = CFunctions.SetDBString(info.Username);
parms[++i].Value = info.Belongto;
parms[++i].Value = info.Iid;
parms[++i].Value = info.Id;
return;
}
catch (Exception ex)
{
throw ex;
}
}
private iSqlParameter[] getParameter(string query)
{
try
{
iSqlParameter[] parms = HELPER.getCachedParameters(query);
if (parms == null)
{
parms = new iSqlParameter[]{
new iSqlParameter(PARM_FIRSTNAME, iSqlType.Field_tString),
new iSqlParameter(PARM_LASTNAME, iSqlType.Field_tString),
new iSqlParameter(PARM_CARDNUMBER, iSqlType.Field_tString),
new iSqlParameter(PARM_CARDTYPE, iSqlType.Field_tString),
new iSqlParameter(PARM_EXPIRATIONMONTH, iSqlType.Field_tInterger),
new iSqlParameter(PARM_EXPIRATIONYEAR, iSqlType.Field_tInterger),
new iSqlParameter(PARM_ADDRESS, iSqlType.Field_tString),
new iSqlParameter(PARM_CITY, iSqlType.Field_tString),
new iSqlParameter(PARM_STATE, iSqlType.Field_tString),
new iSqlParameter(PARM_ZIPCODE, iSqlType.Field_tString),
new iSqlParameter(PARM_MEMBERID, iSqlType.Field_tInterger),
new iSqlParameter(PARM_BALANCE, iSqlType.Field_tReal),
new iSqlParameter(PARM_STATUS, iSqlType.Field_tInterger),
new iSqlParameter(PARM_ID, iSqlType.Field_tInterger),
};
HELPER.cacheParameters(query, parms);
}
return parms;
}
catch (Exception ex)
{
throw ex;
}
}
private iSqlParameter[] getParameter(string query)
{
try
{
iSqlParameter[] parms = HELPER.getCachedParameters(query);
if (parms == null)
{
parms = new iSqlParameter[]{
new iSqlParameter(PARM_NAME, iSqlType.Field_tString),
new iSqlParameter(PARM_CODE, iSqlType.Field_tString),
new iSqlParameter(PARM_ALBUM, iSqlType.Field_tInterger),
new iSqlParameter(PARM_STATUS, iSqlType.Field_tInterger),
new iSqlParameter(PARM_TIMEUPDATE, iSqlType.Field_tDate),
new iSqlParameter(PARM_USERNAME, iSqlType.Field_tString),
new iSqlParameter(PARM_FORSEARCH, iSqlType.Field_tString),
new iSqlParameter(PARM_ID, iSqlType.Field_tInterger),
};
HELPER.cacheParameters(query, parms);
}
return parms;
}
catch (Exception ex)
{
throw ex;
}
}
public MeCreditcardHistoryInfo Getinfolastest(int memberid)
{
if (memberid == 0) return null;
try
{
MeCreditcardHistoryInfo info = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFOPAGING.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort("id", "DESC"));
SQL += " AND A.memberid=@MEMBERID";
SQL = "SELECT TOP 1 * FROM(" + SQL + ") AS T WHERE id<>0";
iSqlParameter[] parms = new iSqlParameter[]{
new iSqlParameter(PARM_MEMBERID, iSqlType.Field_tInterger),
};
int i = -1;
parms[++i].Value = memberid;
using (iSqlDataReader dar = HELPER.executeReader(iConn, iCommandType.Text, SQL, parms))
{
if (dar.Read())
{
info = this.getDataReader(dar);
}
dar.Close();
}
iConn.Close();
}
return info;
}
catch (Exception ex)
{
throw ex;
}
}
private iSqlParameter[] getParameter(string query)
{
try
{
iSqlParameter[] parms = HELPER.getCachedParameters(query);
if (parms == null)
{
parms = new iSqlParameter[]{
new iSqlParameter(PARM_IID, iSqlType.Field_tInterger),
new iSqlParameter(PARM_CATEGORYID, iSqlType.Field_tInterger),
new iSqlParameter(PARM_BELONGTO, iSqlType.Field_tInterger),
};
HELPER.cacheParameters(query, parms);
}
return parms;
}
catch (Exception ex)
{
throw ex;
}
}
private iSqlParameter[] getParameter(string query)
{
try
{
iSqlParameter[] parms = HELPER.getCachedParameters(query);
if (parms == null)
{
parms = new iSqlParameter[]{
new iSqlParameter(PARM_MEMBERID, iSqlType.Field_tInterger),
new iSqlParameter(PARM_CREDITCARDID, iSqlType.Field_tInterger),
new iSqlParameter(PARM_BALANCE, iSqlType.Field_tReal),
new iSqlParameter(PARM_AMOUNT, iSqlType.Field_tReal),
new iSqlParameter(PARM_ADDORSUB, iSqlType.Field_tInterger),
new iSqlParameter(PARM_NOTE, iSqlType.Field_tString),
new iSqlParameter(PARM_STATUS, iSqlType.Field_tInterger),
new iSqlParameter(PARM_TIMEUPDATE, iSqlType.Field_tDate),
new iSqlParameter(PARM_FORSEARCH, iSqlType.Field_tString),
new iSqlParameter(PARM_ID, iSqlType.Field_tInterger),
};
HELPER.cacheParameters(query, parms);
}
return parms;
}
catch (Exception ex)
{
throw ex;
}
}
private void setParameter(iSqlParameter[] parms, ItemcategoryattrInfo info)
{
try
{
int i = -1;
parms[++i].Value = info.Iid;
parms[++i].Value = info.Categoryid;
parms[++i].Value = info.Belongto;
return;
}
catch (Exception ex)
{
throw ex;
}
}
public List<CartInfo> GetinfofullCheckout(int memberid, ListOptions options)
{
if (memberid == 0) return null;
try
{
List<CartInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFOPAGING.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
SQL += " AND A.memberid=@MEMBERID";
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
SQL += " AND A.checkout=1";
iSqlParameter[] parms = new iSqlParameter[]{
new iSqlParameter(PARM_MEMBERID, iSqlType.Field_tInterger),
};
int i = -1;
parms[++i].Value = memberid;
using (iSqlDataReader dar = HELPER.executeReader(iConn, iCommandType.Text, SQL, parms))
{
while (dar.Read())
{
CartInfo info = this.getDataReader(dar);
info.lCartitem = (new CCartitem(LANG)).Getlistfull(info.Id);
if (arr == null)
arr = new List<CartInfo>();
arr.Add(info);
}
}
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}
public LibrariesInfo Getinfo(int id)
{
if (id == -1) return null;
try
{
LibrariesInfo info = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFO + " AND A.id=@ID";
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
iSqlParameter[] parms = new iSqlParameter[]{
new iSqlParameter(PARM_ID, iSqlType.Field_tInterger),
};
int i = -1;
parms[++i].Value = id;
using (iSqlDataReader dar = HELPER.executeReader(iConn, iCommandType.Text, SQL, parms))
{
if (dar.Read())
{
info = this.getDataReader(dar);
}
dar.Close();
}
iConn.Close();
}
return info;
}
catch (Exception ex)
{
throw ex;
}
}
public MemberInfo Login(MemberInfo info)
{
try
{
MemberInfo _info = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFO;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
SQL += " AND (A.username=@USERNAME) AND (A.password=@PASSWORD)";
iSqlParameter[] parms = new iSqlParameter[]{
new iSqlParameter(PARM_USERNAME, iSqlType.Field_tString),
new iSqlParameter(PARM_PASSWORD, iSqlType.Field_tString)
};
parms[0].Value = info.Username;
parms[1].Value = info.Password;
using (iSqlDataReader dar = HELPER.executeReader(iConn, iCommandType.Text, SQL, parms))
{
if (dar.Read())
{
_info = this.getDataReader(dar);
}
}
iConn.Close();
}
return _info;
}
catch (Exception ex)
{
throw ex;
}
}
private void setParameter(iSqlParameter[] parms, BannerInfo info)
{
try
{
int i = -1;
parms[++i].Value = CFunctions.SetDBString(info.Name);
parms[++i].Value = CFunctions.SetDBString(info.Code);
parms[++i].Value = info.Album;
parms[++i].Value = info.Status;
parms[++i].Value = CFunctions.SetDBDatetime(info.Timeupdate);
parms[++i].Value = CFunctions.SetDBString(info.Username);
parms[++i].Value = CFunctions.install_keyword(info.Name) + " " + CFunctions.install_keyword(info.Code);
parms[++i].Value = info.Id;
return;
}
catch (Exception ex)
{
throw ex;
}
}
public CartInfo GetinfofullNotcheckout(int memberid)
{
if (memberid == 0) return null;
try
{
CartInfo info = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFO + " AND A.memberid=@MEMBERID";
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
SQL += " AND A.checkout=0";
iSqlParameter[] parms = new iSqlParameter[]{
new iSqlParameter(PARM_MEMBERID, iSqlType.Field_tInterger),
};
int i = -1;
parms[++i].Value = memberid;
using (iSqlDataReader dar = HELPER.executeReader(iConn, iCommandType.Text, SQL, parms))
{
if (dar.Read())
{
info = this.getDataReader(dar);
info.lCartitem = (new CCartitem(LANG)).Getlistfull(info.Id);
}
}
iConn.Close();
}
return info;
}
catch (Exception ex)
{
throw ex;
}
}
private iSqlParameter[] getParameter(string query)
{
try
{
iSqlParameter[] parms = HELPER.getCachedParameters(query);
if (parms == null)
{
parms = new iSqlParameter[]{
new iSqlParameter(PARM_CODE, iSqlType.Field_tString),
new iSqlParameter(PARM_NAME, iSqlType.Field_tString),
new iSqlParameter(PARM_INTRODUCE, iSqlType.Field_tString),
new iSqlParameter(PARM_DESCRIPTION, iSqlType.Field_tText),
new iSqlParameter(PARM_FILEPREVIEW, iSqlType.Field_tString),
new iSqlParameter(PARM_CID, iSqlType.Field_tInterger),
new iSqlParameter(PARM_ORDERD, iSqlType.Field_tInterger),
new iSqlParameter(PARM_STATUS, iSqlType.Field_tInterger),
new iSqlParameter(PARM_MARKAS, iSqlType.Field_tInterger),
new iSqlParameter(PARM_ICONEX, iSqlType.Field_tString),
new iSqlParameter(PARM_TIMECREATE, iSqlType.Field_tDate),
new iSqlParameter(PARM_TIMEUPDATE, iSqlType.Field_tDate),
new iSqlParameter(PARM_USERNAME, iSqlType.Field_tString),
new iSqlParameter(PARM_ALLOWCOMMENT, iSqlType.Field_tInterger),
new iSqlParameter(PARM_ALBUM, iSqlType.Field_tInterger),
new iSqlParameter(PARM_VIEWCOUNTER, iSqlType.Field_tInterger),
new iSqlParameter(PARM_RELATEDITEM, iSqlType.Field_tString),
new iSqlParameter(PARM_FORSEARCH, iSqlType.Field_tString),
new iSqlParameter(PARM_ID, iSqlType.Field_tInterger),
};
HELPER.cacheParameters(query, parms);
}
return parms;
}
catch (Exception ex)
{
throw ex;
}
}
public MemberInfo Wcmm_Getinfo(string username)
{
if (CFunctions.IsNullOrEmpty(username)) return null;
try
{
MemberInfo info = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFO + " AND A.username=@USERNAME";
iSqlParameter[] parms = new iSqlParameter[]{
new iSqlParameter(PARM_USERNAME, iSqlType.Field_tString),
};
int i = -1;
parms[++i].Value = username;
using (iSqlDataReader dar = HELPER.executeReader(iConn, iCommandType.Text, SQL, parms))
{
if (dar.Read())
{
info = this.getDataReader(dar);
}
}
iConn.Close();
}
return info;
}
catch (Exception ex)
{
throw ex;
}
}
private iSqlParameter[] getParameter(string query)
{
try
{
iSqlParameter[] parms = HELPER.getCachedParameters(query);
if (parms == null)
{
parms = new iSqlParameter[]{
new iSqlParameter(PARM_CODE, iSqlType.Field_tString),
new iSqlParameter(PARM_NAME, iSqlType.Field_tString),
new iSqlParameter(PARM_NOTE, iSqlType.Field_tString),
new iSqlParameter(PARM_URL, iSqlType.Field_tString),
new iSqlParameter(PARM_FILEPREVIEW, iSqlType.Field_tString),
new iSqlParameter(PARM_CID, iSqlType.Field_tInterger),
new iSqlParameter(PARM_ORDERD, iSqlType.Field_tInterger),
new iSqlParameter(PARM_STATUS, iSqlType.Field_tInterger),
new iSqlParameter(PARM_MARKAS, iSqlType.Field_tInterger),
new iSqlParameter(PARM_ICONEX, iSqlType.Field_tString),
new iSqlParameter(PARM_TIMEUPDATE, iSqlType.Field_tDate),
new iSqlParameter(PARM_USERNAME, iSqlType.Field_tString),
new iSqlParameter(PARM_PIS, iSqlType.Field_tInterger),
new iSqlParameter(PARM_PID, iSqlType.Field_tInterger),
new iSqlParameter(PARM_DEPTH, iSqlType.Field_tInterger),
new iSqlParameter(PARM_FORSEARCH, iSqlType.Field_tString),
new iSqlParameter(PARM_ID, iSqlType.Field_tInterger),
};
HELPER.cacheParameters(query, parms);
}
return parms;
}
catch (Exception ex)
{
throw ex;
}
}
