Esempio n. 1
0
 public static Int32 Update(IAndonGroup andon)
 {
     SqlParameter[] _parameter = { new SqlParameter("@Id",          andon.ID),
                                   new SqlParameter("@Decription",  andon.Description),
                                   new SqlParameter("@ToList",      andon.ToList),
                                   new SqlParameter("@CcList",      andon.CcList),
                                   new SqlParameter("@SysModifier", andon.SysModifier) };
     return(Convert.ToInt32(SqlHelper.ExecuteNonQuery(ConnectionString, "sp_AndonGroups_UpdateById", _parameter)));
 }
Esempio n. 2
0
        public static Int32 Insert(IAndonGroup andon)
        {
            SqlParameter[] _parameter = { new SqlParameter("@Group",       andon.Group),
                                          new SqlParameter("@Description", andon.Description),
                                          new SqlParameter("@ToList",      andon.ToList),
                                          new SqlParameter("@CcList",      andon.CcList),
                                          new SqlParameter("@SysCreator",  andon.Syscreator) };

            return(Convert.ToInt32(SqlHelper.ExecuteNonQuery(ConnectionString, "sp_AndonGroups_Insert", _parameter)));
        }