コード例 #1
0
 /// <summary>
 /// Function to Update values in tbl_QuickLaunchItems Table
 /// </summary>
 /// <param name="infoQuickLaunchItems"></param>
 public void QuickLaunchItemsEdit(QuickLaunchItemsInfo infoQuickLaunchItems)
 {
     try
     {
         if (sqlcon.State == ConnectionState.Closed)
         {
             sqlcon.Open();
         }
         SqlCommand sqlcmd = new SqlCommand("QuickLaunchItemsEdit", sqlcon);
         sqlcmd.CommandType = CommandType.StoredProcedure;
         sqlcmd.Parameters.Add("@quickLaunchItemsId", SqlDbType.Decimal).Value = infoQuickLaunchItems.QuickLaunchItemsId;
         sqlcmd.Parameters.Add("@itemsName", SqlDbType.VarChar).Value = infoQuickLaunchItems.ItemsName;
         sqlcmd.Parameters.Add("@status", SqlDbType.Bit).Value = infoQuickLaunchItems.Status;
         sqlcmd.Parameters.Add("@extra1", SqlDbType.VarChar).Value = infoQuickLaunchItems.Extra1;
         sqlcmd.Parameters.Add("@extra2", SqlDbType.VarChar).Value = infoQuickLaunchItems.Extra2;
         sqlcmd.ExecuteNonQuery();
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
     finally
     {
         sqlcon.Close();
     }
 }
コード例 #2
0
 /// <summary>
 /// Function to Update values in tbl_QuickLaunchItems Table
 /// </summary>
 /// <param name="infoQuickLaunchItems"></param>
 public void QuickLaunchItemsEdit(QuickLaunchItemsInfo infoQuickLaunchItems)
 {
     QuickLaunchItemsSP SPQuickLaunchItems = new QuickLaunchItemsSP();
     try
     {
         SPQuickLaunchItems.QuickLaunchItemsEdit(infoQuickLaunchItems);
     }
     catch (Exception ex)
     {
         MessageBox.Show("QLIBll 2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
 }