/// <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));
}
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));
}