public int Update(SOAlipayInfo oParam) { string sql = @"UPDATE SO_Alipay SET SOSysNo=@SOSysNo, AlipayTradeNo=@AlipayTradeNo WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramSOSysNo = new SqlParameter("@SOSysNo", SqlDbType.Int, 4); SqlParameter paramAlipayTradeNo = new SqlParameter("@AlipayTradeNo", SqlDbType.NVarChar, 50); if (oParam.SysNo != AppConst.IntNull) paramSysNo.Value = oParam.SysNo; else paramSysNo.Value = System.DBNull.Value; if (oParam.SOSysNo != AppConst.IntNull) paramSOSysNo.Value = oParam.SOSysNo; else paramSOSysNo.Value = System.DBNull.Value; if (oParam.AlipayTradeNo != AppConst.StringNull) paramAlipayTradeNo.Value = oParam.AlipayTradeNo; else paramAlipayTradeNo.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramSOSysNo); cmd.Parameters.Add(paramAlipayTradeNo); return SqlHelper.ExecuteNonQuery(cmd); }
public int Insert(SOAlipayInfo oParam) { string sql = @"INSERT INTO SO_Alipay ( SOSysNo, AlipayTradeNo ) VALUES ( @SOSysNo, @AlipayTradeNo );set @SysNo = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramSOSysNo = new SqlParameter("@SOSysNo", SqlDbType.Int, 4); SqlParameter paramAlipayTradeNo = new SqlParameter("@AlipayTradeNo", SqlDbType.NVarChar, 50); paramSysNo.Direction = ParameterDirection.Output; if (oParam.SOSysNo != AppConst.IntNull) paramSOSysNo.Value = oParam.SOSysNo; else paramSOSysNo.Value = System.DBNull.Value; if (oParam.AlipayTradeNo != AppConst.StringNull) paramAlipayTradeNo.Value = oParam.AlipayTradeNo; else paramAlipayTradeNo.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramSOSysNo); cmd.Parameters.Add(paramAlipayTradeNo); return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo); }
protected void btnEnter_Click(object sender, EventArgs e) { if (txtTradeNo.Text != string.Empty) { int Result = 0; bool IsAdd = true; int SOSysNo = Int32.Parse(lblSOID.Text.Substring(1)); SOAlipayInfo oInfo = SaleManager.GetInstance().LoadSOAlipay(SOSysNo); if (oInfo == null) { oInfo = new SOAlipayInfo(); oInfo.SOSysNo = SOSysNo; oInfo.AlipayTradeNo = txtTradeNo.Text.Trim(); Result = SaleManager.GetInstance().InsertSOAlipay(oInfo); lblResult.Text = "输入支付宝交易号完成!"; } else { IsAdd = false; oInfo.AlipayTradeNo = txtTradeNo.Text.Trim(); Result = SaleManager.GetInstance().UpdateSOAlipay(oInfo); lblResult.Text = "更新支付宝交易号完成!"; } if (Result == 1) { SOInfo order = SaleManager.GetInstance().LoadSOMaster(SOSysNo); if (order != null) { if (IsAdd) { NetPayInfo netpay = new NetPayInfo(); netpay.SOSysNo = SOSysNo; netpay.PayTypeSysNo = order.PayTypeSysNo; netpay.InputTime = DateTime.Now; netpay.Source = (int)AppEnum.NetPaySource.Bank; netpay.PayAmount = order.GetTotalAmt(); netpay.Status = (int)AppEnum.NetPayStatus.Origin; netpay.Note = "支付宝即时到帐付款"; NetPayManager.GetInstance().Insert(netpay); } } lblResult.Visible = true; } } }
private void map(SOAlipayInfo oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.SOSysNo = Util.TrimIntNull(tempdr["SOSysNo"]); oParam.AlipayTradeNo = Util.TrimNull(tempdr["AlipayTradeNo"]); }
public int UpdateSOAlipay(SOAlipayInfo oParam) { return new SOAlipayDac().Update(oParam); }
public SOAlipayInfo LoadSOAlipay(int SOSysNo) { string sql = "select * from so_alipay where sosysno=" + SOSysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); SOAlipayInfo oInfo = new SOAlipayInfo(); if (Util.HasMoreRow(ds)) map(oInfo, ds.Tables[0].Rows[0]); else oInfo = null; return oInfo; }
public int InsertSOAlipay(SOAlipayInfo oParam) { return new SOAlipayDac().Insert(oParam); }