//借调结束
protected void OnJob_Click(object sender, EventArgs e)
{
string username = HttpContext.Current.Session["username"].ToString();
//查找借调状态
string[] onJob = new string[1];
string[] seList = { "transfer" };
sqlTable st = new sqlTable();
st.select_login(username, onJob, "Login", seList);
if (onJob[0] == "0")
{
Response.Write("<script>alert('您未被调至其他部门')</script>");
}
else if (onJob[0] == "1")
{
string[] soList = { "0" };
string[] usese = { "username", "password" };
string[] useso = { HttpContext.Current.Session["username"].ToString(), HttpContext.Current.Session["userpwd"].ToString() };
int res2 = st.table_update("Login", seList, soList, usese, useso);
//删除本月借调
string tableName = "Jiediao";
string[] delist = { "year", "month", "username" };
string[] deValue = { DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), HttpContext.Current.Session["username"].ToString() };
int res3 = st.table_delete(tableName, delist, deValue);
}
Response.Write("<script>alert('借调结束');;window.location.href= 'work.aspx ' </script>");
}
//删除事件
protected void delete_Click(object sender, EventArgs e)
{
sqlTable st = new sqlTable();
//获取年月日以及用户名，小组
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string username = HttpContext.Current.Session["username"].ToString();
//借调判断
if (HttpContext.Current.Session["transfer"].ToString() == "1")
{
string tableNames = "Jiediao";
string[] result = new string[1];
string[] col = { "transfer" };
string[] translist = { "year", "month", "username" };
string[] transsource = { year, month, username };
st.select_delete(tableNames, result, translist, transsource, col);
Response.Write("<script>alert('您已被" + result[0] + "，无法删除')</script>");
return;
}
//网页输入
string New_add_index = add_index.Text.Trim(); //添加索引
//查找索引是否存在
string[] listNumber = { "year", "month", "username", "number" };
string[] sourceNumber = { year, month, username, New_add_index };
string[] selectNumber = { "number" };
string tableNameNumber = "Programing_Picture";
string[] resNumber = new string[1];
st.select_delete(tableNameNumber, resNumber, listNumber, sourceNumber, selectNumber);
if (New_add_index != resNumber[0])
{
Response.Write("<script>alert('填写序号有误')</script>");
return;
}
//查找原来日常工作量当月汇总
string[] list6 = { "year", "month", "username", "number" };
string[] source6 = { year, month, username, New_add_index };
int res = st.table_delete("Programing_Picture", list6, source6);
#region 修改number值
string[] tableName = { "Daily_Manage", "Debug", "Design", "LingXing", "Manage_Working", "Programing_Picture" };
string[] columns = { "number" };
String[,] temp = new String[30, 1];
String[,] temp1 = new String[30, 1];
string[] xianding = { "year", "month", "username" };
string[] xdValue = { year, month, username };
for (int k = 0; k < tableName.Length; k++)
{
for (int j = 0; j < temp.Length; j++)
{
temp[j, 0] = null;
}
//st.page_flash(temp, tableName[k], columns);//tableName[i]
st.selecet_number(temp, tableName[k], columns, xianding, xdValue);
for (int i = 0; i < temp.GetLength(0); i++)
{
if (temp[i, 0] == null)
{
break;
}
if (int.Parse(temp[i, 0]) > int.Parse(New_add_index))
{
temp1[i, 0] = temp[i, 0];
temp[i, 0] = (int.Parse(temp[i, 0]) - 1).ToString();
string[] temp2 = new string[1];
temp2[0] = temp[i, 0];
string[] upsource = { year, month, username, temp1[i, 0] };
st.table_update(tableName[k], columns, temp2, list6, upsource);
}
}
}
#endregion
if (res == 1)
{
Response.Write("<script>alert('成功')</script>");
}
else if (res == 0)
{
Response.Write("<script>alert('输入有误，请重新输入')</script>");
}
else if (res == 2)
{
Response.Write("<script>alert('语法错误')</script>");
}
}
