コード例 #1
0
        public int UpdateMoldingInfo(MoldingInfoDetailVo detail)
        {
            using (SqlCommand cmd = new SqlCommand())
            {
                cmd.Connection  = new SqlConnection(ConnectionString);
                cmd.CommandText = "UpdateMoldingInfo";
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@Code", detail.Mold_Code);
                cmd.Parameters.AddWithValue("@Name", detail.Mold_Name);
                cmd.Parameters.AddWithValue("@Group", detail.Mold_Group);
                cmd.Parameters.AddWithValue("@Price", detail.Purchase_Amt);
                cmd.Parameters.AddWithValue("@Inputdate", detail.In_Date);
                cmd.Parameters.AddWithValue("@Lastequipdate", detail.Last_Setup_Time);
                cmd.Parameters.AddWithValue("@Warrentnum", detail.Guar_Shot_Cnt);
                cmd.Parameters.AddWithValue("@PS", detail.Remark);
                cmd.Parameters.AddWithValue("@Use_YN", detail.Use_YN);

                cmd.Connection.Open();
                int result = cmd.ExecuteNonQuery();
                cmd.Connection.Close();
                return(result);
            }
        }
コード例 #2
0
        public int UpdateMoldingInfo(MoldingInfoDetailVo detail)
        {
            MoldingDac dac = new MoldingDac();

            return(dac.UpdateMoldingInfo(detail));
        }