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); } }
public int UpdateMoldingInfo(MoldingInfoDetailVo detail) { MoldingDac dac = new MoldingDac(); return(dac.UpdateMoldingInfo(detail)); }