private bool Saveitem(iSqlTransaction trans, RSSResourceInfo 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;
}
}
private void setParameter(iSqlParameter[] parms, RSSResourceInfo info)
{
try
{
int i = -1;
parms[++i].Value = info.Code;
parms[++i].Value = info.Name;
parms[++i].Value = info.WebsiteUrl;
parms[++i].Value = info.RSSUrl;
if (info.Timelastestget.Equals(new DateTime(0)))
parms[++i].Value = DBNull.Value;
else
parms[++i].Value = info.Timelastestget;
parms[++i].Value = info.Nodecontent;
parms[++i].Value = info.Nodetitle;
parms[++i].Value = info.Nodeintroduce;
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;
if (info.Timeupdate.Equals(new DateTime(0)))
parms[++i].Value = DBNull.Value;
else
parms[++i].Value = info.Timeupdate;
parms[++i].Value = info.Username;
parms[++i].Value = CFunctions.install_keyword(info.Code) + " " + CFunctions.install_keyword(info.Name) + " " + CFunctions.install_keyword(info.Cname);
parms[++i].Value = info.Id;
return;
}
catch (Exception ex)
{
throw ex;
}
}
public bool Save(RSSResourceInfo 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 RSSResourceInfo getDataReader(iSqlDataReader dar)
{
try
{
int i = -1;
RSSResourceInfo info = new RSSResourceInfo();
info.Code = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.WebsiteUrl = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.RSSUrl = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Timelastestget = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i);
info.Nodecontent = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Nodetitle = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Nodeintroduce = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Cid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Cname = 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.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i);
info.Username = 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 void Bind_RSSInfo(RSSResourceInfo info)
{
if (info == null)
info = new RSSResourceInfo();
List<RSSResourceInfo> list = new List<RSSResourceInfo>();
list.Add(info);
rptList.DataSource = list;
rptList.DataBind();
if (ddlCid.Items.Count > 0)
{
if (ddlCid.Items.FindByValue(info.Cid.ToString()) != null)
ddlCid.SelectedValue = info.Cid.ToString();
}
}
private bool Load_Info(int iid)
{
try
{
RSSResourceInfo info = (new CRSSResource(CCommon.LANG)).Wcmm_Getinfo(iid);
if (info == null || info.Id == 0)
info = new RSSResourceInfo();
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;
txtWebsiteUrl.Text = info.WebsiteUrl;
txtRSSUrl.Text = info.RSSUrl;
ddlCid.SelectedValue = info.Cid.ToString();
lblTimelastestget.Text = CFunctions.IsNullOrEmpty(info.eTimelastestget) ? "n/a" : info.eTimelastestget;
txtNodecontent.Text = info.Nodecontent;
txtNodetitle.Text = info.Nodetitle;
txtNodeintroduce.Text = info.Nodeintroduce;
return true;
}
catch
{
return false;
}
}
private RSSResourceInfo Take()
{
try
{
int iid = 0;
int.TryParse(txtId.Value, out iid);
RSSResourceInfo info = (new CRSSResource(CCommon.LANG)).Wcmm_Getinfo(iid);
if (info == null)
info = new RSSResourceInfo();
info.Id = iid;
info.Name = txtName.Text.Trim();
info.Code = "";
info.WebsiteUrl = txtWebsiteUrl.Text.Trim();
info.RSSUrl = txtRSSUrl.Text.Trim();
info.Cid = int.Parse(ddlCid.SelectedValue);
info.Cname = ddlCid.SelectedItem.Text.Replace("-", "");
info.Nodecontent = txtNodecontent.Text;
info.Nodetitle = txtNodetitle.Text;
info.Nodeintroduce = txtNodeintroduce.Text;
info.Timeupdate = DateTime.Now;
return info;
}
catch
{
return null;
}
}
private bool Save_Lang(RSSResourceInfo 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;
RSSResourceInfo lang_info = info.copy();
lang_info.Id = 0;
lang_info.Status = (int)CConstants.State.Status.Waitactive;
(new CRSSResource(lang_val)).Save(lang_info);
}
return true;
}
catch
{
return false;
}
}
private bool Save(RSSResourceInfo info)
{
try
{
if (info == null) return false;
return (new CRSSResource(CCommon.LANG)).Save(info);
}
catch
{
return false;
}
}
