private string GetIncome(string number)
{
if (!string.IsNullOrEmpty(number))
{
Dst_family_situa situa = FamilySurveyHandleClass.getInstance().GetDst_family_situa(new Dictionary <string, string> {
{ "NUMBER", number }
});
if (situa != null)
{
head.SERIAL_NO = situa.SERIAL_NO;
DataTable dt = ds.ExecuteTxtDataTable(string.Format("SELECT SUM(INCOME) INCOME,COUNT(1) QTY FROM DST_FAMILY_MEMBERS WHERE SEQ_NO='{0}'", situa.SEQ_NO));
if (dt != null && dt.Rows.Count == 1)
{
head.ANNUAL_INCOME = comTran.ToDecimal(dt.Rows[0]["INCOME"].ToString());
head.MONTHLY_INCOME = (situa.FAMILY_SIZE > 0) ? Math.Round(head.ANNUAL_INCOME / situa.FAMILY_SIZE / 12, 2) : 0;
}
}
}
return(head.ANNUAL_INCOME.ToString() + "*" + head.MONTHLY_INCOME.ToString());
}
private void GetPrintData(string oid)
{
head.OID = oid;
ds.RetrieveObject(head);
head.OPINION1 = cod.GetDDLTextByValue("ddl_dst_opinion", head.OPINION1);
strGrant = GetStudentGrant(head.SEQ_NO);
GetFamilyMembers();//家庭成员
#region 民主评议推荐档次
if (head.LEVEL1 == "A")
{
strLevel1 = "▉";
strLevel2 = "□";
strLevel3 = "□";
strLevel4 = "□";
}
else if (head.LEVEL1 == "B")
{
strLevel1 = "□";
strLevel2 = "▉";
strLevel3 = "□";
strLevel4 = "□";
}
else if (head.LEVEL1 == "C")
{
strLevel1 = "□";
strLevel2 = "□";
strLevel3 = "▉";
strLevel4 = "□";
}
else if (head.LEVEL1 == "D")
{
strLevel1 = "□";
strLevel2 = "□";
strLevel3 = "□";
strLevel4 = "▉";
}
else
{
strLevel1 = "□";
strLevel2 = "□";
strLevel3 = "□";
strLevel4 = "□";
}
#endregion 民主评议推荐档次
#region 档次、意见
//二级
if (string.IsNullOrEmpty(head.LEVEL2))
{
strAgree2 = "□";
strNAgree2 = "□";
strOpinion2 = " ";
}
else
{
if (head.LEVEL1 == head.LEVEL2)
{
strAgree2 = "▉";
strNAgree2 = "□";
strOpinion2 = " ";
}
else
{
strAgree2 = "□";
strNAgree2 = "▉";
strOpinion2 = cod.GetDDLTextByValue("ddl_dst_level", head.LEVEL2);
}
}
//三级
if (string.IsNullOrEmpty(head.LEVEL3))
{
strAgree3 = "□";
strNAgree3 = "□";
strOpinion3 = " ";
}
else
{
if (head.LEVEL2 == head.LEVEL3)
{
strAgree3 = "▉";
strNAgree3 = "□";
strOpinion3 = " ";
}
else
{
strAgree3 = "□";
strNAgree3 = "▉";
strOpinion3 = cod.GetDDLTextByValue("ddl_dst_level", head.LEVEL3);
}
}
#endregion 档次、意见
#region 家庭经济特别困难勾选项
situa = FamilySurveyHandleClass.getInstance().GetDst_family_situa(new Dictionary <string, string> {
{ "NUMBER", head.NUMBER }
});
if (head.LEVEL_CODE == "A" && situa != null)
{
if (situa.IS_POOR.Equals("G") || situa.IS_POOR.Equals("O"))//农村建档立卡
{
strNCJDLK = "▉";
}
else
{
strNCJDLK = "□";
}
if (situa.IS_MINIMUM == "Y")//低保家庭
{
strDBJT = "▉";
}
else
{
strDBJT = "□";
}
if (situa.IS_ORPHAN.Equals("Y"))//孤儿
{
strguer = "▉";
}
else
{
strguer = "□";
}
if (situa.IS_DISABLED.Equals("Y"))//残疾
{
strcanji = "▉";
}
else
{
strcanji = "□";
}
if (situa.IS_OTHER.Equals("Y") || situa.IS_DESTITUTE.Equals("Y"))//其他
{
strqita = "▉";
}
else
{
strqita = "□";
}
}
else
{
strNCJDLK = "□";
strDBJT = "□";
strguer = "□";
strcanji = "□";
strqita = "□";
}
#endregion 家庭经济特别困难勾选项
}
