protected void Grid1_RowCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "Action1")
{
object[] keys = Grid1.DataKeys[e.RowIndex];
int ID = Convert.ToInt32(keys[0].ToString());//获取ID
xx.Text = ID.ToString();
查看流程状态.Text = keys[1].ToString();
if (查看流程状态.Text != "待审核")
{
Button9.Enabled = false;
Button3.Enabled = false;
}
查看单据编号.Text = keys[2].ToString();
查看事项名称.Text = keys[3].ToString();
查看申请人.Text = keys[4].ToString();
查看申请日期.Text = keys[5].ToString();
查看联系方式.Text = keys[6].ToString();
DataSet ds = bll.资产转移查看详情(ID);
DataTable dt = ds.Tables[0].Copy(); //复制一份table
Grid4.DataSource = dt; //DataTable
Grid4.DataBind();
//查询现负责人等
SchoolX_资产转移改动信息表 model = bll.查询变更为(ID);
查看存放地点变更为.Text = model.现存放地点;
查看归属部门变更为.Text = model.现归属部门;
查看负责人变更为.Text = model.现负责人;
新增资产转移查看详情.Hidden = false;
}
}
public SchoolX_资产转移改动信息表 查询变更为(int ID)
{
string sql = string.Format("SELECT TOP 1 * FROM [X_资产转移改动信息表] WHERE 转移流程表ID ={0}", ID);
SqlDataReader read = DBHelper.ExecuteReader(DBHelper.ConnectionString, CommandType.Text, sql.ToString());
SchoolX_资产转移改动信息表 model = new SchoolX_资产转移改动信息表();
if (read.Read())
{
model.现存放地点 = read["现存放地点"].ToString();
model.现归属部门 = read["现归属部门"].ToString();
model.现负责人 = read["现负责人"].ToString();
}
read.Close();
return(model);
}
protected void Button1_Click(object sender, EventArgs e)
{
//获取原存放地
string sid = "";
List <int> inlist = new List <int>();
int 总数 = 0;
int 总价 = 0;
//获取grid3选中行数据
int[] selections = Grid3.SelectedRowIndexArray;
List <SchoolX_资产转移改动信息表> listmodel = new List <SchoolX_资产转移改动信息表>();
foreach (int rowIndex in selections)
{
SchoolX_资产转移改动信息表 modelx = new SchoolX_资产转移改动信息表();
int ID = Convert.ToInt32(Grid3.DataKeys[rowIndex][0]);
modelx.原存放地点 = Grid3.DataKeys[rowIndex][1].ToString();
modelx.原归属部门 = Grid3.DataKeys[rowIndex][2].ToString();
modelx.原负责人 = Grid3.DataKeys[rowIndex][3].ToString();
sid += ID.ToString() + ",";
inlist.Add(ID);
listmodel.Add(modelx);
//sb.AppendFormat("行号:{0} 用户名:{1}<br />", rowIndex + 1, Grid1.DataKeys[rowIndex][1]);
}
List <School办公设备信息表> listdata = bll.资产转移确定设备(inlist);
foreach (School办公设备信息表 itemjj in listdata)
{
总数 += itemjj.数量;
总价 += Convert.ToInt32(itemjj.价格);
}
SchoolX_资产转移流程表 model = new SchoolX_资产转移流程表();
model.流程状态 = 流程状态.Text;
model.单据编号 = 单据编号.Text;
model.事项名称 = 事项名称.Text;
model.申请人 = 申请人.Text;
model.申请日期 = 申请日期.Text;
model.联系方式 = 联系方式.Text;
model.存放地点变更为 = 存放地点变更为.SelectedItem.Text;
model.归属部门变更为 = 归属部门变更为.SelectedItem.Text;
model.负责人变更为 = 负责人变更为.SelectedItem.Text;
model.备注信息 = 备注.Text;
model.S_ID = sid;
model.总数 = 总数;
model.总价 = 总价;
AM_提醒通知 ammodel = new AM_提醒通知();
ammodel.发起时间 = DateTime.Now;
ammodel.是否已读 = "否";
ammodel.通知类型 = "待办事项通知";
ammodel.通知职务 = "资产管理员";
ammodel.发起人 = model.申请人;
ammodel.消息内容 = "您来自" + ammodel.发起人 + "的资产交接申请,请及时处理！";
ammodel.消息事项 = "资产转移";
ammodel.是否已读 = "否";
AM_待办业务 dbmodel = new AM_待办业务();
dbmodel.处理方式 = "职务";
dbmodel.处理职务 = "资产管理员";
dbmodel.流程状态 = 流程状态.Text;
dbmodel.事项名称 = model.事项名称;
dbmodel.FlowName = "资产转移";
dbmodel.发起人 = model.申请人;
dbmodel.通知内容 = "您来自" + dbmodel.发起人 + "的资产交接申请,请及时处理！";
dbmodel.发起时间 = DateTime.Now.ToLongDateString();
dbmodel.Sort = 1;
if (model.存放地点变更为 == "" || model.存放地点变更为 == null || model.归属部门变更为 == "" || model.归属部门变更为 == null || model.负责人变更为 == "" || model.负责人变更为 == "请选择")
{
Alert.ShowInTop("请将信息填写完整！", "提示信息", MessageBoxIcon.Warning);
return;
}
else
{
int result = bll.upzczy(model, inlist, listmodel, ammodel, dbmodel);
if (result > 0)
{
Alert.ShowInTop("提交成功！", "提示信息", MessageBoxIcon.Information);
Window1.Hidden = true;
DataSet ds = bll.首页_X_资产转移流程表("流程状态-全部");
DataTable dt = ds.Tables[0].Copy();//复制一份table
DataTable source = dt;
// 3.绑定到Grid
Grid1.DataSource = dt;//DataTable
Grid1.DataBind();
return;
}
}
}
