protected void GetInfo(List <FishEntity.CallRecordsEntity> list)
{
if (list == null)
{
return;
}
FishBll.Bll.CallRecordsDetailBll detailBll = new FishBll.Bll.CallRecordsDetailBll();
foreach (FishEntity.CallRecordsEntity item in list)
{
string bj = "";
string cg = "";
List <FishEntity.CallRecordsDetailEntnty> details = detailBll.GetModelList(" callrecordid=" + item.id);
if (details != null)
{
foreach (FishEntity.CallRecordsDetailEntnty de in details)
{
if (string.IsNullOrEmpty(bj) == false)
{
bj += "，";
}
bj += de.specification + de.quoteprice;
if (string.IsNullOrEmpty(cg) == false)
{
cg += "\r\n";
}
cg += de.orderstate + ":" + de.weight + de.specification + de.quoteprice;
}
}
item.quoteInfo = bj;
item.buyInfo = cg;
}
}
protected void GetQinfo(List <FishEntity.CallRecordsEntity> list)
{
if (list == null)
{
return;
}
//string startdate = dtpStart.Value.ToString();
//string enddate = dtpEnd.Value.ToShortDateString();
FishBll.Bll.CallRecordsDetailBll detailBll = new FishBll.Bll.CallRecordsDetailBll();
foreach (FishEntity.CallRecordsEntity item in list)
{
int count1 = 0;
int count2 = 0;
List <FishEntity.CallRecordsDetailEntnty> details = detailBll.GetRecordListByCompanyCode(item.customercode);
if (details != null)
{
string bj = "";
string cg = "";
//string datestr = "";
foreach (FishEntity.CallRecordsDetailEntnty de in details)
{
string datestr2 = de.currentdate.ToString("MM.dd");
if (count1 < 5 && de.quoteprice > 0)
{
count1++;
if (string.IsNullOrEmpty(bj) == false)
{
bj += "，\r\n";
}
bj += datestr2 + " " + de.specification + de.quoteprice + de.brand;
}
if (count2 < 5 && de.quoteprice > 0)
{
count2++;
if (string.IsNullOrEmpty(cg) == false)
{
cg += "\r\n";
}
cg += datestr2 + " " + de.orderstate + ":" + de.weight + de.specification + de.saleprice;
}
}
item.quoteInfo = bj;
item.buyInfo = cg;
}
}
}
public override int Query()
{
String where = "";
if (string.IsNullOrEmpty(txtCustomer.Text))
{
//MessageBox.Show("请选择客户名称");
//return 0;
where += " 1 = 1 ";
}
else
{
where += "customer ='" + txtCustomer.Text.Trim() + "'";
}
//if (cmbLinkman.SelectedValue != null && cmbLinkman.SelectedValue.ToString() != "-1")
//{
// where += " and linkmancode='"+ cmbLinkman.SelectedValue.ToString() +"'";
//}
//string where1 = where + " order by currentdate desc";
string linkmanstr = "";
foreach (Control ctl in panel2.Controls)
{
if (ctl is CheckBox)
{
CheckBox chk = ctl as CheckBox;
if (chk.Checked == false)
{
continue;
}
if (chk.Tag == null)
{
continue;
}
FishEntity.CustomerEntity customer = chk.Tag as FishEntity.CustomerEntity;
if (customer == null)
{
continue;
}
if (string.IsNullOrEmpty(linkmanstr) == false)
{
linkmanstr += ",";
}
linkmanstr += "'" + customer.code + "'";
}
}
if (string.IsNullOrEmpty(linkmanstr) == false)
{
where += " and linkmancode in ( " + linkmanstr + " )";
}
if (FishEntity.Variable.User.roletype.Equals(FishEntity.Constant.Role_SalesMan))
{
where += string.Format(" and createman='{0}' ", FishEntity.Variable.User.username);
}
else
{
if (cmbTheperson.SelectedValue.ToString() != " ")
{
where += string.Format(" and createman='{0}' ", cmbTheperson.SelectedValue.ToString());
}
}
if (cmbStatus.Text != null && cmbStatus.Text.ToString().Trim() != "")
{
where += " and orderstate like '%" + cmbStatus.Text.ToString().Trim() + "%'";
}
//if (cmbQuote.Text != null && cmbQuote.Text.ToString().Trim() != "")
//{
// where += " and LENGTH(bjqk)>11 ";
//}
if (cmbQuote.Text == "有报价" && cmbQuote.Text != "")
{
where += " and LENGTH(bjqk)>11";
}
else if (cmbQuote.Text == "无报价" && cmbQuote.Text != "")
{
where += " and LENGTH(bjqk)<=11";
}
if (dtsky.Text.ToString() == DateTime.Now.AddDays(1).ToString("yyyy-MM-dd"))
{
where += string.Format(" and currentdate>='{0}' and currentdate<='{1}' ",
dtpStart.Value.ToString("yyyy-MM-dd 00:00:00"),
dtpEnd.Value.ToString("yyyy-MM-dd 23:59:59"));
}
else
{
where += string.Format(" and currentdate>='{0}' and currentdate<='{1}' ", dtsky.Value.ToString("yyyy-MM-dd 00:00:00"), dtsky.Value.ToString("yyyy-MM-dd 23:59:59"));
}
FishBll.Bll.CallRecordsDetailBll bll = new FishBll.Bll.CallRecordsDetailBll();
List <FishEntity.CallRecordDetailEntityEx> records = bll.GetRecordDetailListByWhere(where + _rolewhere);
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = records;
int sum = 0;
//for (int i = 0; i < dataGridView1.RowCount; i++)
//{
sum += int.Parse(this.dataGridView1.RowCount.ToString());
// }
txtnumber.Text = sum.ToString();
if (records == null || records.Count < 1)
{
MessageBox.Show("查无数据");
}
return(base.Query());
}
