Esempio n. 1
0
        /// <summary>
        /// 불량현상대분류 저장 및 업데이트
        /// </summary>
        /// <param name="def"></param>
        /// <returns></returns>
        public bool InsertUpdateDef_MaVO(Def_MaVO def)
        {
            try
            {
                using (SqlCommand comm = new SqlCommand())
                {
                    comm.Connection  = new SqlConnection(Connstr);
                    comm.CommandText = "InsertUpdateDef_MaVO";
                    comm.CommandType = CommandType.StoredProcedure;
                    comm.Parameters.AddWithValue("@Def_Ma_Code", def.Def_Ma_Code);
                    comm.Parameters.AddWithValue("@Def_Ma_Name", def.Def_Ma_Name);
                    comm.Parameters.AddWithValue("@Ins_Emp", def.Ins_Emp);

                    comm.Connection.Open();
                    int result = Convert.ToInt32(comm.ExecuteNonQuery());
                    comm.Connection.Close();

                    if (result > 0)
                    {
                        return(true);
                    }
                    return(false);
                }
            }
            catch
            {
                throw;
            }
        }
Esempio n. 2
0
 public bool InsertUpdateDef_MaVO(Def_MaVO def)
 {
     return(DAC.InsertUpdateDef_MaVO(def));
 }