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