public bool Insert(tbOrderSync OrderSync)
{
bool IsOk = false;
IDbDataParameter[] parm = GetInsertParam();
parm[0].Value = OrderSync.UserId;
parm[1].Value = OrderSync.Sync;
parm[2].Value = OrderSync.SyncEnum;
try
{
DBHelper.ExecuteNonQuery(CommandType.StoredProcedure, SQL_INSERT, parm);
IsOk = true;
}
catch { }
return(IsOk);
}
public bool Update(tbOrderSync OrderSync)
{
bool IsOk = false;
IDbDataParameter[] parm = GetUpdateParam();
parm[0].Value = OrderSync.UserId;
parm[1].Value = OrderSync.Sync;
parm[2].Value = OrderSync.SyncEnum;
parm[3].Value = OrderSync.LastModifyTime;
try
{
DBHelper.ExecuteNonQuery(CommandType.StoredProcedure, SQL_UPDATE, parm);
IsOk = true;
}
catch { }
return(IsOk);
}
public tbOrderSync Select(int UserId, int SyncEnum)
{
tbOrderSync Sync = null;
IDbDataParameter[] parm = GetSelecByUIdParam();
parm[0].Value = UserId;
parm[1].Value = SyncEnum;
using (IDataReader MyReader = DBHelper.ExecuteReader(CommandType.StoredProcedure, SQL_SELECT, parm))
{
if (MyReader.Read())
{
Sync = new tbOrderSync()
{
UserId = MyReader.GetInt32(0),
Sync = MyReader.GetBoolean(1),
SyncEnum = MyReader.GetInt32(2),
LastModifyTime = MyReader.GetDateTime(3),
};
}
}
return(Sync == null ? new tbOrderSync() : Sync);
}
/// <summary>
/// 修改订单同步状态信息
/// </summary>
/// <param name="OrderSync">订单同步状态表</param>
/// <returns></returns>
public static bool Update(tbOrderSync OrderSync)
{
return(OrderSyncDal.Update(OrderSync));
}
/// <summary>
/// 添加订单同步状态信息
/// </summary>
/// <param name="OrderSync">订单同步状态表</param>
/// <returns></returns>
public static bool Insert(tbOrderSync OrderSync)
{
return(OrderSyncDal.Insert(OrderSync));
}
