public void ReturnItemsData()
{
Grid2.Visible = true;
r.ExcecuteQuery("Select ROW_NUMBER() over(order by t1.Item) as IndexNo, *from PurchaseTable t1 inner join ProductTable t2 on t1.Item = t2.P_name inner join PurchaseInvoiceTable t3 on t1.PurchaseNo = t3.P_No where t3.P_InvoiceNo = '" + txtPInvoiceNo.Text + "'");
Grid2.DataSource = r.ds;
Grid2.DataBind();
}
private Grid2 <SpriteCell> CreateGrid()
{
var dimensions = gridDimensions.GetGridPoint();
var shape = ExplicitShape.Hex.FlatFatRectangle(dimensions);
var grid = new Grid2 <SpriteCell>(shape);
return(grid);
}
/// <summary>
/// 子表保存
/// </summary>
/// <returns></returns>
public string DetailEdit()
{
JArray jarr = Grid2.GetMergedData();
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
string result = "";
int n = 0;
for (int i = 0; i < jarr.Count; i++)
{
try
{
var model2 = new IN_BACK01();
//string str = jarr[i]["status"].ToString();
if (jarr[i]["status"].ToString().Equals("modified"))
{
model2.SetIsNew(false);
}
else if (jarr[i]["status"].ToString().Equals("unchanged"))
{
continue;
}
else
{
model2.SetIsNew(true);
}
model2.SHOP_ID = jarr[i]["values"]["SHOP_ID01"].ToString();
if (!String.IsNullOrEmpty(jarr[i]["values"]["IB_ID01"].ToString()))
{
model2.IB_ID = jarr[i]["values"]["IB_ID01"].ToString();
}
else
{
return("保存失败");
}
model2.SNo = ConvertHelper.Cint(jarr[i]["values"]["SNo01"].ToString());
model2.PROD_ID = jarr[i]["values"]["PROD_ID01"].ToString();
model2.QUANTITY = ConvertHelper.StringToDecimal(jarr[i]["values"]["QUANTITY01"].ToString());
model2.STD_TYPE = jarr[i]["values"]["STD_TYPE01"].ToString();
model2.STD_UNIT = jarr[i]["values"]["STD_UNIT01"].ToString();
model2.STD_CONVERT = ConvertHelper.Cint(jarr[i]["values"]["STD_CONVERT01"].ToString());
model2.STD_QUAN = ConvertHelper.StringToDecimal(jarr[i]["values"]["STD_QUAN01"].ToString());
model2.STD_PRICE = ConvertHelper.StringToDecimal(jarr[i]["values"]["STD_PRICE01"].ToString());
model2.COST = ConvertHelper.StringToDecimal(jarr[i]["values"]["COST01"].ToString());
model2.QUAN1 = ConvertHelper.StringToDecimal(jarr[i]["values"]["QUAN101"].ToString());
model2.QUAN2 = ConvertHelper.StringToDecimal(jarr[i]["values"]["QUAN201"].ToString());
model2.MEMO = jarr[i]["values"]["MEMO01"].ToString();
model2.BAT_NO = jarr[i]["values"]["BAT_NO"].ToString();
model2.Exp_DateTime = DateTime.Now;
IN_BACK01Bll.GetInstence().Save(this, model2);
}
catch (Exception err)
{
n++;
result = "明细保存失败" + n + "条";
}
}
return(result);
}
//ERP查询结果
private void bindGrid(string tradeNo)
{
string sqlCmd = "select * from View_PLM_ERPData where orderNo like '%" + tradeNo + "%' order by planProdDate desc";
DataTable dt = new DataTable();
SqlSel.GetSqlSel(ref dt, sqlCmd);
Grid2.DataSource = dt;
Grid2.DataBind();
}
/// <summary>
/// 反选选中行复选框的状态
/// </summary>
/// <param name="selected"></param>
private void UnSelectAllSelected()
{
int[] selectedIndexs = Grid2.SelectedRowIndexArray;
for (int i = 0; i < selectedIndexs.Length; i++)
{
UnSelectAllInRowIndex(selectedIndexs[i]);
}
Grid2.UpdateTemplateFields();
}
private Grid2 <char> DoStep(Grid2 <char> map, out bool changed)
{
Grid2 <char> east = DoEastStepPart(map, out bool eastChanged);
Grid2 <char> south = DoSouthStepPart(east, out bool southChanged);
changed = eastChanged || southChanged;
return(south);
}
private void BindGrid()
{
Grid1.DataSource = GetDataTable1();
Grid1.DataBind();
Grid2.DataSource = GetDataTable2();
Grid2.DataBind();
Grid3.DataSource = GetDataTable3();
Grid3.DataBind();
}
private Grid2 <SpriteCell> CreateGrid()
{
var dimensions = gridDimensions.GetGridPoint();
var shape = ImplicitShape.Parallelogram(dimensions);
var storage = shape.ToExplicit(new GridRect(GridPoint2.Zero, dimensions));
var grid = new Grid2 <SpriteCell>(storage);
return(grid);
}
public MoveUp2(Grid2 gd, Block2 bc)
{
this.gd = gd;
bc.transform.RotateAround(bc.transform.TransformPoint(Block.rotationPoint), new Vector3(0, 0, 1), 90);
if (!ValidMove(bc.transform))
{
bc.transform.RotateAround(bc.transform.TransformPoint(Block.rotationPoint), new Vector3(0, 0, 1), -90);
}
}
private void ProjBind(string projStatus)
{
string sqlCmd = "select * from OA_sys_Project where ProjStatus='" + projStatus + "'";
DataTable dt = new DataTable();
SqlSel.GetSqlSel(ref dt, sqlCmd);
Grid2.DataSource = dt;
Grid2.DataBind();
}
private void BindGrid2()
{
if (Grid1.Rows.Count == 0)
{
Grid2.RecordCount = 0;
Grid2.DataSource = null;
Grid2.DataBind();
return;
}
//Alert.Show(Grid2.SelectedRowIndex.ToString());
if (Grid1.SelectedRowIndex < 0 || Grid1.Rows.Count <= 0)
{
return;
}
using (var appdb = new AppContext())
{
int pid = int.Parse(Grid1.DataKeys[Grid1.SelectedRowIndex][0].ToString());// GetSelectedDataKeyID(Grid1).ToString();
var inq = from a in appdb.sendoutprocessdetail
//join b in appdb.sendoutprocessheader on a.SendOutOrderNo equals b.PurOrderNo
where a.FSN == pid
select a;
//IQueryable<YW_ProcessRec> q = appdb.processRec; //.Include(u => u.Dept);
// 在用户名称中搜索
string searchText = TwinTriggerBox2.Text.Trim();
if (!String.IsNullOrEmpty(searchText))
{
inq = inq.Where(u => u.ItemNo.Contains(searchText) || u.ItemName.Contains(searchText));
}
// 进仓 出仓
//日期 筛选
if (DateFrom.SelectedDate.HasValue)
{
inq = inq.Where(u => u.InputeDate >= DateFrom.SelectedDate);
}
if (DateTo.SelectedDate.HasValue)
{
inq = inq.Where(u => u.InputeDate <= DateTo.SelectedDate);
}
// 在查询添加之后，排序和分页之前获取总记录数
Grid2.RecordCount = inq.Count();// q.Count();
// 排列和数据库分页
inq = SortAndPage <SendOutProcessDetail>(inq, Grid2);
Grid2.DataSource = inq;// itemq.Take(2);// q;
Grid2.DataBind();
}
}
/// <summary>
/// 添加商品，采购单位未完成，价格取值未完成，税额未完成
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ButtonPRODAdd_Click(object sender, EventArgs e)
{
FineUI.Grid Grid4 = Window3.FindControl("PanelGrid4").FindControl("Grid4") as FineUI.Grid;
int[] selections = Grid4.SelectedRowIndexArray;
string _TAKEIN_ID = tbxTAKEIN_ID.Text;
string _Shop_ID = ddlSHOP_NAME.SelectedValue;
string _Shop_Name = ddlSHOP_NAME.SelectedText;
string result = "";
var m_Shop = new SHOP00(x => x.SHOP_ID == _Shop_ID);
string _priceArea_id = m_Shop.SHOP_Price_Area;
if (!String.IsNullOrEmpty(_TAKEIN_ID))
{
foreach (int i in selections)
{
string _Prod_ID = Grid4.DataKeys[i][0].ToString();
string _shop_id = ddlSHOP_NAME.SelectedValue;
var model = new V_Product01_PRCAREA(x => x.PROD_ID == _Prod_ID && x.PRCAREA_ID == _priceArea_id);
int rowCount = Grid2.Rows.Count;
JObject deObject = new JObject();
deObject.Add("Id01", "0");
deObject.Add("SHOP_ID01", _Shop_ID);
deObject.Add("SHOP_NAME01", _Shop_Name);
deObject.Add("TAKEIN_ID01", _TAKEIN_ID);
deObject.Add("SNo01", rowCount + 1);
deObject.Add("PROD_ID01", _Prod_ID);
deObject.Add("PROD_NAME01", model.PROD_NAME1);
deObject.Add("QUANTITY01", model.ORDER_QUAN);
deObject.Add("STD_UNIT01", model.Purchase_UNIT);
deObject.Add("STD_CONVERT01", model.PROD_CONVERT1);
deObject.Add("STD_QUAN01", model.Purchase_QUAN);
deObject.Add("STD_PRICE01", model.COST);
deObject.Add("Tax01", 0);
deObject.Add("QUAN101", 0);
deObject.Add("QUAN201", 0);
deObject.Add("Item_DISC_Amt01", 0);
deObject.Add("MEMO", "");
deObject.Add("BAT_NO", "");
//var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
//string lgname = OlUser.Manager_LoginName;
//deObject.Add("CRT_USER_ID1", lgname);
//deObject.Add("CRT_DATETIME1", DateTime.Now.ToString());
//deObject.Add("MOD_USER_ID1", OlUser.Manager_LoginName);
//deObject.Add("MOD_DATETIME1", DateTime.Now.ToString());
Grid2.AddNewRecord(deObject, true);
}
}
else
{
FineUI.Alert.ShowInParent("未选中订单无法添加", FineUI.MessageBoxIcon.Information);
}
if (!String.IsNullOrEmpty(result.Trim()))
{
FineUI.Alert.ShowInParent(result, FineUI.MessageBoxIcon.Information);
}
}
//列举部门信息
private void BindGrid2()
{
string sqlCmd = "select * from OA_sys_department";
DataTable dt = new DataTable();
SqlSel.GetSqlSel(ref dt, sqlCmd);
Grid2.DataSource = dt;
Grid2.DataBind();
}
protected void BindGrid2()
{
DataSet ds = null;
ds = ORDER00Bll.GetInstence().Get_ORDER01_PRODUCT00_PRODUCT01_("5", "");
Grid2.DataSource = ds;
Grid2.DataBind();
}
//待处置库类别
protected void 类别_SelectedIndexChanged(object sender, EventArgs e)
{
string flowstate = 类别.SelectedValue;
DataSet ds = bll.待处置库查询(flowstate);
DataTable dt = ds.Tables[0].Copy(); //复制一份table
Grid2.DataSource = dt; //DataTable
Grid2.DataBind();
}
//
protected void btnCheckSelection_Click(object sender, EventArgs e)
{
Window1.Hidden = false;
DataSet ds = bll.待处置库查询("待报废");
DataTable dt = ds.Tables[0].Copy(); //复制一份table
Grid2.DataSource = dt; //DataTable
Grid2.DataBind();
}
public MoveRight2(Grid2 gd, Block2 bc)
{
this.gd = gd;
bc.transform.position += new Vector3(-1, 0, 0);
if (!ValidMove(bc.transform))
{
bc.transform.position -= new Vector3(-1, 0, 0);
}
}
private void bindGrid2(string flowId)
{
string sqlCmd = "select * from OA_Sys_Flow_Step where flowId='" + flowId + "' order by stepOrderNo";
DataTable dt = new DataTable();
SqlSel.GetSqlSel(ref dt, sqlCmd);
Grid2.DataSource = dt;
Grid2.DataBind();
}
protected void Grid1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Edit")
{
lblError.Visible = false;
pnlSort.Visible = false;
}
if (e.CommandName == "Delete")
{
string sGroup = ddlGroups.SelectedValue.ToString();
lblError.Visible = false;
pnlSort.Visible = false;
int iReturn = 0;
if (Grid1.Rows.Count > 0)
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow row = Grid1.Rows[index];
int Task = Convert.ToInt32(Grid1.DataKeys[row.RowIndex].Value.ToString());
string sVcode = row.Cells[1].Text;
iReturn = mtVendor.DeleteVendorsGroups(sVcode, sGroup);
}
if (iReturn == 0)
{
lblError.Visible = true;
lblError.Text = "Item can't be removed!";
}
else
{
lblError.Visible = false;
Grid1.DataSource = mtVendor.GetUsedVendors(sGroup);
Grid1.DataBind();
Grid2.DataSource = mtVendor.GetNotUsedVendors(sGroup);
Grid2.DataBind();
}
}
//if (e.CommandName == "Update")
//{
// //int R, T;
// string R = ddlGroups.SelectedValue.ToString();
// //T = Convert.ToInt32(ddlTypes.SelectedValue);
// lblError.Visible = false;
// int index = Convert.ToInt32(e.CommandArgument);
// GridViewRow row = Grid1.Rows[index];
// int Task = Convert.ToInt32(Grid1.DataKeys[row.RowIndex].Value.ToString());
// RadMaskedTextBox RptOrder = Grid1.Rows[index].FindControl("RptOrder") as RadMaskedTextBox;
// int iRptOrder = Convert.ToInt32(RptOrder.Text);
// //GroupMaster.UpdateTaskTypeReport(Task, R, T, iRptOrder);
//}
}
/// <summary>
/// 添加商品，采购单位未完成，价格取值未完成，税额未完成
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ButtonPRODAdd_Click(object sender, EventArgs e)
{
FineUI.Grid Grid4 = Window3.FindControl("PanelGrid4").FindControl("Grid4") as FineUI.Grid;
int[] selections = Grid4.SelectedRowIndexArray;
string _tbxPREPAR_ID = tbxPREPAR_ID.Text;
string _Shop_ID = ddlSHOP_NAME.SelectedValue;
string _Shop_Name = ddlSHOP_NAME.SelectedText;
string result = "";
var m_Shop = new SHOP00(x => x.SHOP_ID == _Shop_ID);
string _priceArea_id = m_Shop.SHOP_Price_Area;
if (!String.IsNullOrEmpty(_tbxPREPAR_ID))
{
foreach (int i in selections)
{
string _Prod_ID = Grid4.DataKeys[i][0].ToString();
string _shop_id = ddlSHOP_NAME.SelectedValue;
var model = new V_Product01_PRCAREA(x => x.PROD_ID == _Prod_ID && x.PRCAREA_ID == _priceArea_id);
int rowCount = Grid2.Rows.Count;
JObject deObject = new JObject();
deObject.Add("Id01", "0");
deObject.Add("SHOP_ID01", _Shop_ID);
deObject.Add("SHOP_NAME01", _Shop_Name);
deObject.Add("PREPARE_ID01", _tbxPREPAR_ID);
deObject.Add("SNo01", rowCount + 1);
deObject.Add("PROD_ID01", _Prod_ID);
deObject.Add("PROD_NAME01", model.PROD_NAME1);
deObject.Add("QUANTITY01", model.ORDER_QUAN);
deObject.Add("STD_UNIT01", 0);
deObject.Add("STD_CONVERT01", 0);
deObject.Add("STD_QUAN01", 0);
deObject.Add("STD_PRICE01", 0);
deObject.Add("COST01", "");
deObject.Add("sProd_ID01", "");
deObject.Add("BAT_NO01", "");
deObject.Add("IsScales01", 0);
deObject.Add("IsFlag01", 0);
deObject.Add("Scales_User01", "");
deObject.Add("Scale_Date01", DateTime.Now.ToString());
deObject.Add("MEMO01", "");
Grid2.AddNewRecord(deObject, true);
}
}
else
{
FineUI.Alert.ShowInParent("未选中订单无法添加", FineUI.MessageBoxIcon.Information);
}
if (!String.IsNullOrEmpty(result.Trim()))
{
FineUI.Alert.ShowInParent(result, FineUI.MessageBoxIcon.Information);
}
}
private void BindGrid2()
{
if (Grid1.Rows.Count == 0)
{
Grid2.RecordCount = 0;
Grid2.DataSource = null;
Grid2.DataBind();
return;
}
if (Grid1.SelectedRowIndex < 0 || Grid1.Rows.Count <= 0)
{
return;
}
using (var appdb = new AppContext())
{
string ProOrderNo = Grid1.DataKeys[Grid1.SelectedRowIndex][1].ToString();
//生产扫描明细 左关联 生产明细
var inq = from a in appdb.produceOrderRec
join b in appdb.produceorderdetail
on a.ProduceOrderDetailSn equals b.SN
into a_join
from b in a_join.DefaultIfEmpty()
where b.ProOrderNo == ProOrderNo
select new
{
a.SN,
a.Role,
a.State,
a.optdate,
Quantity = a.Quantity == null?0:a.Quantity,
a.result,
a.choujianqut,
b.ProPlanNo,
b.ProOrderNo,
b.SaleOrderNo,
b.ProNo,
b.ItemNo,
b.ItemName,
b.Spec,
b.WorkShop,
};
// 在查询添加之后，排序和分页之前获取总记录数
Grid2.RecordCount = inq.Count();// q.Count();
// 排列和数据库分页
inq = SortAndPage(inq, Grid2);
Grid2.DataSource = inq;// itemq.Take(2);// q;
Grid2.DataBind();
}
}
/// <summary>
/// Grid1点击事件
/// </summary>
/// <param name="e"></param>
public override void SingleClick(GridRowClickEventArgs e)
{
int o = e.RowIndex;
string[] eCell = Grid1.SelectedCell;
//string aa = Grid1.SelectedRowID;
//int cc = Grid1.SelectedRowIndex;
JArray upJson = Grid1.GetMergedData();
JArray upJson2 = Grid2.GetMergedData();
//(Grid1.FindColumn("ORDDEP_NAME").FindControl("tbxORDDEP_ID") as TextBox).Enabled = true;
if (o >= 0)
{
int dataIndex = 0;
///通过点击得行数，找到数据
for (int i = 0; i < upJson.Count; i++)
{
if (upJson[i]["id"].ToString() == eCell[0].ToString())
{
dataIndex = i;
break;
}
}
hidORDDEP_ID.Text = upJson[dataIndex]["values"]["ORDDEP_ID"].ToString();
if (upJson.Count > 0 && upJson2.Count > 0)
{
if (upJson[dataIndex]["values"]["ORDDEP_ID"].ToString() != upJson2[0]["values"]["ORDDEP_ID1"].ToString())
{
string result = OrderDep02Save();
if (!String.IsNullOrEmpty(result))
{
FineUI.Alert.ShowInParent("订货类别保存失败:" + result, FineUI.MessageBoxIcon.Information);
}
int _Id = ConvertHelper.Cint(Grid1.DataKeys[dataIndex][0].ToString());
var model = new ORDER_DEP00(x => x.Id == _Id);
LoadData2(model.ORDDEP_ID);
LoadOrderDep01(model.ORDDEP_ID);
}
}
else
{
int _Id = ConvertHelper.Cint(Grid1.DataKeys[o][0].ToString());
var model = new ORDER_DEP00(x => x.Id == _Id);
LoadData2(model.ORDDEP_ID);
LoadOrderDep01(model.ORDDEP_ID);
//LoadData2(model.COM_ID);
//hidCOM_ID.Text = model.COM_ID;
}
}
else
{
hidORDDEP_ID.Text = "";
LoadData2("");
LoadOrderDep01("");
}
}
private void CargarPermisos(DataTable permisos)
{
bool marcarTodo = true;
//Marca los permisos
if (permisos != null)
{
foreach (DataRow renglonPermiso in permisos.Rows)
{
for (int i = 0; i < Grid2.VisibleRowCount; i++)
{
if (renglonPermiso["IdModulo"].ToString().Equals(Grid2.GetRowValues(i, "IdModulo").ToString()))
{
ASPxCheckBox chkTodo = Grid2.FindRowCellTemplateControl(i, (GridViewDataColumn)Grid2.Columns["Todo"], "chkTodo") as ASPxCheckBox;
ASPxCheckBox chkConsultar = Grid2.FindRowCellTemplateControl(i, (GridViewDataColumn)Grid2.Columns["Consultar"], "chkConsultar") as ASPxCheckBox;
ASPxCheckBox chkAgregar = Grid2.FindRowCellTemplateControl(i, (GridViewDataColumn)Grid2.Columns["Agregar"], "chkAgregar") as ASPxCheckBox;
ASPxCheckBox chkEditar = Grid2.FindRowCellTemplateControl(i, (GridViewDataColumn)Grid2.Columns["Editar"], "chkEditar") as ASPxCheckBox;
ASPxCheckBox chkEliminar = Grid2.FindRowCellTemplateControl(i, (GridViewDataColumn)Grid2.Columns["Eliminar"], "chkEliminar") as ASPxCheckBox;
ASPxCheckBox chkExportar = Grid2.FindRowCellTemplateControl(i, (GridViewDataColumn)Grid2.Columns["Exportar"], "chkExportar") as ASPxCheckBox;
//Marca los permisos visibles (habilitados por Acción)
chkAgregar.Checked = chkAgregar.Visible ? Convert.ToBoolean(renglonPermiso["Agregar"]) : false;
chkConsultar.Checked = chkConsultar.Visible ? Convert.ToBoolean(renglonPermiso["Consultar"]) : false;
chkEditar.Checked = chkEditar.Visible ? Convert.ToBoolean(renglonPermiso["Editar"]) : false;
chkEliminar.Checked = chkEliminar.Visible ? Convert.ToBoolean(renglonPermiso["Eliminar"]) : false;
chkExportar.Checked = chkExportar.Visible ? Convert.ToBoolean(renglonPermiso["Exportar"]) : false;
//Si todos los permisos visibles de un modulo están marcados, marca el checkbox Todos
chkTodo.Checked =
(chkAgregar.Visible ? chkAgregar.Checked : true) &&
(chkConsultar.Visible ? chkConsultar.Checked : true) &&
(chkEditar.Visible ? chkEditar.Checked : true) &&
(chkEliminar.Visible ? chkEliminar.Checked : true) &&
(chkExportar.Visible ? chkExportar.Checked : true);
break;
}
}
}
}
//Valida checkbox Todo esta activo en todos los permisos
for (int i = 0; i < Grid2.VisibleRowCount; i++)
{
if (marcarTodo)
{
ASPxCheckBox chkTodo = Grid2.FindRowCellTemplateControl(i, (GridViewDataColumn)Grid2.Columns["Todo"], "chkTodo") as ASPxCheckBox;
marcarTodo = chkTodo.Checked;
}
}
CbxMarcarTodo.Checked = marcarTodo; //Asigna valor a checkbox Marcar Todo de la validación checkbox Todo en todos los permisos
CbxMarcarTodo.Enabled = true;
IcoMarcarTodo.Attributes["class"] = CbxMarcarTodo.Checked ? "glyphicon glyphicon-check" : "glyphicon glyphicon-unchecked";
LblMarcarTodo.Attributes["class"] = "btn btn-primary btn-sm"; //Habilita checkbox Marcar Todo
}
public void Setup()
{
AltEntitySync.Init(1, (id) => 500, _ => true,
(threadCount, repository) => new MockNetworkLayer(threadCount, repository),
(entity, threadCount) => (entity.Id % threadCount),
(entityId, entityType, threadCount) => (entityId % threadCount),
(id) => new Grid(50_000, 50_000, 100, 10_000, 10_000),
new IdProvider());
grid2 = new Grid2(50_000, 50_000, 100, 10_000, 10_000);
}
private void BindGrid2(string TradeId)
{
string sqlCmd = "select t1.recId,cast(t1.sellCount as int) as sellCount,t2.GoodsNo,t2.GoodsName from G_SellBack_GoodsList t1 " +
"left join g_goods_goodsList t2 on cast(t1.goodsid as int)=t2.goodsid where tradeId='" + TradeId + "'";
DataTable dt = new DataTable();
SqlSel.GetSqlSel(ref dt, sqlCmd);
Grid2.DataSource = dt;
Grid2.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Grid1.DataSource = (DataTable)Session["errdt"]; // itemq.Take(2);// q;
Grid1.DataBind();
Grid2.DataSource = (DataTable)Session["errwldt"]; // itemq.Take(2);// q;
Grid2.DataBind();
}
}
public void Part1()
{
ParseResult input = ParseInput();
Grid2 <bool> foldedGrid = Fold(input.Grid, input.Folds[0]);
long result = foldedGrid.Count(x => x);
Assert.Equal(592, result);
}
private void bindHidden(string formId, string tabName)
{
StringBuilder sb = new StringBuilder();
string sqlCmd = "select * from OA_Sys_files where formID='" + formId + "' and formDataName='" + tabName + "'";
DataTable dt = new DataTable();
SqlSel.GetSqlSel(ref dt, sqlCmd);
Grid2.DataSource = dt;
Grid2.DataBind();
}
private void BindGrid()
{
DataSet ds = bll.查询全部资产信息();
DataTable dt = ds.Tables[0].Copy();//复制一份table
DataTable source = dt;
// 3.绑定到Grid
Grid2.DataSource = dt;//DataTable
Grid2.DataBind();
}
private void BindGrid()
{
DataTable table = GetDataTable();
DataTable table2 = GetDataTable2();
Grid1.DataSource = table;
Grid1.DataBind();
Grid2.DataSource = table2;
Grid2.DataBind();
}
