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())); } }