private void OnBind(int index, string as_where) { ListView list = FindViewById<ListView>(Resource.Id.Replenishment_items); TextView page = FindViewById<TextView>(Resource.Id.Replenishment_Page); DataTable ldt = new DataTable(); int count = 0; string sql = @"SELECT goodsno.goo_code, goodsno.goo_no, goodsno.Goo_Type, goodsno.Goo_Mate, goodsno.goo_name, oldsaleprice.price, goodsno.Spec, goodsno.Content, goodsno.Goo_unit, '正常' as getdetail_memo, oldsaleprice.saledate FROM goodsno, oldsaleprice WHERE goodsno.goo_code = oldsaleprice.goo_code and oldsaleprice.cus_code = '" + SysVisitor.cus_code + "'"; if (!string.IsNullOrEmpty(as_where)) { sql += " and goodsno.goo_no like '%" + as_where + "%'"; sql += " or goodsno.goo_name like '%" + as_where + "%'"; sql += " or goodsno.Content like '%" + as_where + "%'"; sql += " or oldsaleprice.price like '%" + as_where + "%'"; } if (!string.IsNullOrEmpty(SysVisitor.gooTypeCode)) { sql += " and goodsno.Goo_Type = '" + SysVisitor.gooTypeCode + "'"; } ldt = SqliteHelper.ExecuteDataTable(sql, pageSize, pageIndex, ref count); if (count % 10 == 0) pageCount = count / 10; else pageCount = count / 10 + 1; page.Text = pageIndex + "/" + pageCount; System.Collections.Hashtable hash = Shopping.GetHash(true); DataTable ldt_give = ChangeHashtable.HashtableToDataTable(hash, "goo_code", "num"); if (ldt_give.Rows.Count > 0) { for (int i = 0; i < ldt_give.Rows.Count; i++) { string[] ls_list = SysVisitor.DataTableColumnsToList(ldt, "goo_code"); int location = 0; bool istrue = ls_list.Contains(ldt_give.Rows[i]["goo_code"]); foreach (string str in ls_list) { if (str == ldt_give.Rows[i]["goo_code"].ToString()) break; location++; } if (istrue) { DataRow newRow = ldt.NewRow(); foreach (DataColumn aDataColumn in ldt.Columns) { newRow[aDataColumn.ColumnName] = ldt.Rows[location][aDataColumn.ColumnName]; } newRow["getdetail_memo"] = "买赠"; newRow["price"] = "0.00"; ldt.Rows.InsertAt(newRow, location + 1); } } } string aa = baseclass.Json.DataTableToJson(ldt); aa += ""; TextView money = FindViewById<TextView>(Resource.Id.Replenishment_goo_money); ReplenishmentAdapter listItemAdapter = new ReplenishmentAdapter(this, ldt, money, pageIndex); list.Adapter = listItemAdapter; }
private void OnBind(int index, string as_where) { ListView list = FindViewById<ListView>(Resource.Id.Replenishment_items); TextView page = FindViewById<TextView>(Resource.Id.Replenishment_Page); DataTable ldt = new DataTable(); int count = 0; string sql = @"SELECT goodsno.goo_code, goodsno.goo_no, goodsno.Goo_Type, goodsno.Goo_Mate, goodsno.goo_name, oldsaleprice.price, goodsno.Spec, goodsno.Content, goodsno.Goo_unit, IFNULL(getdetail_memo, '正常') as getdetail_memo, oldsaleprice.saledate FROM goodsno, oldsaleprice WHERE goodsno.goo_code = oldsaleprice.goo_code and oldsaleprice.cus_code = '" + SysVisitor.cus_code + "'"; if (!string.IsNullOrEmpty(as_where)) { sql += "where goodsno.goo_no like '%" + as_where + "%'"; sql += "or goodsno.goo_name like '%" + as_where + "%'"; sql += "or goodsno.Goo_Type like '%" + as_where + "%'"; sql += "or goodsno.Goo_Mate like '%" + as_where + "%'"; } ldt = SqliteHelper.ExecuteDataTable(sql, pageSize, pageIndex, ref count); if (count % 10 == 0) pageCount = count / 10; else pageCount = count / 10 + 1; page.Text = pageIndex + "/" + pageCount; ReplenishmentAdapter listItemAdapter = new ReplenishmentAdapter(this, ldt); list.Adapter = listItemAdapter; }