后台调用存储过程

public JsonResult GetResult(string p_account_month_to)

{

SqlParameter[] param =

{

new SqlParameter("@p_org_info_id ", SqlDbType.Int),

new SqlParameter("@p_customer_info_id ", SqlDbType.Int),

new SqlParameter("@p_account_month_from", SqlDbType.VarChar, 6),

new SqlParameter("@p_account_month_to", SqlDbType.VarChar, 6),

new SqlParameter("@p_user_name", SqlDbType.VarChar, 50),

new SqlParameter("@p_feedback", SqlDbType.VarChar, 500)

};

param[0].Value = base.org_info_id;

param[1].Value = base.customer_info_id;

param[2].Value = "";

param[3].Value = p_account_month_to;

param[4].Value = base.userName;

param[5].Direction = ParameterDirection.Output;//返回的值

using (EFContext context = new EFContext())

{

var results =

context.Database.ExecuteSqlCommand(

"fm_init_opening_balance @p_org_info_id,@p_customer_info_id ,@p_account_month_from,@p_account_month_to,@p_user_name,@p_feedback output",

param[0], param[1], param[2], param[3], param[4], param[5]);

context.Dispose();

}

var msg = param[5].Value;

return Json(msg, JsonRequestBehavior.AllowGet);