public static Results AvailableInvoiceCash(int MID) { var r = new Results(); try { SqlParameter[] param = { new SqlParameter("@R",0), new SqlParameter("@Code",0), new SqlParameter("@Message",string.Empty), new SqlParameter("@MID",MID) }; param[0].Direction = ParameterDirection.ReturnValue; param[1].Direction = ParameterDirection.Output; param[2].Direction = ParameterDirection.Output; var _r = SqlHelper.ExecuteScalar(C.conn, CommandType.StoredProcedure, "Get_InoviceCash", param); r.Code = Convert.ToInt32(param[1].Value); r.Message = Convert.ToString(param[2].Value); r.DecimalValue = Convert.ToDecimal(_r); } catch (Exception ex) { r.Code = 300; r.Message = ex.Message; r.Value = 0; log.Fatal("{0},{1}",ex.Message,ex.StackTrace); } return r; }
public static Results Incomes(string Filter) { var r = new Results(); try { SqlParameter[] param = { new SqlParameter("@Filter",Filter), }; var _r = SqlHelper.ExecuteScalar(C.conn, CommandType.StoredProcedure, "M_Get_IncomesSum", param); r.Code = 0; r.Message = "Success"; r.DecimalValue = Convert.ToDecimal(_r); } catch (Exception ex) { r.Code = 300; r.Message = ex.Message; r.Value = 0; log.Fatal("{0},{1}", ex.Message, ex.StackTrace); } return r; }