// public dynamic GetModel(int Id) { try { dynamic model = null; StringBuilder strSql = new StringBuilder(); strSql.Append(" select Id,TurnOutTypeName,Editor,CreateDate from T_TurnOutType "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; using (dynamic read = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters)) { model = new TurnOutType(); if (read.Read()) { try { model.Id = int.Parse(read["Id"].ToString()); } catch { } model.TurnOutTypeName = read["TurnOutTypeName"].ToString(); model.Editor = read["Editor"].ToString(); try { model.CreateDate = DateTime.Parse(read["CreateDate"].ToString()); } catch { } } read.Dispose(); } return(model); } catch { throw; } }
private dynamic GetModels(HttpContext context) { TurnOutType model = new TurnOutType(); model.TurnOutTypeName = context.Request.Form["TurnOutTypeName"]; model.Editor = adminUser.AdminName; try { model.Id = int.Parse(context.Request.Form["Id"].ToString()); } catch { model.Id = 0; } return(model); }
// public bool Update(TurnOutType model) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_TurnOutType set "); strSql.Append("TurnOutTypeName=@TurnOutTypeName,"); strSql.Append("Editor=@Editor,"); strSql.Append("CreateDate=@CreateDate"); strSql.Append(" where Id=@Id"); if (DbHelperSQL.ExecuteSql(strSql.ToString(), GetSqlParameter(model)) > 0) { return(true); } else { return(false); } } catch { throw; } }
// public bool Create(TurnOutType model) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_TurnOutType("); strSql.Append("TurnOutTypeName,Editor,CreateDate)"); strSql.Append(" values ("); strSql.Append("@TurnOutTypeName,@Editor,@CreateDate)"); if (DbHelperSQL.ExecuteSql(strSql.ToString(), GetSqlParameter(model)) > 0) { return(true); } else { return(false); } } catch { throw; } }