public C欠款紀錄[] get欠款紀錄明細(string p_smid, string p_type, string p_BDate, string p_EDate)
{
string l_sql = "";
//l_sql += " select * from tbInMoney where f_isclose = '" + p_type + "' and f_smid = '" + p_smid + "'";
//if (!"".Equals(p_BDate))
//{
// l_sql += " and f_editdate between '" + p_BDate + "' and '" + p_EDate + "'";
//}
//l_sql += " order by f_editdate";
l_sql += " select m.*,c.Name,p.f_memo as memo";
l_sql += " from tbInMoney m";
l_sql += " left join dbo.tbKGPartOrder p on m.f_workid = p.f_ExchangeID";
l_sql += " left join dbo.tbWork w on w.f_workid = m.f_workid";
l_sql += " left join kddb..orders o on o.EngNo = p.f_engineno";
l_sql += " left join kddb..customer c on o.customerid = c.customerid";
l_sql += " where m.f_isclose = '" + p_type + "' and m.f_smid = '" + p_smid + "'";
if (!"".Equals(p_BDate))
{
l_sql += " and m.f_editdate between '" + p_BDate + "' and '" + p_EDate + "'";
}
l_sql += " order by f_editdate";
DataView l_dv = ivContext.資料管理員.getDataViewBySql(l_sql);
C欠款紀錄[] l_datas = new C欠款紀錄[l_dv.Count];
if (l_dv != null)
{
for (int i = 0; i < l_datas.Length; i++)
{
l_datas[i] = createC欠款紀錄();
l_datas[i].單號 = l_dv[i]["f_workid"].ToString();
l_datas[i].金額 = l_dv[i]["f_money"].ToString();
l_datas[i].帳款日期 = l_dv[i]["f_editdate"].ToString();
l_datas[i].備註 = l_dv[i]["memo"].ToString();
l_datas[i].總類 = l_dv[i]["f_type"].ToString();
//2013/05/20 新增顧客姓名欄位
l_datas[i].顧客姓名 = l_dv[i]["Name"].ToString();
}
return(l_datas);
}
return(null);
}
public C欠款紀錄[] get欠款紀錄(string p_BDate, string p_EDate, string p_smid, string p_strB帳款日期, string p_strE帳款日期)
{
string l_sql = "";
l_sql += " select t.branch,i.f_smid,t.name,sum(f_money) as f_money,p.f_Point";
l_sql += " from dbo.tbInMoney i";
l_sql += " left join kdnews..T_HRPersonel t on i.f_smid = t.Emp_id ";
l_sql += " left join kg..tbKGPoint p on i.f_smid = p.f_Smid ";
l_sql += " where f_isclose = 'N'";
if (!"".Equals(p_BDate))
{
l_sql += " and i.f_fulldate between '" + p_BDate + "' and '" + p_EDate + "'";
}
if (!"".Equals(p_strB帳款日期))
{
l_sql += " and i.f_editdate between '" + p_strB帳款日期 + "' and '" + p_strE帳款日期 + "'";
}
if (!"".Equals(p_smid))
{
l_sql += " and i.f_smid = '" + p_smid + "'";
}
l_sql += " group by t.branch,i.f_smid,t.name,p.f_Point";
DataView l_dv = ivContext.資料管理員.getDataViewBySql(l_sql);
C欠款紀錄[] l_datas = new C欠款紀錄[l_dv.Count];
if (l_dv != null)
{
for (int i = 0; i < l_datas.Length; i++)
{
l_datas[i] = createC欠款紀錄();
l_datas[i].據點 = l_dv[i]["branch"].ToString();
l_datas[i].業編 = l_dv[i]["f_smid"].ToString();
l_datas[i].稱 = l_dv[i]["name"].ToString();
l_datas[i].金額 = l_dv[i]["f_money"].ToString();
l_datas[i].剩餘點數 = l_dv[i]["f_Point"].ToString();
}
return(l_datas);
}
return(null);
}
