예제 #1
0
        /// <summary>
        /// 团员转出
        /// </summary>
        /// <param name="MM_OID">团员OID</param>
        /// <param name="CYG_OID">转入团支部OID</param>
        /// <returns></returns>
        public int ChangeYG(string MM_OID, string YG_OID, string OP_ADMIN)
        {
            ChangeYGComand.Parameters[0].Value = MM_OID;
            ChangeYGComand.Parameters[1].Value = YG_OID;
            ChangeYGComand.Parameters[2].Value = OP_ADMIN;

            NotificationTableAdapter.ClearNfCache();

            return(AdapterHelper.ExecuteCommand(ChangeYGComand));
        }
예제 #2
0
        public int ChangeStatus(string MM_OID, string HrStatus)
        {
            SqlCommand comm = new SqlCommand();

            comm.Connection  = this.Connection;
            comm.CommandText = "UPDATE dbo.Member SET HrStatus = @HrStatus WHERE OID = @MM_OID";
            comm.CommandType = System.Data.CommandType.Text;

            comm.Parameters.Add("@HrStatus", System.Data.SqlDbType.NVarChar, 50);
            comm.Parameters.Add("@MM_OID", System.Data.SqlDbType.NVarChar, 50);
            comm.Parameters[0].Value = HrStatus;
            comm.Parameters[1].Value = MM_OID;

            NotificationTableAdapter.ClearNfCache();

            return(AdapterHelper.ExecuteCommand(comm));
        }