private string GetCode(MCPERPEntities db, string code)

        {

            List<SqlParameter> paramArray =

 new List<SqlParameter>();

            paramArray.Add(new SqlParameter("@I_CodeName", code));

            paramArray.Add(new SqlParameter("@I_Year", DateTime.Now.ToString("yyyy")));

            paramArray.Add(new SqlParameter("@I_Month", DateTime.Now.ToString("MM")));

            paramArray.Add(new SqlParameter("@I_Day", DateTime.Now.ToString("dd")));

            SqlParameter param = new SqlParameter("@O_Code", SqlDbType.NVarChar);

            param.Direction = ParameterDirection.Output;

            paramArray.Add(param);

            paramArray[0].SqlDbType = SqlDbType.VarChar;

            paramArray[0].Size = 200;

            paramArray[1].SqlDbType = SqlDbType.VarChar;

            paramArray[1].Size = 4;

            paramArray[2].SqlDbType = SqlDbType.VarChar;

            paramArray[2].Size = 2;

            paramArray[3].SqlDbType = SqlDbType.VarChar;

            paramArray[3].Size = 2;

            try

            {

                db.Database.ExecuteSqlCommand("EXEC P_Sys_GetAutoCode @I_CodeName,@I_Year,@I_Month,@I_Day,@O_Code out", paramArray.ToArray());

            }

            catch (Exception ex)

            {

                throw;

            }

            return paramArray[3].Value.ToString();

        }