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