private void InitPage() { try { string newsid = CConvert.ToString(Request["id"]); DBB100 db = new DBB100(); if (FC_Check.IsNotEmpty(newsid))//修改 { hidNewsId.Value = newsid; DataSet dst = db.GetTrainInfoById(newsid); if (dst != null && dst.Tables.Count > 0 && dst.Tables[0].Rows.Count > 0) { DataRow dr = dst.Tables[0].Rows[0]; string category = CConvert.ToString(dr["speed"]); this.txtTitle.Text = CConvert.ToString(dr["title"]); this.txtWordsCnt.Text = CConvert.ToString(dr["words"]); newDesc.Value = CConvert.ToString(dr["content"]); imgPhoto.ImageUrl = "../upload/test/" + CConvert.ToString(dr["photo"]); ddlSpeadBind(category); } } else { ddlSpeadBind(""); } } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取指点ID的news文章 /// </summary> /// <param name="newsid"></param> /// <returns></returns> internal DataSet GetViewInfoById(string sId) { DataSet dst = null; StringBuilder sb = new StringBuilder(); m_dbo.RemoveAllParameters(); sb.Append(" select * "); sb.Append(" from td_view_training "); sb.Append(" WHERE 1 = 1 "); if (FC_Check.IsNotEmpty(sId)) { sb.Append(" AND viewtrain_id = ?id "); m_dbo.AddParameter("id", sId); } try { dst = this.m_dbo.Select(CConvert.ToString(sb)); } catch (Exception e) { throw e; } finally { try { this.m_dbo.Close(); } catch { } } return(dst); }
internal DataSet GetCode(string category) { DataSet dst = null; StringBuilder sb = new StringBuilder(); m_dbo.RemoveAllParameters(); sb.Append(" select category ,categoryname "); sb.Append(" from td_code "); sb.Append(" WHERE 1 = 1 "); if (FC_Check.IsNotEmpty(category)) { sb.Append(" AND category = ?category "); m_dbo.AddParameter("category", category); } sb.Append(" order by id "); try { dst = this.m_dbo.Select(CConvert.ToString(sb)); } catch (Exception e) { throw e; } finally { try { this.m_dbo.Close(); } catch { } } return(dst); }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { try { //输入校验 if (!Check()) { return; } string sTitle = txtTitle.Text; string sPeed = ddlSpead.SelectedValue; string sContent = newDesc.Value; string sWords = txtWordsCnt.Text; string sPhoto = ""; if (sWords == "") { sWords = sContent.Length.ToString(); } if (fileImg.HasFile) { string[] arrFile = fileImg.FileName.Split('.'); sPhoto = DateTime.Now.ToString("yyyyMMddHHmmssfff") + "." + arrFile[arrFile.Length - 1]; string sPath = AppConfig.ImagePath + "test/"; if (Directory.Exists(sPath) == false) { Directory.CreateDirectory(sPath); } fileImg.SaveAs(sPath + sPhoto); ReSizeImageFile(sPath + sPhoto, 300, 400); } string sId = hidNewsId.Value; DBB100 db = new DBB100(); int iRet = 0; if (FC_Check.IsNotEmpty(sId))//修改 { iRet = db.Update(sId, sTitle, sPeed, sPhoto, sContent, sWords); } else//新建 { iRet = db.Insert(m_trainType, sTitle, sPeed, sPhoto, sContent, sWords); } if (iRet > 0) { Response.Redirect("B200.aspx"); } else { } } catch (Exception ex) { throw ex; } }