public bool Insert(BankRechargeOrder obj)
{
bool result = false;
try
{
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@OrderSeq", obj.OrderSeq),
new SqlParameter("@OrderTransactionID", obj.OrderTransactionID),
new SqlParameter("@OrderDate", obj.OrderDate),
new SqlParameter("@CurType", obj.CurType),
new SqlParameter("@OrderAmount", obj.OrderAmount),
new SqlParameter("@ProductAmount", obj.ProductAmount),
new SqlParameter("@AttachAmount", obj.AttachAmount),
new SqlParameter("@OrderDesc", obj.OrderDesc),
new SqlParameter("@CustID", obj.CustID),
new SqlParameter("@TargetAccount", obj.TargetAccount),
new SqlParameter("@SourceSPID", obj.SourceSPID),
new SqlParameter("@ReqTime", obj.ReqTime),
new SqlParameter("@DeductionTime", obj.DeductionTime),
new SqlParameter("@CompleteTime", obj.CompleteTime),
new SqlParameter("@Status", obj.Status),
new SqlParameter("@RechargeCount", obj.RechargeCount)
};
SqlCommand cmd = new SqlCommand(Insert_Sql);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddRange(parameters);
result = DBUtility.Execute(cmd, DBUtility.BestToneCenterConStr);
}
catch { }
return(result);
}
public bool Insert(BankRechargeOrder obj)
{
bool result = false;
try
{
SqlParameter[] parameters = new SqlParameter[]{
new SqlParameter("@OrderSeq",obj.OrderSeq),
new SqlParameter("@OrderTransactionID",obj.OrderTransactionID),
new SqlParameter("@OrderDate",obj.OrderDate),
new SqlParameter("@CurType",obj.CurType),
new SqlParameter("@OrderAmount",obj.OrderAmount),
new SqlParameter("@ProductAmount",obj.ProductAmount),
new SqlParameter("@AttachAmount",obj.AttachAmount),
new SqlParameter("@OrderDesc",obj.OrderDesc),
new SqlParameter("@CustID",obj.CustID),
new SqlParameter("@TargetAccount",obj.TargetAccount),
new SqlParameter("@SourceSPID",obj.SourceSPID),
new SqlParameter("@ReqTime",obj.ReqTime),
new SqlParameter("@DeductionTime",obj.DeductionTime),
new SqlParameter("@CompleteTime",obj.CompleteTime),
new SqlParameter("@Status",obj.Status),
new SqlParameter("@RechargeCount",obj.RechargeCount)
};
SqlCommand cmd = new SqlCommand(Insert_Sql);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddRange(parameters);
result = DBUtility.Execute(cmd, DBUtility.BestToneCenterConStr);
}
catch { }
return result;
}
/// <summary>
/// 查询待充值的订单
/// </summary>
public IList <BankRechargeOrder> QueryWaitToRechargeOrder(Int32 count)
{
IList <BankRechargeOrder> list = null;
try
{
String sql = String.Empty;
if (count == 0)
{
sql = String.Format("Select * From BankRechargeOrder Where Status='2' Order by ReqTime", count);
}
else
{
sql = String.Format("Select top {0} * From BankRechargeOrder Where Status='2' Order by ReqTime", count);
}
SqlCommand cmd = new SqlCommand(sql);
cmd.CommandType = CommandType.Text;
DataSet ds = DBUtility.FillData(cmd, DBUtility.BestToneCenterConStr);
if (ds != null && ds.Tables[0] != null)
{
list = new List <BankRechargeOrder>();
foreach (DataRow row in ds.Tables[0].Rows)
{
BankRechargeOrder entity = new BankRechargeOrder();
entity.ID = Convert.ToInt64(row["ID"]);
entity.OrderSeq = row["OrderSeq"].ToString();
entity.OrderTransactionID = row["OrderTransactionID"].ToString();
entity.OrderDate = row["OrderDate"].ToString();
entity.CurType = row["CurType"].ToString();
entity.OrderAmount = Convert.ToInt64(row["OrderAmount"]);
entity.ProductAmount = Convert.ToInt64(row["ProductAmount"]);
entity.AttachAmount = Convert.ToInt64(row["AttachAmount"]);
entity.OrderDesc = row["OrderDesc"].ToString();
entity.CustID = row["CustID"].ToString();
entity.TargetAccount = row["TargetAccount"].ToString();
entity.SourceSPID = row["SourceSPID"].ToString();
entity.ReqTime = Convert.ToDateTime(row["ReqTime"]);
entity.DeductionTime = Convert.ToDateTime(row["DeductionTime"]);
entity.CompleteTime = Convert.ToDateTime(row["CompleteTime"]);
entity.Status = Convert.ToInt32(row["Status"]);
entity.RechargeCount = Convert.ToInt32(row["RechargeCount"]);
list.Add(entity);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(list);
}
public BankRechargeOrder QueryByOrderTransacntionID(String transactionid)
{
BankRechargeOrder obj = null;
try
{
String where = String.Format(" where OrderTransactionID = '{0}'", transactionid);
IList <BankRechargeOrder> list = QueryByWhere(where);
if (list != null && list.Count > 0)
{
obj = list[0];
}
}
catch (Exception ex) { throw ex; }
return(obj);
}
private IList <BankRechargeOrder> QueryByWhere(String where)
{
IList <BankRechargeOrder> list = null;
String sql = Select_Sql.Insert(Select_Sql.Length, where);
SqlCommand cmd = new SqlCommand(sql);
cmd.CommandType = CommandType.Text;
DataSet ds = DBUtility.FillData(cmd, DBUtility.BestToneCenterConStr);
if (ds != null && ds.Tables[0] != null)
{
list = new List <BankRechargeOrder>();
foreach (DataRow row in ds.Tables[0].Rows)
{
BankRechargeOrder entity = new BankRechargeOrder();
entity.ID = Convert.ToInt64(row["ID"]);
entity.OrderSeq = row["OrderSeq"].ToString();
entity.OrderTransactionID = row["OrderTransactionID"].ToString();
entity.OrderDate = row["OrderDate"].ToString();
entity.CurType = row["CurType"].ToString();
entity.OrderAmount = Convert.ToInt64(row["OrderAmount"]);
entity.ProductAmount = Convert.ToInt64(row["ProductAmount"]);
entity.AttachAmount = Convert.ToInt64(row["AttachAmount"]);
entity.OrderDesc = row["OrderDesc"].ToString();
entity.CustID = row["CustID"].ToString();
entity.TargetAccount = row["TargetAccount"].ToString();
entity.SourceSPID = row["SourceSPID"].ToString();
entity.ReqTime = Convert.ToDateTime(row["ReqTime"]);
entity.DeductionTime = Convert.ToDateTime(row["DeductionTime"]);
entity.CompleteTime = Convert.ToDateTime(row["CompleteTime"]);
entity.Status = Convert.ToInt32(row["Status"]);
entity.RechargeCount = Convert.ToInt32(row["RechargeCount"]);
list.Add(entity);
}
}
return(list);
}
private IList<BankRechargeOrder> QueryByWhere(String where)
{
IList<BankRechargeOrder> list = null;
String sql = Select_Sql.Insert(Select_Sql.Length, where);
SqlCommand cmd = new SqlCommand(sql);
cmd.CommandType = CommandType.Text;
DataSet ds = DBUtility.FillData(cmd, DBUtility.BestToneCenterConStr);
if (ds != null && ds.Tables[0] != null)
{
list = new List<BankRechargeOrder>();
foreach (DataRow row in ds.Tables[0].Rows)
{
BankRechargeOrder entity = new BankRechargeOrder();
entity.ID = Convert.ToInt64(row["ID"]);
entity.OrderSeq = row["OrderSeq"].ToString();
entity.OrderTransactionID = row["OrderTransactionID"].ToString();
entity.OrderDate = row["OrderDate"].ToString();
entity.CurType = row["CurType"].ToString();
entity.OrderAmount = Convert.ToInt64(row["OrderAmount"]);
entity.ProductAmount = Convert.ToInt64(row["ProductAmount"]);
entity.AttachAmount = Convert.ToInt64(row["AttachAmount"]);
entity.OrderDesc = row["OrderDesc"].ToString();
entity.CustID = row["CustID"].ToString();
entity.TargetAccount = row["TargetAccount"].ToString();
entity.SourceSPID = row["SourceSPID"].ToString();
entity.ReqTime = Convert.ToDateTime(row["ReqTime"]);
entity.DeductionTime = Convert.ToDateTime(row["DeductionTime"]);
entity.CompleteTime = Convert.ToDateTime(row["CompleteTime"]);
entity.Status = Convert.ToInt32(row["Status"]);
entity.RechargeCount = Convert.ToInt32(row["RechargeCount"]);
list.Add(entity);
}
}
return list;
}
/// <summary>
/// ��ѯ����ֵ�Ķ���
/// </summary>
public IList<BankRechargeOrder> QueryWaitToRechargeOrder(Int32 count)
{
IList<BankRechargeOrder> list = null;
try
{
String sql = String.Empty;
if (count == 0)
sql = String.Format("Select * From BankRechargeOrder Where Status='2' Order by ReqTime", count);
else
sql = String.Format("Select top {0} * From BankRechargeOrder Where Status='2' Order by ReqTime", count);
SqlCommand cmd = new SqlCommand(sql);
cmd.CommandType = CommandType.Text;
DataSet ds = DBUtility.FillData(cmd, DBUtility.BestToneCenterConStr);
if (ds != null && ds.Tables[0] != null)
{
list = new List<BankRechargeOrder>();
foreach (DataRow row in ds.Tables[0].Rows)
{
BankRechargeOrder entity = new BankRechargeOrder();
entity.ID = Convert.ToInt64(row["ID"]);
entity.OrderSeq = row["OrderSeq"].ToString();
entity.OrderTransactionID = row["OrderTransactionID"].ToString();
entity.OrderDate = row["OrderDate"].ToString();
entity.CurType = row["CurType"].ToString();
entity.OrderAmount = Convert.ToInt64(row["OrderAmount"]);
entity.ProductAmount = Convert.ToInt64(row["ProductAmount"]);
entity.AttachAmount = Convert.ToInt64(row["AttachAmount"]);
entity.OrderDesc = row["OrderDesc"].ToString();
entity.CustID = row["CustID"].ToString();
entity.TargetAccount = row["TargetAccount"].ToString();
entity.SourceSPID = row["SourceSPID"].ToString();
entity.ReqTime = Convert.ToDateTime(row["ReqTime"]);
entity.DeductionTime = Convert.ToDateTime(row["DeductionTime"]);
entity.CompleteTime = Convert.ToDateTime(row["CompleteTime"]);
entity.Status = Convert.ToInt32(row["Status"]);
entity.RechargeCount = Convert.ToInt32(row["RechargeCount"]);
list.Add(entity);
}
}
}
catch (Exception ex)
{
throw ex;
}
return list;
}