// public int UpdateTitleItemAssoc(TitleItemAssoc info) // { // // } // private List<TitleItem> DataTableToListItem(DataTable dt) // { // List<TitleItem> list = new List<TitleItem>(); // if (dt != null) // { // foreach (DataRow dr in dt.Rows) // { // TitleItem info = new TitleItem(); // info.TitleItemContent = dr["TitleItemContent"] == DBNull.Value ? "" : dr["TitleItemContent"].ToString(); // info.TitleItemId = dr["TitleItemId"] == DBNull.Value ? -100 : Convert.ToInt32(dr["TitleItemId"]); // info.TitleItemIndex = dr["TitleItemIndex"] == DBNull.Value ? -100 : Convert.ToInt32(dr["TitleItemIndex"]); // if (dr["UpdateDateTime"] != DBNull.Value) // { // DateTime datetime; // DateTime.TryParse(dr["UpdateDateTime"].ToString(), out datetime); // info.UpdateDateTime = datetime; // } // list.Add(info); // } // } // return list; // // } private List <TitleItemAssoc> DataTableToList(DataTable dt) { List <TitleItemAssoc> list = new List <TitleItemAssoc>(); if (dt != null) { foreach (DataRow dr in dt.Rows) { TitleItemAssoc info = new TitleItemAssoc(); info.TitleItemAssocId = dr["TitleItemAssocId"] == DBNull.Value ? -100 : Convert.ToInt32(dr["TitleItemAssocId"]); info.TitleItemId = dr["TitleItemId"] == DBNull.Value ? -100 : Convert.ToInt32(dr["TitleItemId"]); info.TitleInfoId = dr["TitleInfoId"] == DBNull.Value ? -100 : Convert.ToInt32(dr["TitleInfoId"]); info.TitleItemIndex = dr["TitleItemIndex"] == DBNull.Value ? -100 : Convert.ToInt32(dr["TitleItemIndex"]); info.TitleItemContent = dr["TitleItemContent"] == DBNull.Value ? "" : Convert.ToString(dr["TitleItemContent"]); if (dr["UpdateDateTime"] != DBNull.Value) { DateTime datetime; DateTime.TryParse(dr["UpdateDateTime"].ToString(), out datetime); info.UpdateDateTime = datetime; } list.Add(info); } } return(list); }
public ActionResult IsExistTitleItemAssoc(TitleItemAssoc info) { bool result = TitleItemAssocbll.IsExistTitleItemAssoc(info.TitleInfoId, info.TitleItemId); var res = new ConfigurableJsonResult(); res.Data = result == true ? 1 : 0; HttpContext.Response.AppendHeader("Access-Control-Allow-Origin", "*"); return(res); }
/// <summary> /// 增加题目下的选项 /// </summary> /// <param name="info"></param> /// <returns></returns> public ActionResult AddTitleItemAssoc(TitleItemAssoc info) { int result = TitleItemAssocbll.AddTitleItemAssoc(info); var res = new ConfigurableJsonResult(); res.Data = result; HttpContext.Response.AppendHeader("Access-Control-Allow-Origin", "*"); return(res); }
public int AddTitleItemAssoc(TitleItemAssoc info) { string strSql = "insert into TitleItemAssoc (TitleInfoId,TitleItemId,TitleItemIndex,UpdateDateTime) values (@TitleInfoId,@TitleItemId,@TitleItemIndex,@UpdateDateTime)"; return(DBFactory.GetDB(DBType.SQLITE, m_strConn).ExecuteNonQuery(strSql, new DbParameter[] { new SQLiteParameter() { Value = info.TitleInfoId, ParameterName = "@TitleInfoId" }, new SQLiteParameter() { Value = info.TitleItemId, ParameterName = "@TitleItemId" }, new SQLiteParameter() { Value = info.TitleItemIndex, ParameterName = "@TitleItemIndex" }, new SQLiteParameter() { Value = info.UpdateDateTime, ParameterName = "@UpdateDateTime" } })); }