// public dynamic GetModel(int Id) { try { dynamic model = null; StringBuilder strSql = new StringBuilder(); strSql.Append(" select Id,FK_BidId,FK_LiceTranId,ApplyDate,TradingStatus,Editor,CreateDate from T_BidTrans "); 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)) { if (read.Read()) { model = new BidTrans(); model.Id = int.Parse(read["Id"].ToString()); model.FK_BidId = int.Parse(read["FK_BidId"].ToString()); model.FK_LiceTranId = int.Parse(read["FK_LiceTranId"].ToString()); model.TradingStatus = int.Parse(read["TradingStatus"].ToString()); model.Editor = read["Editor"].ToString(); model.CreateDate = DateTime.Parse(read["CreateDate"].ToString()); model.ApplyDate = DateTime.Parse(read["ApplyDate"].ToString()); } read.Dispose(); } return(model); } catch { throw; } }
// private dynamic GetModels(HttpContext context) { dynamic model = new BidTrans(); try { model.Id = int.Parse(context.Request.Form["Id"].ToString()); } catch { } model.FK_BidId = int.Parse(context.Request.Form["FK_BidId"].ToString()); try { model.FK_LiceTranId = int.Parse(context.Request.Form["FK_LiceTranId"].ToString()); } catch { } try { model.TradingStatus = int.Parse(context.Request.Form["TradingStatus"].ToString()); } catch { model.TradingStatus = 0; } model.CreateDate = DateTime.Now; model.ApplyDate = DateTime.Now; model.Editor = UserName; return(model); }
// public bool Create(BidTrans model) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_BidTrans("); strSql.Append("FK_BidId,FK_LiceTranId,TradingStatus,Editor,CreateDate,ApplyDate)"); strSql.Append(" values ("); strSql.Append("@FK_BidId,@FK_LiceTranId,@TradingStatus,@Editor,@CreateDate,@ApplyDate)"); if (DbHelperSQL.ExecuteSql(strSql.ToString(), GetSqlParameter(model)) > 0) { return(true); } else { return(false); } } catch { throw; } }
// private SqlParameter[] GetSqlParameter(BidTrans model) { SqlParameter[] parameters = { new SqlParameter("@FK_BidId", SqlDbType.Int, 4), new SqlParameter("@FK_LiceTranId", SqlDbType.Int, 4), new SqlParameter("@TradingStatus", SqlDbType.Int, 4), new SqlParameter("@Editor", SqlDbType.NVarChar, 50), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@ApplyDate", SqlDbType.DateTime), new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = model.FK_BidId; parameters[1].Value = model.FK_LiceTranId; parameters[2].Value = model.TradingStatus; parameters[3].Value = model.Editor; parameters[4].Value = model.CreateDate; parameters[5].Value = model.ApplyDate; parameters[6].Value = model.Id; return(parameters); }
// public bool Update(BidTrans model) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_BidTrans set "); strSql.Append("FK_BidId=@FK_BidId,"); strSql.Append("FK_LiceTranId=@FK_LiceTranId,"); strSql.Append("TradingStatus=@TradingStatus,"); strSql.Append("Editor=@Editor,"); strSql.Append("CreateDate=@CreateDate,"); strSql.Append("ApplyDate=@ApplyDate"); strSql.Append(" where Id=@Id"); if (DbHelperSQL.ExecuteSql(strSql.ToString(), GetSqlParameter(model)) > 0) { return(true); } else { return(false); } } catch { throw; } }