public bool Insert(RechargeBackRecord obj)
{
bool result = false;
try
{
SqlParameter[] parameters = new SqlParameter[]{
new SqlParameter("@UptranSeq",obj.UptranSeq),
new SqlParameter("@TranDate",obj.TranDate),
new SqlParameter("@RetnCode",obj.RetnCode),
new SqlParameter("@RetnInfo",obj.RetnInfo),
new SqlParameter("@OrderTransactionID",obj.OrderTransactionID),
new SqlParameter("@OrderSeq",obj.OrderSeq),
new SqlParameter("@EncodeType",obj.EncodeType),
new SqlParameter("@Sign",obj.Sign),
new SqlParameter("@RechargeType",obj.RechargeType)
};
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 Update(RechargeBackRecord obj)
{
bool result = false;
try
{
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@ID", obj.ID),
new SqlParameter("@UptranSeq", obj.UptranSeq),
new SqlParameter("@TranDate", obj.TranDate),
new SqlParameter("@RetnCode", obj.RetnCode),
new SqlParameter("@RetnInfo", obj.RetnInfo),
new SqlParameter("@OrderTransactionID", obj.OrderTransactionID),
new SqlParameter("@OrderSeq", obj.OrderSeq),
new SqlParameter("@EncodeType", obj.EncodeType),
new SqlParameter("@Sign", obj.Sign),
new SqlParameter("@RechargeType", obj.RechargeType)
};
SqlCommand cmd = new SqlCommand(Update_Sql);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddRange(parameters);
result = DBUtility.Execute(cmd, DBUtility.BestToneCenterConStr);
}
catch { }
return(result);
}
private IList <RechargeBackRecord> QueryByWhere(String where)
{
IList <RechargeBackRecord> 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 <RechargeBackRecord>();
foreach (DataRow row in ds.Tables[0].Rows)
{
RechargeBackRecord entity = new RechargeBackRecord();
entity.ID = Convert.ToInt64(row["ID"]);
entity.UptranSeq = row["UptranSeq"].ToString();
entity.TranDate = row["TranDate"].ToString();
entity.RetnCode = row["RetnCode"].ToString();
entity.RetnInfo = row["RetnInfo"].ToString();
entity.OrderTransactionID = row["OrderTransactionID"].ToString();
entity.OrderSeq = row["OrderSeq"].ToString();
entity.EncodeType = row["EncodeType"].ToString();
entity.Sign = row["Sign"].ToString();
entity.RechargeType = row["RechargeType"].ToString();
list.Add(entity);
}
}
return(list);
}
public RechargeBackRecord QueryByID(Int64 id)
{
RechargeBackRecord obj = null;
try
{
String where = String.Format(" where ID = '{0}'", id);
IList <RechargeBackRecord> list = QueryByWhere(where);
if (list != null && list.Count > 0)
{
obj = list[0];
}
}
catch (Exception ex) { throw ex; }
return(obj);
}
public RechargeBackRecord QueryByUptranSeq(String untranseq)
{
RechargeBackRecord obj = null;
try
{
String where = String.Format(" where UptranSeq = '{0}'", untranseq);
IList <RechargeBackRecord> list = QueryByWhere(where);
if (list != null && list.Count > 0)
{
obj = list[0];
}
}
catch (Exception ex) { throw ex; }
return(obj);
}
private IList<RechargeBackRecord> QueryByWhere(String where)
{
IList<RechargeBackRecord> 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<RechargeBackRecord>();
foreach (DataRow row in ds.Tables[0].Rows)
{
RechargeBackRecord entity = new RechargeBackRecord();
entity.ID = Convert.ToInt64(row["ID"]);
entity.UptranSeq = row["UptranSeq"].ToString();
entity.TranDate = row["TranDate"].ToString();
entity.RetnCode = row["RetnCode"].ToString();
entity.RetnInfo = row["RetnInfo"].ToString();
entity.OrderTransactionID = row["OrderTransactionID"].ToString();
entity.OrderSeq = row["OrderSeq"].ToString();
entity.EncodeType = row["EncodeType"].ToString();
entity.Sign = row["Sign"].ToString();
entity.RechargeType = row["RechargeType"].ToString();
list.Add(entity);
}
}
return list;
}