/// <summary>
///
/// </summary>
private void BindDataGrid()
{
//退货明细
var source = SqlService.Where(string.Format(@"SELECT * FROM dbo.vm_SalesReturnDetails WHERE keyId='{0}' and FCompanyId={1}", lblKeyId.Text, CurrentUser.AccountComId));
//绑定数据源
Grid1.DataSource = source;
Grid1.DataBind();
var table = source.Tables[0];
if (table != null && table.Rows.Count > 0)
{
decimal sumFQty = 0.00M;
decimal sumFAmount = 0.00M;
for (int i = 0; i < table.Rows.Count; i++)
{
sumFQty += Convert.ToDecimal(table.Rows[i]["FQty"]);
sumFAmount += Convert.ToDecimal(table.Rows[i]["FAmount"]);
}
var summary = new JObject
{
{ "FItemCode", "合计" },
{ "FQty", sumFQty },
{ "FAmount", sumFAmount }
};
Grid1.SummaryData = summary;
}
//单据状态
//----------------------------------------------------------
var dataStatus = SqlService.Where(string.Format(@"SELECT FId
,KeyId
,a.FCompanyId
,FDeptId
,b.org_name FDeptName
,FOperator
,FDate
,FActionName
,FMemo
FROM dbo.LHBillStatus a
LEFT JOIN dbo.base_orgnization b ON a.FDeptId=b.id WHERE KeyId='{0}' and a.FCompanyId={1}", lblKeyId.Text, CurrentUser.AccountComId));
//绑定数据源
Grid2.DataSource = dataStatus;
Grid2.DataBind();
//审批流程过程
//----------------------------------------------------------
var dataFlow = SqlService.Where(string.Format(@"SELECT FId
,KeyId
,a.FCompanyId
,FDeptId
,b.org_name FDeptName
,FOperator
,FDate
,FMemo
FROM dbo.LHBillFlow a
LEFT JOIN dbo.base_orgnization b ON a.FDeptId=b.id WHERE KeyId='{0}' and a.FCompanyId={1}", lblKeyId.Text, CurrentUser.AccountComId));
//绑定数据源
Grid3.DataSource = dataFlow;
Grid3.DataBind();
//中间变更日志
//----------------------------------------------------------
var log = SqlService.Where(string.Format(@"SELECT * FROM dbo.vm_SalesReturnDetailsLog a WHERE keyId='{0}' and FCompanyId={1}", lblKeyId.Text, CurrentUser.AccountComId));
//绑定数据源
Grid4.DataSource = log;
Grid4.DataBind();
}
//实现从grid1往grid3添加选中人员的方法
protected void addRow()
{
//初始化datatable，遍历当前grid3的所有数据并存放进去
DataTable curdt = new DataTable();
curdt.Columns.Add("id");
curdt.Columns.Add("chineseName");
for (int j = 0; j < Grid3.Rows.Count; j++)
{
DataRow dr = curdt.NewRow();
dr[0] = Grid3.DataKeys[j][0];
dr[1] = Grid3.Rows[j].Values[0];
curdt.Rows.Add(dr);
}
//再遍历grid1选定行的数据，添加到datatable
int[] selections = Grid1.SelectedRowIndexArray;
foreach (int rowIndex in selections)
{
String selectedUserId = null;
String selectedName = null;
int find = -1;
selectedUserId = Grid1.DataKeys[rowIndex][0].ToString();
selectedName = Grid1.Rows[rowIndex].Values[1].ToString();
//去除重复选中的人员
for (int j = 0; j < curdt.Rows.Count; j++)
{
if (curdt.Rows[j]["id"].ToString() == selectedUserId)
{
find = j;
}
}
if (find >= 0)
{
continue;
}
DataRow dr = curdt.NewRow();
dr[0] = selectedUserId;
dr[1] = selectedName;
curdt.Rows.Add(dr);
}
Grid3.DataSource = curdt;
Grid3.DataBind();
//int selectedCount = Grid1.SelectedRowIndexArray.Length;
//if (selectedCount > 0)
//{
// String selectedUserId = null;
// String selectedName = null;
// for (int i = 0; i < selectedCount; i++)
// {
// int find = -1;
// int rowIndex = Grid1.SelectedRowIndexArray[i];
// selectedUserId = Grid1.DataKeys[Grid1.SelectedRowIndexArray[i]][0].ToString();
// selectedName = Grid1.Rows[i].Values[1].ToString();
// //去除重复选中的人员
// for (int j = 0; j < curdt.Rows.Count; j++)
// {
// if (curdt.Rows[j]["id"].ToString() == selectedUserId)
// {
// find = j;
// }
// }
// if (find >= 0)
// {
// continue;
// }
// DataRow dr = curdt.NewRow();
// dr[0] = selectedUserId;
// dr[1] = selectedName;
// curdt.Rows.Add(dr);
// }
// //最后重新绑定datatable，实现动态添加的功能
// Grid3.DataSource = curdt;
// Grid3.DataBind();
//}
//else
//{
// Alert.ShowInTop("请选择至少一名人员。");
//}
}
//点击查看详情
protected void Grid1_RowCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "Action1")
{
OffSession();
string username = Session["姓名"].ToString();
流程状态待派单.Hidden = false;
object[] keys = Grid1.DataKeys[e.RowIndex];
int ID = Convert.ToInt32(keys[0].ToString());//获取ID
int Sort = Convert.ToInt32(keys[9].ToString());
string 流程状态 = keys[1].ToString();
if (流程状态 == "待派单")
{
Button9.Text = "派单";
}
else if (流程状态 == "已派单，维修中")
{
Button9.Text = "派单并报修";
}
else if (流程状态 == "已完工，待反馈")
{
Button9.Text = "结果反馈";
}
xx.Text = ID.ToString();
查看报修人.Text = keys[3].ToString();
查看报修时间.Text = keys[4].ToString();
查看单号.Text = keys[2].ToString();
查看报修地址.Text = keys[5].ToString();
string zt = keys[1].ToString();
SchoolX_资产报修流程表 model = bll.详情(ID);
if (model.派单时间 != "" && model.派单时间 != null)
{
TextBox9.Text = model.派单时间;
}
else
{
TextBox9.Text = "未完成";
}
TextBox5.Text = "未完成";
TextBox6.Text = "未完成";
TextBox8.Text = "未完成";
TextBox9.Text = "未完成";
TextBox10.Text = "未完成";
TextBox11.Text = "未完成";
TextBox12.Text = "未完成";
查看故障描述.Text = "未完成";
TextBox13.Text = "未完成";
if (model.维修人员 != "" & model.维修人员 != null)
{
TextBox5.Text = model.维修人员;
}
if (model.维修人电话 != "" && model.维修人电话 != null)
{
TextBox11.Text = model.维修人电话;
}
if (model.解决时间 != "" && model.解决时间 != null)
{
TextBox6.Text = model.解决时间;
}
if (model.管理员 != "" && model.管理员 != null)
{
TextBox8.Text = model.管理员;
}
if (model.派单时间 != "" && model.派单时间 != null)
{
TextBox9.Text = model.派单时间;
}
if (model.报修人电话 != "" && model.报修人电话 != null)
{
TextBox10.Text = model.报修人电话;
}
if (model.维修人电话 != "" && model.维修人电话 != null)
{
TextBox11.Text = model.维修人电话;
}
if (model.管理员电话 != "" && model.管理员电话 != null)
{
TextBox12.Text = model.管理员电话;
}
if (model.结果反馈 != "" && model.结果反馈 != null)
{
TextBox13.Text = model.结果反馈;
}
if (model.故障原因 != "" && model.故障原因 != null)
{
查看故障描述.Text = model.故障原因;
}
if (zt == "已完成")
{
Button9.Hidden = true;
Button3.Text = "取消";
}
else if (zt == "待派单")
{
Button9.Hidden = false;
Button3.Text = "拒绝";
}
else
{
Button9.Hidden = false;
Button3.Text = "取消";
}
try
{
string iamgeurl = keys[11].ToString();
Image2.ImageUrl = iamgeurl;
}
catch (Exception)
{
}
List <int> inlist = new List <int>();
string[] sbid = keys[12].ToString().Split(',');
foreach (string item in sbid)
{
if (item == "" || item == null)
{
break;
}
inlist.Add(Convert.ToInt32(item));
}
School资产报修BLL blla = new School资产报修BLL();
List <School办公设备信息表> listdata = blla.资产转移确定设备(inlist);
Grid3.DataSource = listdata;//DataTable
Grid3.DataBind();
}
}
