110,500
社区成员
发帖
与我相关
我的任务
分享
private void Bank3()
{
try
{
DbCommand cmd = db.GetStoredProcCommand("Bank_ADDandUpdate");
db.AddInParameter(cmd, "@username", DbType.String, txtName.Text);
db.AddInParameter(cmd, "@username2", DbType.String, txtName2.Text);
db.AddInParameter(cmd, "@money", DbType.Double, Convert.ToDouble(txtMoney.Text));
//加入输出值参数
db.AddInParameter(cmd, "@outvalue", DbType.Int, Convert.ToDouble(txtMoney.Text));
if (i == 1)
{
db.ExecuteNonQuery(cmd);
//在ExecuteNoeQuery后面就可以获得你的值了cmd.Paramater["outvalue"].value
MessageBox.Show("转账成功!");
}
else
{
MessageBox.Show("转账XX!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
System.Data.Common.DbTransaction Tran = null;
try
{
string m_strCommand = "pro_T_Common_Labour_SelectPagedDynamic";
Microsoft.Practices.EnterpriseLibrary.Data.Database DB = Microsoft.Practices.EnterpriseLibrary.Data.DatabaseFactory.CreateDatabase(p_ConnString);
System.Data.Common.DbConnection Conn = DB.CreateConnection();
Conn.Open();
Tran = Conn.BeginTransaction();
System.Data.Common.DbCommand dbc = DB.GetStoredProcCommand(m_strCommand);
DB.AddInParameter(dbc, "@PageSize", System.Data.DbType.Int32, entity.PageSize);
DB.AddInParameter(dbc, "@PageIndex", System.Data.DbType.Int32, entity.PageIndex);
DB.AddOutParameter(dbc, "@TotalRowCount", System.Data.DbType.Int32, 4); //这里就是OutPut参数
DB.AddInParameter(dbc, "@WhereCondition", System.Data.DbType.String, entity.WhereCondition);
dbc.CommandTimeout = 90;
p_DS = DB.ExecuteDataSet(dbc, Tran);
Tran.Commit();
Conn.Close();
entity.TotalRowCount = Convert.ToInt32(DB.GetParameterValue(dbc, "@TotalRowCount"));
//这里就是获取OutPut传回来的值
return true;
}
catch (System.Exception ex)
{
throw Ex;
}