public void Add(string orderId, string remark,string actInfo, string userId)
{
OrderChangeLogModel model = new OrderChangeLogModel();
model.OrderId = orderId;
model.Remark = remark;
model.Operator = userId;
model.ActInfo = actInfo;
dal.Add(model);
}
public void Add(string orderId, string remark, string actInfo, string userId)
{
OrderChangeLogModel model = new OrderChangeLogModel();
model.OrderId = orderId;
model.Remark = remark;
model.Operator = userId;
model.ActInfo = actInfo;
dal.Add(model);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
private OrderChangeLogModel ReaderBind(IDataReader dataReader)
{
OrderChangeLogModel model=new OrderChangeLogModel();
object ojb;
model.OrderId=dataReader["OrderId"].ToString();
ojb = dataReader["ChangeTime"];
if(ojb != null && ojb != DBNull.Value)
{
model.ChangeTime=(DateTime)ojb;
}
model.Remark=dataReader["Remark"].ToString();
model.Operator=dataReader["Operator"].ToString();
model.ActInfo = dataReader["actinfo"].ToString();
return model;
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(OrderChangeLogModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into spOrderChangeLog(");
strSql.Append("OrderId,ChangeTime,Remark,Operator,actinfo)");
strSql.Append(" values (@OrderId,getdate(),@Remark,@Operator,@actinfo)");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "OrderId", DbType.AnsiString, model.OrderId);
db.AddInParameter(dbCommand, "Remark", DbType.AnsiString, model.Remark);
db.AddInParameter(dbCommand, "Operator", DbType.AnsiString, model.Operator);
db.AddInParameter(dbCommand, "actinfo", DbType.AnsiString, model.ActInfo);
db.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
private OrderChangeLogModel ReaderBind(IDataReader dataReader)
{
OrderChangeLogModel model = new OrderChangeLogModel();
object ojb;
model.OrderId = dataReader["OrderId"].ToString();
ojb = dataReader["ChangeTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.ChangeTime = (DateTime)ojb;
}
model.Remark = dataReader["Remark"].ToString();
model.Operator = dataReader["Operator"].ToString();
model.ActInfo = dataReader["actinfo"].ToString();
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(OrderChangeLogModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into spOrderChangeLog(");
strSql.Append("OrderId,ChangeTime,Remark,Operator,actinfo)");
strSql.Append(" values (@OrderId,getdate(),@Remark,@Operator,@actinfo)");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "OrderId", DbType.AnsiString, model.OrderId);
db.AddInParameter(dbCommand, "Remark", DbType.AnsiString, model.Remark);
db.AddInParameter(dbCommand, "Operator", DbType.AnsiString, model.Operator);
db.AddInParameter(dbCommand, "actinfo", DbType.AnsiString, model.ActInfo);
db.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(OrderChangeLogModel model)
{
dal.Add(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(OrderChangeLogModel model)
{
dal.Add(model);
}