Beispiel #1
0
        public bool UpdateProcess(ProcessVo proVo)
        {
            int a = 0;

            using (SqlCommand cmd = new SqlCommand())
            {
                cmd.Connection  = new SqlConnection(ConnectionString);
                cmd.CommandText = "update Process_Master set Process_Name=@Process_Name, Process_Group=@Process_Group, Use_YN=@Use_YN, Remark=@Remark, Up_Date=@Up_Date, Up_Emp='김민우' where Process_Code=@Process_Code";
                cmd.Parameters.AddWithValue("@Process_Code", proVo.Process_Code);
                cmd.Parameters.AddWithValue("@Process_Name", proVo.Process_Name);
                cmd.Parameters.AddWithValue("@Process_Group", proVo.Process_Group);
                cmd.Parameters.AddWithValue("@Use_YN", proVo.Use_YN);
                cmd.Parameters.AddWithValue("@Remark", proVo.Remark);
                cmd.Parameters.AddWithValue("@Up_Date", DateTime.Now);
                cmd.Connection.Open();
                a = cmd.ExecuteNonQuery();

                cmd.Connection.Close();
            }
            return(a == 1 ? true : false);
        }
Beispiel #2
0
        public bool InsertProcess(ProcessVo proVo)
        {
            int a = 0;

            using (SqlCommand cmd = new SqlCommand())
            {
                cmd.Connection  = new SqlConnection(ConnectionString);
                cmd.CommandText = "Insert into Process_Master(Process_Code, Process_Name, Process_Group, Use_YN, Remark, Ins_Date, Ins_Emp, Up_Date, Up_Emp)  Values (@Process_Code, @Process_Name, @Process_Group, @Use_YN, @Remark, @Ins_Date, '김민우', @Up_Date, '김민우')";
                cmd.Parameters.AddWithValue("@Process_Code", proVo.Process_Code);
                cmd.Parameters.AddWithValue("@Process_Name", proVo.Process_Name);
                cmd.Parameters.AddWithValue("@Process_Group", proVo.Process_Group);
                cmd.Parameters.AddWithValue("@Use_YN", proVo.Use_YN);
                cmd.Parameters.AddWithValue("@Remark", proVo.Remark);
                cmd.Parameters.AddWithValue("@Ins_Date", DateTime.Now);
                cmd.Parameters.AddWithValue("@Up_Date", DateTime.Now);
                cmd.Connection.Open();
                a = cmd.ExecuteNonQuery();

                cmd.Connection.Close();
            }
            return(a == 1 ? true : false);
        }
Beispiel #3
0
        public bool UpdateProcess(ProcessVo proVo)
        {
            ProcessDAC dac = new ProcessDAC();

            return(dac.UpdateProcess(proVo));
        }
Beispiel #4
0
        public bool InsertProcess(ProcessVo proVo)
        {
            ProcessDAC dac = new ProcessDAC();

            return(dac.InsertProcess(proVo));
        }