怎么调用存储过程和函数？
墨初 知识笔记 43阅读
1.增加操作：public static void StockIns(string PS _ SupplierName，int pn_ItemQty，string ps_ItemDesc，string ps_ComeDate，string ps_AttachedFile，string ps_SupAddress，string ps_SupPhone，string ps_SupFax，string ps_SupEmail，string ps_UserNo，ref string ps_HKStockItemNo) { //创建参/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span> parameter[]parms=new Oracle parameter[]{ new Oracle parameter(' PS _ supplier name 'OracleType .VarChar，200)，新的OracleParameter('pn_ItemQty 'OracleType .Int32，10)，新建OracleParameter('ps_ItemDesc 'OracleType .VarChar，400)，新OracleParameter('ps_ComeDate 'OracleType .VarChar，20)，新/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>(' PS _ attached file)，OracleType .VarChar，100)，新的OracleParameter('ps_SupAddress 'OracleType .VarChar，200)，新的OracleParameter('ps_SupPhone 'OracleType .瓦尔查尔，60岁)，新的OracleParameter('ps_SupFax 'OracleType .瓦尔查尔，60岁)，nb
sp; new OracleParameter("ps_SupEmail", OracleType.VarChar, 100),new OracleParameter("ps_UserNo", OracleType.VarChar, 20),
new OracleParameter("ps_HKStockItemNo", OracleType.VarChar, 20,/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)"/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span class="xzm_is" data-txt="ParameterZirection#3C"/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>.Output, true, 0, 0, "", DataRowVersion.Default, null)
};
// 给参数赋值
parms[0].Value = ps_SupplierName;
parms[1].Value = pn_ItemQty;
parms[2].Value = ps_ItemDesc;
parms[3].Value = ps_ComeDate;
parms[4].Value = ps_AttachedFile;
parms[5].Value = ps_SupAddress;
parms[6].Value = ps_SupPhone;
parms[7].Value = ps_SupFax;
parms[8].Value = ps_SupEmail;
parms[9].Value = ps_UserNo;
OraHelper.ExecuteNonQuery(OraHelper.connstr, /span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>, "KXSCMIII.PKG_PU_HKSTOCK.Pro_StockIns", parms);
ps_HKStockItemNo = parms[10].Value.ToString(); // 返回存货单号
}/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>br/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 128, 0, 1)">在前台*.aspx.cs文件里面调用：/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>br/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)"> string strBill = "";/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>br> HKStockDataAccess.StockIns(txtSupplierName.Text.Trim(), Int32.Parse(txtItemQty.Text.Trim()), txtItemDesc.Text.Trim(),
txtComeDate.Text.Trim(), strServerFullPath, txtSupAddress.Text.Trim(), txtSupPhone.Text.Trim(),
txtSupFax.Text.Trim(), txtSupEmail.Text.Trim(), Session["userno"].ToString(),ref strBill);/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>br/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>br/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 255, 1)">2.修改操作：
/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>span style="color: rgba(0, 0, 0, 1)"> public static void ClaimStock(string ps_HKStockItemNo, string ps_Buyer,
string ps_DeliNo, string ps_UserNo)
{
// 创建参数
OracleParameter[] parms = new OracleParameter[]
{
new OracleParameter("ps_HKStockItemNo",OracleType.VarChar,20),
new OracleParameter("ps_Buyer",OracleType.VarChar,20),
new OracleParameter("ps_DeliNo",OracleType.VarChar,20),
new OracleParameter("ps_UserNo",OracleType.VarChar,20)
};/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/p>
// 给参数赋值
parms[0].Value = ps_HKStockItemNo;
parms[1].Value = ps_Buyer;
parms[2].Value = ps_DeliNo;
parms[3].Value = ps_UserNo;
OraHelper.ExecuteNonQuery(OraHelper.connstr, /span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>, "KXSCMIII.PKG_PU_HKSTOCK.Pro_ClaimStock", parms);
}
{
// 创建参数
OracleParameter[] parms = new OracleParameter[]
{
new OracleParameter("ps_HKStockItemNo",OracleType.VarChar,20),
new OracleParameter("returncur", OracleType.Cursor, 2000, ParameterDirection.Output, true,
0, 0, "", DataRowVersion.Default, null)
};/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/p>
// 给参数赋值
parms[0].Value = ps_HKStockItemNo;
// 取记录集
DataSet ds = OraHelper./span>/span>/span>/span>(OraHelper.connstr, /span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>,
"KXSCMIII.PKG_PU_HKSTOCK.Pro_StockDetailGet", parms);
return ds.Tables[0];
}
{
// 创建参数
OracleParameter[] parms = new OracleParameter[]
{
new OracleParameter("ps_CardNo", OracleType.VarChar, 20),
new OracleParameter("ps_FullName", OracleType.VarChar, 80, ParameterDirection.ReturnValue, true, 0, 0, "", DataRowVersion.Default, null)
};/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/p>
// 给参数赋值
parms[0].Value = ps_CardNo;
OraHelper.ExecuteNonQuery(OraHelper.connstr, /span>/span>/span>/span>/span>/span>/span>/span>/span>/span>/span>, "KXSCMIII.PKG_PU_HKSTOCK.Fun_BuyerNameGet", parms);
return parms[1].Value.ToString(); // 返回业务员的中文名
}