/// <summary> /// 更新一条数据 /// </summary> public bool Update(LearnSite.Model.Survey model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Survey set "); strSql.Append("Vcid=@Vcid,"); strSql.Append("Vhid=@Vhid,"); strSql.Append("Vtitle=@Vtitle,"); strSql.Append("Vcontent=@Vcontent,"); strSql.Append("Vtype=@Vtype,"); strSql.Append("Vtotal=@Vtotal,"); strSql.Append("Vscore=@Vscore,"); strSql.Append("Vaverage=@Vaverage,"); strSql.Append("Vclose=@Vclose,"); strSql.Append("Vpoint=@Vpoint,"); strSql.Append("Vdate=@Vdate"); strSql.Append(" where Vid=@Vid"); SqlParameter[] parameters = { new SqlParameter("@Vcid", SqlDbType.Int, 4), new SqlParameter("@Vhid", SqlDbType.Int, 4), new SqlParameter("@Vtitle", SqlDbType.NVarChar, 50), new SqlParameter("@Vcontent", SqlDbType.NText), new SqlParameter("@Vtype", SqlDbType.Int, 4), new SqlParameter("@Vtotal", SqlDbType.Int, 4), new SqlParameter("@Vscore", SqlDbType.Int, 4), new SqlParameter("@Vaverage", SqlDbType.Int, 4), new SqlParameter("@Vclose", SqlDbType.Bit, 1), new SqlParameter("@Vpoint", SqlDbType.Bit, 1), new SqlParameter("@Vdate", SqlDbType.DateTime), new SqlParameter("@Vid", SqlDbType.Int, 4) }; parameters[0].Value = model.Vcid; parameters[1].Value = model.Vhid; parameters[2].Value = model.Vtitle; parameters[3].Value = model.Vcontent; parameters[4].Value = model.Vtype; parameters[5].Value = model.Vtotal; parameters[6].Value = model.Vscore; parameters[7].Value = model.Vaverage; parameters[8].Value = model.Vclose; parameters[9].Value = model.Vpoint; parameters[10].Value = model.Vdate; parameters[11].Value = model.Vid; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(LearnSite.Model.Survey model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Survey("); strSql.Append("Vcid,Vhid,Vtitle,Vcontent,Vtype,Vtotal,Vscore,Vclose,Vpoint,Vdate)"); strSql.Append(" values ("); strSql.Append("@Vcid,@Vhid,@Vtitle,@Vcontent,@Vtype,@Vtotal,@Vscore,@Vclose,@Vpoint,@Vdate)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Vcid", SqlDbType.Int, 4), new SqlParameter("@Vhid", SqlDbType.Int, 4), new SqlParameter("@Vtitle", SqlDbType.NVarChar, 50), new SqlParameter("@Vcontent", SqlDbType.NText), new SqlParameter("@Vtype", SqlDbType.Int, 4), new SqlParameter("@Vtotal", SqlDbType.Int, 4), new SqlParameter("@Vscore", SqlDbType.Int, 4), new SqlParameter("@Vclose", SqlDbType.Bit, 1), new SqlParameter("@Vpoint", SqlDbType.Bit, 1), new SqlParameter("@Vdate", SqlDbType.DateTime) }; parameters[0].Value = model.Vcid; parameters[1].Value = model.Vhid; parameters[2].Value = model.Vtitle; parameters[3].Value = model.Vcontent; parameters[4].Value = model.Vtype; parameters[5].Value = model.Vtotal; parameters[6].Value = model.Vscore; parameters[7].Value = model.Vclose; parameters[8].Value = model.Vpoint; parameters[9].Value = model.Vdate; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 添加学案调查ok /// </summary> /// <param name="dt"></param> /// <param name="Cid"></param> private static void CreateSurvey(DataTable dt, DataTable dtquestion, DataTable dtitem, int Cid, int Hid) { int dCount = dt.Rows.Count; LearnSite.BLL.Survey bll = new LearnSite.BLL.Survey(); for (int i = 0; i < dCount; i++) { LearnSite.Model.Survey model = new LearnSite.Model.Survey(); model = bll.GetModel(dt, i); int oldMcid = model.Vcid.Value; string thisMcontent = model.Vcontent; model.Vcid = Cid; //更换成新学案编号 model.Vhid = Hid; //换成导入老师 string oldstr = "Store/" + oldMcid.ToString(); string newstr = "Store/" + Cid.ToString(); model.Vcontent = thisMcontent.Replace(oldstr, newstr); //替换链接地址 int oldvid = model.Vid; int newvid = bll.Add(model); //增加学案调查 if (dtquestion != null) { CreateSurveyQuestion(dtquestion, dtitem, Cid, oldvid, newvid); } } }
/// <summary> /// 得到一个对象实体 /// </summary> public LearnSite.Model.Survey GetModel(DataTable dt, int Tsort) { LearnSite.Model.Survey model = new LearnSite.Model.Survey(); int Count = dt.Rows.Count; if (Count > 0) { if (Tsort < Count) { if (dt.Rows[Tsort]["Vid"] != null && dt.Rows[Tsort]["Vid"].ToString() != "") { model.Vid = int.Parse(dt.Rows[Tsort]["Vid"].ToString()); } if (dt.Rows[Tsort]["Vcid"] != null && dt.Rows[Tsort]["Vcid"].ToString() != "") { model.Vcid = int.Parse(dt.Rows[Tsort]["Vcid"].ToString()); } if (dt.Rows[Tsort]["Vhid"] != null && dt.Rows[Tsort]["Vhid"].ToString() != "") { model.Vhid = int.Parse(dt.Rows[Tsort]["Vhid"].ToString()); } if (dt.Rows[Tsort]["Vtitle"] != null && dt.Rows[Tsort]["Vtitle"].ToString() != "") { model.Vtitle = dt.Rows[Tsort]["Vtitle"].ToString(); } if (dt.Rows[Tsort]["Vcontent"] != null && dt.Rows[Tsort]["Vcontent"].ToString() != "") { model.Vcontent = dt.Rows[Tsort]["Vcontent"].ToString(); } if (dt.Rows[Tsort]["Vtype"] != null && dt.Rows[Tsort]["Vtype"].ToString() != "") { model.Vtype = int.Parse(dt.Rows[Tsort]["Vtype"].ToString()); } if (dt.Rows[Tsort]["Vtotal"] != null && dt.Rows[Tsort]["Vtotal"].ToString() != "") { model.Vtotal = int.Parse(dt.Rows[Tsort]["Vtotal"].ToString()); } if (dt.Rows[Tsort]["Vscore"] != null && dt.Rows[Tsort]["Vscore"].ToString() != "") { model.Vscore = int.Parse(dt.Rows[Tsort]["Vscore"].ToString()); } if (dt.Rows[Tsort]["Vaverage"] != null && dt.Rows[Tsort]["Vaverage"].ToString() != "") { model.Vaverage = int.Parse(dt.Rows[Tsort]["Vaverage"].ToString()); } if (dt.Rows[Tsort]["Vclose"] != null && dt.Rows[Tsort]["Vclose"].ToString() != "") { if ((dt.Rows[Tsort]["Vclose"].ToString() == "1") || (dt.Rows[Tsort]["Vclose"].ToString().ToLower() == "true")) { model.Vclose = true; } else { model.Vclose = false; } } if (dt.Rows[Tsort]["Vpoint"] != null && dt.Rows[Tsort]["Vpoint"].ToString() != "") { if ((dt.Rows[Tsort]["Vpoint"].ToString() == "1") || (dt.Rows[Tsort]["Vpoint"].ToString().ToLower() == "true")) { model.Vpoint = true; } else { model.Vpoint = false; } } if (dt.Rows[Tsort]["Vdate"] != null && dt.Rows[Tsort]["Vdate"].ToString() != "") { model.Vdate = DateTime.Parse(dt.Rows[Tsort]["Vdate"].ToString()); } return(model); } else { return(null); } } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public LearnSite.Model.Survey GetModel(int Vid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Vid,Vcid,Vhid,Vtitle,Vcontent,Vtype,Vtotal,Vscore,Vaverage,Vclose,Vpoint,Vdate from Survey "); strSql.Append(" where Vid=@Vid"); SqlParameter[] parameters = { new SqlParameter("@Vid", SqlDbType.Int, 4) }; parameters[0].Value = Vid; LearnSite.Model.Survey model = new LearnSite.Model.Survey(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Vid"] != null && ds.Tables[0].Rows[0]["Vid"].ToString() != "") { model.Vid = int.Parse(ds.Tables[0].Rows[0]["Vid"].ToString()); } if (ds.Tables[0].Rows[0]["Vcid"] != null && ds.Tables[0].Rows[0]["Vcid"].ToString() != "") { model.Vcid = int.Parse(ds.Tables[0].Rows[0]["Vcid"].ToString()); } if (ds.Tables[0].Rows[0]["Vhid"] != null && ds.Tables[0].Rows[0]["Vhid"].ToString() != "") { model.Vhid = int.Parse(ds.Tables[0].Rows[0]["Vhid"].ToString()); } if (ds.Tables[0].Rows[0]["Vtitle"] != null && ds.Tables[0].Rows[0]["Vtitle"].ToString() != "") { model.Vtitle = ds.Tables[0].Rows[0]["Vtitle"].ToString(); } if (ds.Tables[0].Rows[0]["Vcontent"] != null && ds.Tables[0].Rows[0]["Vcontent"].ToString() != "") { model.Vcontent = ds.Tables[0].Rows[0]["Vcontent"].ToString(); } if (ds.Tables[0].Rows[0]["Vtype"] != null && ds.Tables[0].Rows[0]["Vtype"].ToString() != "") { model.Vtype = int.Parse(ds.Tables[0].Rows[0]["Vtype"].ToString()); } if (ds.Tables[0].Rows[0]["Vtotal"] != null && ds.Tables[0].Rows[0]["Vtotal"].ToString() != "") { model.Vtotal = int.Parse(ds.Tables[0].Rows[0]["Vtotal"].ToString()); } if (ds.Tables[0].Rows[0]["Vscore"] != null && ds.Tables[0].Rows[0]["Vscore"].ToString() != "") { model.Vscore = int.Parse(ds.Tables[0].Rows[0]["Vscore"].ToString()); } if (ds.Tables[0].Rows[0]["Vaverage"] != null && ds.Tables[0].Rows[0]["Vaverage"].ToString() != "") { model.Vaverage = int.Parse(ds.Tables[0].Rows[0]["Vaverage"].ToString()); } if (ds.Tables[0].Rows[0]["Vclose"] != null && ds.Tables[0].Rows[0]["Vclose"].ToString() != "") { if ((ds.Tables[0].Rows[0]["Vclose"].ToString() == "1") || (ds.Tables[0].Rows[0]["Vclose"].ToString().ToLower() == "true")) { model.Vclose = true; } else { model.Vclose = false; } } if (ds.Tables[0].Rows[0]["Vpoint"] != null && ds.Tables[0].Rows[0]["Vpoint"].ToString() != "") { if ((ds.Tables[0].Rows[0]["Vpoint"].ToString() == "1") || (ds.Tables[0].Rows[0]["Vpoint"].ToString().ToLower() == "true")) { model.Vpoint = true; } else { model.Vpoint = false; } } if (ds.Tables[0].Rows[0]["Vdate"] != null && ds.Tables[0].Rows[0]["Vdate"].ToString() != "") { model.Vdate = DateTime.Parse(ds.Tables[0].Rows[0]["Vdate"].ToString()); } return(model); } else { return(null); } }