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