public lgk.Model.tb_remitBack GetBack(string where)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,MemberID,OrderCode,Sign,Amount,ReturnCode,AddTime from tb_remitBack ");
if (where != "")
{
strSql.Append(" where " + where);
}
lgk.Model.tb_remitBack model = new lgk.Model.tb_remitBack();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["MemberID"] != null && ds.Tables[0].Rows[0]["MemberID"].ToString() != "")
{
model.MemberID = Convert.ToInt32(ds.Tables[0].Rows[0]["MemberID"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderCode"] != null && ds.Tables[0].Rows[0]["OrderCode"].ToString() != "")
{
model.OrderCode = ds.Tables[0].Rows[0]["OrderCode"].ToString();
}
if (ds.Tables[0].Rows[0]["Sign"] != null && ds.Tables[0].Rows[0]["Sign"].ToString() != "")
{
model.Sign = ds.Tables[0].Rows[0]["Sign"].ToString();
}
if (ds.Tables[0].Rows[0]["Amount"] != null && ds.Tables[0].Rows[0]["Amount"].ToString() != "")
{
model.Amount = Convert.ToDecimal(ds.Tables[0].Rows[0]["Amount"].ToString());
}
if (ds.Tables[0].Rows[0]["ReturnCode"] != null && ds.Tables[0].Rows[0]["ReturnCode"].ToString() != "")
{
model.ReturnCode = ds.Tables[0].Rows[0]["ReturnCode"].ToString();
}
if (ds.Tables[0].Rows[0]["AddTime"] != null && ds.Tables[0].Rows[0]["AddTime"].ToString() != "")
{
model.AddTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["AddTime"].ToString());
}
return(model);
}
else
{
return(null);
}
}
public int AddBack(lgk.Model.tb_remitBack model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_remitBack(");
strSql.Append("MemberID,OrderCode,Sign,Amount,ReturnCode,AddTime");
strSql.Append(") values (");
strSql.Append("@MemberID,@OrderCode,@Sign,@Amount,@ReturnCode,@AddTime");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@MemberID", SqlDbType.Int),
new SqlParameter("@OrderCode", SqlDbType.VarChar, 50),
new SqlParameter("@Sign", SqlDbType.VarChar, 50),
new SqlParameter("@Amount", SqlDbType.Decimal),
new SqlParameter("@ReturnCode", SqlDbType.VarChar, 50),
new SqlParameter("@AddTime", SqlDbType.DateTime)
};
parameters[0].Value = model.MemberID;
parameters[1].Value = model.OrderCode;
parameters[2].Value = model.Sign;
parameters[3].Value = model.Amount;
parameters[4].Value = model.ReturnCode;
parameters[5].Value = model.AddTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj.ToString()));
}
}
