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;
}
