/// <summary>
/// 根据工号获取到团员信息
/// </summary>
/// <param name="HrCode"></param>
/// <returns></returns>
public YouthOneDS.MemberDataTable GetMemberRandom()
{
YouthOneDS.MemberDataTable dataTable = new YouthOneDS.MemberDataTable();
this.Adapter.SelectCommand = GetMemberRandomComand;
this.Adapter.Fill(dataTable);
return(dataTable);
}
/// <summary>
/// 根据工号获取到团员信息
/// </summary>
/// <param name="HrCode"></param>
/// <returns></returns>
public YouthOneDS.MemberDataTable GetMember(string HrCode)
{
YouthOneDS.MemberDataTable dataTable = new YouthOneDS.MemberDataTable();
this.Adapter.SelectCommand = GetMemberHrComand;
this.Adapter.SelectCommand.Parameters[0].Value = HrCode;
this.Adapter.Fill(dataTable);
return(dataTable);
}
/// <summary>
/// 根据OID获取到团员信息
/// </summary>
/// <param name="OID"></param>
/// <returns></returns>
public YouthOneDS.MemberDataTable GetMemberByOID(string OID)
{
YouthOneDS.MemberDataTable dataTable = new YouthOneDS.MemberDataTable();
this.Adapter.SelectCommand = MySelectSqlComand;
this.Adapter.SelectCommand.Parameters[0].Value = OID;
int returnValue = this.Adapter.Fill(dataTable);
return(dataTable);
}
/// <summary>
/// 获取支部下的团员
/// </summary>
/// <param name="FZ_OID"></param>
/// <returns></returns>
public YouthOneDS.MemberDataTable GetMemberYG(string YG_OID)
{
YouthOneDS.MemberDataTable dataTable = new YouthOneDS.MemberDataTable();
this.Adapter.SelectCommand = GetYGMmeberComand;
this.Adapter.SelectCommand.Parameters[0].Value = YG_OID;
this.Adapter.Fill(dataTable);
return(dataTable);
}
/// <summary>
/// 根据工号创建报表
/// </summary>
/// <param name="hrCode"></param>
private void CreateReport(string hrCode)
{
YouthOneDS.MemberDataTable mmTable = mmAdapter.GetMember(hrCode);
if (mmTable.Rows.Count > 0)
{
if (AuthUser.RoleName == AuthenUserType.TZB_Admin && mmTable.Rows[0]["FK_YouthGroup"].ToString() != AuthUser.YouthGroup)
{
AlertJS("此团员非本支部，无法查看其信息！");
return;
}
BindingReport(mmTable.Rows[0]["OID"].ToString());
}
}
public int Fill(YouthOneDS.MemberDataTable dataTable, string memberOID)
{
this.Adapter.SelectCommand = MySelectSqlComand;
this.Adapter.SelectCommand.Parameters[0].Value = memberOID;
if ((this.ClearBeforeFill == true))
{
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return(returnValue);
}
/// <summary>
/// 查询员工
/// </summary>
/// <param name="HrCode"></param>
/// <returns></returns>
public YouthOneDS.MemberDataTable SearchMember(string YG_OID, string FZ_OID, string SH_TEXT, string SH_LB)
{
FZ_OID = FZ_OID ?? string.Empty;
SH_TEXT = SH_TEXT ?? string.Empty;
YouthOneDS.MemberDataTable dataTable = new YouthOneDS.MemberDataTable();
GetSearchMemberComand.Parameters[0].Value = YG_OID;
GetSearchMemberComand.Parameters[1].Value = FZ_OID;
GetSearchMemberComand.Parameters[2].Value = SH_TEXT;
GetSearchMemberComand.Parameters[3].Value = SH_LB;
this.Adapter.SelectCommand = GetSearchMemberComand;
this.Adapter.Fill(dataTable);
return(dataTable);
}
