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 CommentInfo getDataReader(iSqlDataReader dar)
{
try
{
int i = -1;
CommentInfo info = new CommentInfo();
info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Introduce = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Description = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Orderd = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i);
info.Markas = dar.IsDBNull(++i) ? (int)CConstants.State.MarkAs.None : dar.GetInt32(i);
info.Iconex = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Timecreate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i);
info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i);
info.Username = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Iid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Belongto = dar.IsDBNull(++i) ? 1 : dar.GetInt32(i);
info.Viewcounter = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Rating = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Sender_Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Sender_Address = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Sender_Email = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Sender_Phone = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i);
return info;
}
catch (Exception ex)
{
throw ex;
}
}
private bool Saveitem(iSqlTransaction trans, CommentInfo info)
{
try
{
if (trans == null || info == null) return false;
string SQL = string.Empty;
if (info.Id == 0)
{
SQL = SQL_INSERT;
info.Id = (int)HELPER.getNewID(trans, TABLENAME);
iSqlParameter[] parms = this.getParameter(SQL);
this.setParameter(parms, info);
HELPER.executeNonQuery(trans, iCommandType.Text, SQL, parms);
}
else if (HELPER.isExist(trans, TABLENAME, info.Id))
{
SQL = SQL_UPDATE;
iSqlParameter[] parms = this.getParameter(SQL);
this.setParameter(parms, info);
HELPER.executeNonQuery(trans, iCommandType.Text, SQL, parms);
}
else
{
SQL = SQL_INSERT;
info.Id = (int)HELPER.getNewID(trans, TABLENAME);
iSqlParameter[] parms = this.getParameter(SQL);
this.setParameter(parms, info);
HELPER.executeNonQuery(trans, iCommandType.Text, SQL, parms);
}
return true;
}
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 Save(CommentInfo info)
{
try
{
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
using (iSqlTransaction trans = iConn.BeginTransaction())
{
try
{
this.Saveitem(trans, info);
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
}
iConn.Close();
}
return true;
}
catch (Exception ex)
{
throw ex;
}
}
private CommentInfo Take()
{
try
{
CommentInfo info = new CommentInfo();
info.Iid = Pid;
info.Belongto = Belongto;
info.Name = txtName.Text.Trim();
info.Description = txtDescription.Text.Trim();
info.Rating = int.Parse(radRating.SelectedValue);
info.Sender_Name = CFunctions.IsNullOrEmpty(txtSender_Name.Text) ? "Guest" : txtSender_Name.Text.Trim();
info.Sender_Email = txtSender_Email.Text.Trim();
info.Sender_Phone = txtSender_Phone.Text.Trim();
info.Status = (int)CConstants.State.Status.Waitactive;
info.Username = "******";
info.Timeupdate = DateTime.Now;
return info;
}
catch
{
return null;
}
}
private CommentInfo Take()
{
try
{
int iid = 0;
int.TryParse(txtId.Value, out iid);
CommentInfo info = (new CComment(CCommon.LANG)).Wcmm_Getinfo(iid);
if (info == null)
info = new CommentInfo();
info.Id = iid;
info.Name = txtName.Text.Trim();
info.Introduce = txtIntroduce.Text.Trim();
info.Description = txtDescription.Text.Trim();
if (info.Id == 0)
{
info.Belongto = this.BELONGTO;
int pid = 0;
int.TryParse(ddlName.SelectedValue, out pid);
info.Iid = pid;
}
info.Sender_Name = txtSender_Name.Text.Trim();
info.Sender_Email = txtSender_Email.Text.Trim();
info.Sender_Address = txtSender_Address.Text.Trim();
info.Sender_Phone = txtSender_Phone.Text.Trim();
info.Iconex = Displaysetting.Get_Icon();
info.Status = Displaysetting.Get_Status();
info.Markas = Displaysetting.Get_Markas();
info.Orderd = Displaysetting.Get_Orderd();
info.Username = CCommon.Get_CurrentUsername();
if (info.Id == 0)
info.Timecreate = DateTime.Now;
info.Timeupdate = DateTime.Now;
return info;
}
catch
{
return null;
}
}
private bool Save_Lang(CommentInfo info)
{
try
{
if (!CFunctions.IsMultiLanguage() || !chkSaveoption_golang.Checked) return false;
int lang_num = CConstants.LANG_NUM;
for (int i = 0; i < lang_num; i++)
{
string lang_val = ConfigurationSettings.AppSettings["LANG_" + i];
if (lang_val == CCommon.LANG) continue;
CommentInfo lang_info = info.copy();
lang_info.Id = 0;
lang_info.Status = (int)CConstants.State.Status.Waitactive;
(new CComment(lang_val)).Save(lang_info);
}
return true;
}
catch
{
return false;
}
}
private bool Save(CommentInfo info)
{
try
{
if (info == null) return false;
int id = info.Id;
if ((new CComment(CCommon.LANG)).Save(info))
{
if (id == 0)
(new CGeneral(CCommon.LANG, info.Belongto)).Updatenum(info.Iid.ToString(), Queryparam.Sqlcolumn.Allowcomment, CConstants.NUM_INCREASE);
}
return true;
}
catch
{
return false;
}
}
private bool Load_Info(int iid)
{
try
{
CommentInfo info = (new CComment(CCommon.LANG)).Wcmm_Getinfo(iid);
if (info == null || info.Id == 0)
{
info = new CommentInfo();
}
else
{
lstError = new List<Errorobject>();
lstError = Form_GetError(lstError, Errortype.Notice, Definephrase.Save_notice, "[" + info.Id + "] " + info.Name, null);
Master.Form_ShowError(lstError);
}
chkSaveoption_golist.Checked = info.Id != 0;
chkSaveoption_golang.Checked = info.Id == 0;
txtId.Value = info.Id.ToString();
txtName.Text = info.Name;
txtIntroduce.Text = info.Introduce;
txtDescription.Text = info.Description;
txtSender_Name.Text = info.Sender_Name;
txtSender_Email.Text = info.Sender_Email;
txtSender_Address.Text = info.Sender_Address;
txtSender_Phone.Text = info.Sender_Phone;
Displaysetting.Set(info.Iconex, info.Status, info.Orderd, info.Markas);
if (info.Id != 0)
{
ddlCid.SelectedValue = this.CID.ToString();
this.ddlCid_SelectedIndexChanged(null, null);
ddlName.SelectedValue = info.Iid.ToString();
}
//ddlName.Enabled = info.Id == 0;
return true;
}
catch
{
return false;
}
}
