/// <summary>
/// 计算资产处置的累计支持
/// </summary>
/// <param name="czid"></param>
/// <returns></returns>
public double GetZhiChu(String id, ZCKind kind1)
{
double sum1 = 0;
CommTable com1 = new CommTable();
List <SearchField> condition = new List <SearchField>();
if (kind1 == ZCKind.单条资产)
{
com1.TabName = "CW_Pay";
condition.Add(new SearchField("zcid", id, SearchFieldType.数值型));
}
else
{
com1.TabName = "CW_Pay1";
condition.Add(new SearchField("bid", id, SearchFieldType.数值型));
}
condition.Add(new SearchField("checktime is not null", "", SearchOperator.用户定义));
String fields = @"isnull(fee1,0)+isnull(fee2,0)+isnull(fee3,0)+isnull(fee4,0)
+isnull(fee5,0)+isnull(fee6,0)+isnull(fee7,0)+isnull(fee8,0)
+isnull(fee9,0)+isnull(fee10,0)+isnull(fee11,0)+isnull(fee12,0)
+isnull(fee13,0)+isnull(fee14,0)+isnull(fee15,0)+isnull(fee16,0)
+isnull(fee17,0)+isnull(fee18,0)+isnull(fee19,0)+isnull(fee20,0) as sum0";
DataSet ds1 = com1.SearchData(fields, condition);
foreach (DataRow dr in ds1.Tables[0].Rows)
{
sum1 = sum1 + double.Parse(dr["sum0"].ToString());
}
com1.Close();
return(sum1);
}
/// <summary>
/// 得到资产已处置的数量
/// </summary>
/// <param name="zcid">资产ID或资产包ID</param>
/// <param name="kind">类别</param>
/// <returns></returns>
public int GetZcCount(int zcid, ZCKind kind)
{
int result = 0;
CommTable com1 = new CommTable();
com1.TabName = "U_Zc2";
List <SearchField> condition = new List <SearchField>();
if (kind == ZCKind.单条资产)
{
condition.Add(new SearchField("zcid", zcid + "", SearchFieldType.数值型));
}
else
{
condition.Add(new SearchField("zcbid", zcid + "", SearchFieldType.数值型));
}
DataSet ds1 = com1.SearchData("id", condition);
if (ds1 != null && ds1.Tables[0].Rows.Count > 0)
{
result = ds1.Tables[0].Rows.Count;
}
com1.Close();
return(result);
}
/// <summary>
/// 计算资产处置的累计回款
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public double GetHuiKuan(String id, ZCKind kind1)
{
double sum1 = 0;
CommTable com1 = new CommTable();
List <SearchField> condition = new List <SearchField>();
if (kind1 == ZCKind.单条资产)
{
com1.TabName = "CW_ShouKuan";
condition.Add(new SearchField("zcid", id, SearchFieldType.数值型));
}
else
{
com1.TabName = "CW_ShouKuan1";
condition.Add(new SearchField("bid", id, SearchFieldType.数值型));
}
condition.Add(new SearchField("checktime is not null", "", SearchOperator.用户定义));
DataSet ds1 = com1.SearchData("isnull(pbj,0)+isnull(plx,0) as sum0", condition);
foreach (DataRow dr in ds1.Tables[0].Rows)
{
sum1 = sum1 + double.Parse(dr["sum0"].ToString());
}
com1.Close();
return(sum1);
}
