protected void Page_Load(object sender, EventArgs e)
{
sqlTable st = new sqlTable();
string[] value = new string[5];
string[] list = { "power", "username", "password", "name", "team" };
st.select_login("root", value, "Login", list);
try
{
if (HttpContext.Current.Session["username"].ToString() != "root" || HttpContext.Current.Session["userpwd"].ToString() != value[2])
{
Response.Write(" <script> alert( '您无权访问此页面');window.location.href= 'Default.aspx ' </script> ");
}
}
catch (Exception)
{
Response.Write(" <script> alert( '您无权访问此页面');window.location.href= '../Default.aspx' </script> ");
}
string name = null;
try
{
name = HttpContext.Current.Session["name"].ToString();
}
catch (Exception)
{
Response.Write(" <script> alert( '登录超时，请重新登录');window.location.href= '../Default.aspx' </script> ");
}
Response.Write(" <script>window.onload=function(){ var name=document.getElementById('name'); name.innerHTML='欢迎你，" + name + "'} </script> ");
}
//借调结束
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 Page_Load(object sender, EventArgs e)
{
try
{
if (HttpContext.Current.Session["username"].ToString() != "zdhqxc" || HttpContext.Current.Session["userpwd"].ToString() == "null")
{
HttpContext.Current.Response.Write(" <script> alert( '您还未登陆，请先登录！！！');window.location.href= '../Default.aspx ' </script> ");
}
string name = HttpContext.Current.Session["name"].ToString();
Response.Write(" <script>window.onload=function(){ var name=document.getElementById('name'); name.innerHTML='欢迎你，" + name + "主任'} </script> ");
}
catch (Exception)
{
HttpContext.Current.Response.Write(" <script> alert( '您还未登陆，请先登录！！！');window.location.href= '../Default.aspx ' </script> ");
}
sqlTable st = new sqlTable();
string tableName = "Login";
string[] list = { "username", "password", "name", "on_job" };
DataTable loginCmd = st.selectUser(tableName, list);
if (loginCmd != null)
{
Username_Repeater.DataSource = loginCmd;
Username_Repeater.DataBind();
}
}
//经营工作量
protected void Manage_Working_Repeater_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "confirm") //如果点击的是被标记为CommandName="del"的按钮，也就是确认按钮
{
int itemIndex = int.Parse(e.CommandArgument.ToString()); //藏在CommandArgument='<%#Eval("id")+","+(Container as RepeaterItem).ItemIndex%>'逗号后面的参数就是该行行号
TextBox number = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_number") as TextBox;
TextBox name = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_name") as TextBox;
TextBox project_name = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_project_name") as TextBox;
TextBox xunjia_baojia = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_xunjia_baojia") as TextBox;
TextBox tender = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_tender") as TextBox;
TextBox sign = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_sign") as TextBox;
TextBox toubiao = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_toubiao") as TextBox;
TextBox equip = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_equip") as TextBox;
TextBox test = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_test") as TextBox;
TextBox cuikuan = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_cuikuan") as TextBox;
TextBox contract = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_contract") as TextBox;
TextBox other = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_other") as TextBox;
TextBox PM_day = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_PM_day") as TextBox;
//获取用户名
sqlTable st = new sqlTable();
string[] username = new string[1];
string tableName = "Login";
string trueName = name.Text.ToString();
string[] seleList = { "username" };
st.select_Name(trueName, username, tableName, seleList);
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
//更新列名以及数据源
string[] list = { "project_name", "xunjia_baojia", "tender", "sign", "toubiao", "equip", "test", "cuikuan", "contract", "other", "PM_day" };
string[] source11 = { project_name.Text.ToString(), xunjia_baojia.Text.ToString(), tender.Text.ToString(), sign.Text.ToString(), toubiao.Text.ToString(), equip.Text.ToString(), test.Text.ToString(), cuikuan.Text.ToString(), contract.Text.ToString(), other.Text.ToString(), PM_day.Text.ToString() };
//查找列名以及数据源
string[] selectList = { "year", "month", "username", "number" };
string[] selectSource = { year, month, username[0], number.Text.ToString() };
//插入
int res = st.table_update("Manage_Working", list, source11, selectList, selectSource);
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>");
}
}
}
//设计工作量
protected void Design_Repeater_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "confirm") //如果点击的是被标记为CommandName="del"的按钮，也就是确认按钮
{
int itemIndex = int.Parse(e.CommandArgument.ToString()); //藏在CommandArgument='<%#Eval("id")+","+(Container as RepeaterItem).ItemIndex%>'逗号后面的参数就是该行行号
TextBox dr_number = Design_Repeater.Items[itemIndex].FindControl("dr_number") as TextBox; //获得改行的TextBox1
TextBox dr_name = Design_Repeater.Items[itemIndex].FindControl("dr_name") as TextBox; //获得改行的TextBox2
TextBox dr_project_number = Design_Repeater.Items[itemIndex].FindControl("dr_project_number") as TextBox;
TextBox dr_project_name = Design_Repeater.Items[itemIndex].FindControl("dr_project_name") as TextBox;
TextBox dr_drawing_number = Design_Repeater.Items[itemIndex].FindControl("dr_drawing_number") as TextBox;
TextBox dr_A1_number = Design_Repeater.Items[itemIndex].FindControl("dr_A1_number") as TextBox;
TextBox dr_zhehe_working_day = Design_Repeater.Items[itemIndex].FindControl("dr_zhehe_working_day") as TextBox;
TextBox dr_month_day = Design_Repeater.Items[itemIndex].FindControl("dr_month_day") as TextBox;
TextBox dr_program_day = Design_Repeater.Items[itemIndex].FindControl("dr_program_day") as TextBox;
TextBox dr_basic_design_day = Design_Repeater.Items[itemIndex].FindControl("dr_basic_design_day") as TextBox;
TextBox dr_leader = Design_Repeater.Items[itemIndex].FindControl("dr_leader") as TextBox;
//获取用户名
sqlTable st = new sqlTable();
string[] username = new string[1];
string tableName = "Login";
string name = dr_name.Text;
string[] seleList = { "username" };
st.select_Name(name, username, tableName, seleList);
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
//更新列名以及数据源
string[] list = { "project_number", "project_name", "drawing_number", "A1_number", "zhehe_working_day", "month_day", "program_day", "basic_design_day", "leader" };
string[] source1 = { dr_project_number.Text.ToString(), dr_project_name.Text.ToString(), dr_drawing_number.Text.ToString(), dr_A1_number.Text.ToString(), dr_zhehe_working_day.Text.ToString(), dr_month_day.Text.ToString(), dr_program_day.Text.ToString(), dr_basic_design_day.Text.ToString(), dr_leader.Text.ToString() };
//查找列名以及数据源
string[] selectList = { "year", "month", "username", "number" };
string[] selectSource = { year, month, username[0], dr_number.Text.ToString() };
//插入
int res = st.table_update("Design", list, source1, selectList, selectSource);
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>");
}
}
}
public bool AddThis(sqlTable.Data.t_npc npc, DBInfoConnection context)
{
try
{
using (var db = context.CreateMySQL)
{
db.t_npc
.Value(p => p.a_enable, 1)
.Value(p => p.a_index, npc.a_index)
.Value(p => p.a_name, npc.a_name)
.Value(p => p.a_level, npc.a_level)
.Value(p => p.a_mp, npc.a_mp)
.Value(p => p.a_hp, npc.a_hp)
.Value(p => p.a_attackSpeed, npc.a_attackSpeed)
.Value(p => p.a_run_speed, npc.a_run_speed)
.Value(p => p.a_walk_speed, npc.a_walk_speed)
.Value(p => p.a_file_smc, npc.a_file_smc)
.Value(p => p.a_attack_area, npc.a_attack_area)
.Value(p => p.a_flag, npc.a_flag)
.Value(p => p.a_flag1, npc.a_flag1)
.Value(p => p.a_scale, npc.a_scale)
.Value(p => p.a_size, npc.a_size)
.Value(p => p.a_skillmaster, npc.a_skillmaster)
.Value(p => p.a_sskill_master, npc.a_sskill_master)
.Value(p => p.a_motion_run, npc.a_motion_run)
.Value(p => p.a_motion_walk, npc.a_motion_walk)
.Value(p => p.a_motion_idle, npc.a_motion_idle)
.Value(p => p.a_motion_idle2, npc.a_motion_idle2)
.Value(p => p.a_motion_die, npc.a_motion_die)
.Value(p => p.a_motion_dam, npc.a_motion_dam)
.Value(p => p.a_motion_attack, npc.a_motion_attack)
.Value(p => p.a_motion_attack2, npc.a_motion_attack2)
.Value(p => p.a_fireDelayCount, npc.a_fireDelayCount)
.Value(p => p.a_fireDelay0, npc.a_fireDelay0)
.Value(p => p.a_fireDelay1, npc.a_fireDelay1)
.Value(p => p.a_fireDelay2, npc.a_fireDelay2)
.Value(p => p.a_fireDelay3, npc.a_fireDelay3)
.Value(p => p.a_fireObject, npc.a_fireObject)
.Value(p => p.a_fireSpeed, npc.a_fireSpeed)
.Value(p => p.a_attackType, npc.a_attackType)
.Value(p => p.a_fireEffect0, npc.a_fireEffect0)
.Value(p => p.a_fireEffect1, npc.a_fireEffect1)
.Value(p => p.a_fireEffect2, npc.a_fireEffect2)
.Value(p => p.a_rvr_grade, npc.a_rvr_grade)
.Value(p => p.a_rvr_value, npc.a_rvr_value).Insert();
return true;
}
}
catch (Exception)
{
return false;
}
}
//修改
protected void submit_Click(object sender, EventArgs e)
{
string power = Request.Form["Post"].ToString().Trim();//职位
if (power == "2")
{
power = Request.Form["fzr"].ToString().Trim();
}
string NewUserName = Username.Text.ToString().Trim(); //用户名
string NewUserPass = Pwd.Text.ToString().Trim(); //密码
string RealName = PeopleName.Text.ToString().Trim(); //真实姓名
string team = group2.Value; //获取小组
string transfer = JieDiao.Text.ToString().Trim(); //借调
if (transfer == "已借调")
{
transfer = "1";
}
else
{
transfer = "0";
}
string peonumber = StaffNumber.Text.ToString().Trim();//员工编号
string on_job = OnJob.Text.ToString().Trim();
if (on_job == "在职")
{
on_job = "1";
}
else
{
on_job = "0";
}
sqlTable st = new sqlTable();
string[] list01 = { "power", "password", "name", "team", "transfer", "peoplenumber", "on_job" };
string[] list02 = { power, NewUserPass, RealName, team, transfer, peonumber, on_job };
string[] list03 = { "username" };
string[] list04 = { NewUserName };
int res = st.table_update("Login", list01, list02, list03, list04);
if (res == 1)
{
Response.Write("<script>alert('成功')</script>");
}
else
{
Response.Write("<script>alert('输入有误，请重新输入')</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
sqlTable st = new sqlTable();
string tableName = "Login";
string[] list = { "username", "password", "name", "on_job" };
DataTable loginCmd = st.selectUser(tableName, list);
if (loginCmd != null)
{
Username_Repeater.DataSource = loginCmd;
Username_Repeater.DataBind();
}
}
//编程/画面工作量
protected void Programming_Picture_Repeater_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "confirm") //如果点击的是被标记为CommandName="del"的按钮，也就是确认按钮
{
int itemIndex = int.Parse(e.CommandArgument.ToString()); //藏在CommandArgument='<%#Eval("id")+","+(Container as RepeaterItem).ItemIndex%>'逗号后面的参数就是该行行号
TextBox ppr_number = Programming_Picture_Repeater.Items[itemIndex].FindControl("ppr_number") as TextBox;
TextBox ppr_name = Programming_Picture_Repeater.Items[itemIndex].FindControl("ppr_name") as TextBox;
TextBox ppr_project_name = Programming_Picture_Repeater.Items[itemIndex].FindControl("ppr_project_name") as TextBox;
TextBox ppr_digital_number = Programming_Picture_Repeater.Items[itemIndex].FindControl("ppr_digital_number") as TextBox;
TextBox ppr_analog_number = Programming_Picture_Repeater.Items[itemIndex].FindControl("ppr_analog_number") as TextBox;
TextBox ppr_programing_picture = Programming_Picture_Repeater.Items[itemIndex].FindControl("ppr_programing_picture") as TextBox;
TextBox ppr_programing_day = Programming_Picture_Repeater.Items[itemIndex].FindControl("ppr_programing_day") as TextBox;
TextBox ppr_month_day = Programming_Picture_Repeater.Items[itemIndex].FindControl("ppr_month_day") as TextBox;
//获取用户名
sqlTable st = new sqlTable();
string[] username = new string[1];
string tableName = "Login";
string name = ppr_name.Text.ToString();
string[] seleList = { "username" };
st.select_Name(name, username, tableName, seleList);
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
//更新列名以及数据源
string[] list = { "project_name", "digital_number", "analog_number", "programing_picture", "programing_day", "month_day" };
string[] source1 = { ppr_project_name.Text.ToString(), ppr_digital_number.Text.ToString(), ppr_analog_number.Text.ToString(), ppr_programing_picture.Text.ToString(), ppr_programing_day.Text.ToString(), ppr_month_day.Text.ToString() };
//查找列名以及数据源
string[] selectList = { "year", "month", "username", "number" };
string[] selectSource = { year, month, username[0], ppr_number.Text.ToString() };
//插入
int res = st.table_update("Programing_Picture", list, source1, selectList, selectSource);
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>");
}
}
}
protected void submit_Click(object sender, EventArgs e)
{
string NewUserName = add_username.Text; //用户名
string NewUserPass = add_userpass.Text; //密码
string newPass = add_newPass.Text; //新密码
string confirm = add_confirm.Text; //确认新密码
sqlTable st = new sqlTable();
string[] value = new string[5];
string[] list = { "power", "username", "password", "name", "team" };
st.select_login(NewUserName, value, "Login", list);
//查找用户，修改密码
if (value[1] != "root")
{
if (NewUserName == value[1])
{
if (NewUserPass == value[2])
{
if (newPass == confirm)
{
string[] newPwdList = { "password" };
string[] newPwdSource = { newPass };
string[] userNameList = { "username" };
string[] userNameSource = { NewUserName };
int res = st.table_update("Login", newPwdList, newPwdSource, userNameList, userNameSource);
Response.Write(" <script> alert( '修改成功！ ');window.location.href= 'Default.aspx' </script> ");
}
else
{
Response.Write(@"<script>alert('新密码两次输入不一致,请重新输入！');</script>");
}
}
else
{
Response.Write(@"<script>alert('原密码输入有误,请重新输入！');</script>");
}
}
else
{
Response.Write(@"<script>alert('用户名输入有误,请重新输入！');</script>");
}
}
else
{
Response.Write(@"<script>alert('ROOT用户名不可更改密码！');</script>");
}
}
//月份
protected void submit_Click(object sender, EventArgs e)
{
sqlTable ste = new sqlTable();
string monthm = Request.Form["month"].ToString();
HttpContext.Current.Session["months"] = monthm;//月份
string tableName = "Summary_Month";
string[] mysql = new string[1];
string[] list = { "year", "month" };
string[] source = { DateTime.Now.Year.ToString(), monthm };
string[] columns = { "summary" };
ste.select_delete(tableName, mysql, list, source, columns);
HttpContext.Current.Session["numberMonth"] = mysql[0];
Page_Load(sender, e);
}
//按年查看员工汇总
protected void person_submit_Click(object sender, EventArgs e)
{
sqlTable ste = new sqlTable();
string yeary = Request.Form["person_year"].ToString();
HttpContext.Current.Session["yearuser"] = yeary;
string tableName = "Summary_Year";
string[] mysql = new string[1];
string[] list = { "year" };
string[] source = { yeary };
string[] columns = { "Ysummary" };
ste.select_delete(tableName, mysql, list, source, columns);
HttpContext.Current.Session["userYear"] = mysql[0];
Page_Load(sender, e);
}
//零星工日
protected void LingXing_Repeater_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "confirm") //如果点击的是被标记为CommandName="del"的按钮，也就是确认按钮
{
int itemIndex = int.Parse(e.CommandArgument.ToString()); //藏在CommandArgument='<%#Eval("id")+","+(Container as RepeaterItem).ItemIndex%>'逗号后面的参数就是该行行号
TextBox number = LingXing_Repeater.Items[itemIndex].FindControl("LX_number") as TextBox;
TextBox name = LingXing_Repeater.Items[itemIndex].FindControl("LX_name") as TextBox;
TextBox chuchai_day = LingXing_Repeater.Items[itemIndex].FindControl("LX_chuchai_day") as TextBox;
TextBox jiaoliu_day = LingXing_Repeater.Items[itemIndex].FindControl("LX_jiaoliu_day") as TextBox;
TextBox other_day = LingXing_Repeater.Items[itemIndex].FindControl("LX_other_day") as TextBox;
//获取用户名
sqlTable st = new sqlTable();
string[] username = new string[1];
string tableName = "Login";
string trueName = name.Text.ToString();
string[] seleList = { "username" };
st.select_Name(trueName, username, tableName, seleList);
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
//更新列名以及数据源
string[] list = { "chuchai_day", "jiaoliu_day", "other_day" };
string[] source11 = { chuchai_day.Text.ToString(), jiaoliu_day.Text.ToString(), other_day.Text.ToString() };
//查找列名以及数据源
string[] selectList = { "year", "month", "username", "number" };
string[] selectSource = { year, month, username[0], number.Text.ToString() };
//插入
int res = st.table_update("LingXing", list, source11, selectList, selectSource);
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>");
}
}
}
//修改内容拉取
protected void add_Click(object sender, EventArgs e)
{
sqlTable st = new sqlTable();
//网页输入
string New_add_index = add_index.Text.Trim(); // 索引
//获取年月日以及用户名
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string username = HttpContext.Current.Session["username"].ToString();
//查找索引是否存在
string[] listNumber = { "year", "month", "username", "number" };
string[] sourceNumber = { year, month, username, New_add_index };
string[] selectNumber = { "number" };
string tableNameNumber = "Manage_Working";
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[] list = { "year", "month", "username", "number" };
string[] source = { year, month, username, New_add_index };
string[] select_List = { "project_name", "xunjia_baojia", "tender", "sign", "toubiao", "equip", "test", "cuikuan", "contract", "other", "PM_day", "remark" };
string[] data = new string[12];
st.select_delete("Manage_Working", data, list, source, select_List);
//text框赋值
add_engineName.Text = data[0]; //项目名称
add_quotation.Text = data[1]; //商务询价报价
add_tender.Text = data[2]; //标书制作
add_sign.Text = data[3]; //合同制作与签署
add_bid.Text = data[4]; //投标工作
add_equip.Text = data[5]; //设备招标采购
add_test.Text = data[6]; //设备出厂检测
add_dun.Text = data[7]; //催款（要账）
add_contract.Text = data[8]; //合同管理
add_others.Text = data[9]; //其他经营活动
add_managerDays.Text = data[10]; //项目经理
add_remarks.Text = data[11]; //备注
}
//修改内容拉取
protected void add_Click(object sender, EventArgs e)
{
sqlTable st = new sqlTable();
//网页输入
string New_add_index = add_index.Text.Trim(); // 索引
//获取年月日以及用户名
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string username = HttpContext.Current.Session["username"].ToString();
//查找索引是否存在
string[] listNumber = { "year", "month", "username", "number" };
string[] sourceNumber = { year, month, username, New_add_index };
string[] selectNumber = { "number" };
string tableNameNumber = "Design";
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[] list = { "year", "month", "username", "number" };
string[] source = { year, month, username, New_add_index };
string[] select_List = { "project_number", "project_name", "drawing_number", "A1_number", "zhehe_working_day", "month_day", "program_day", "basic_design_day", "leader", "remark" };
string[] data = new string[10];
st.select_delete("Design", data, list, source, select_List);
//text框赋值
add_engine.Text = data[0]; //工程号
add_engineName.Text = data[1]; //工程名称
add_paperPage.Text = data[2]; //图纸张数
add_al.Text = data[3]; //折合A1
add_allDays.Text = data[4]; //折合总工日数
add_finishedDays.Text = data[5]; //本月完成工日数
add_usedDays.Text = data[6]; //技术方案工作量所用工日数
add_usedDays2.Text = data[7]; //基本设计工作量所用工日数
add_leaderDays.Text = data[8]; //工日
add_remarks.Text = data[9]; //备注
}
// DropAll
public void DellDropAll_NPC(sqlTable.Data.t_npc_drop_all npc, DBInfoConnection context)
{
try
{
if(context.TestConnection())
{
using (var db = context.CreateMySQL)
{
db.t_npc_drop_all.Where(p => p.a_npc_idx == npc.a_npc_idx)
.Delete();
}
}
}
catch (Exception ex)
{
}
}
//修改内容拉取
protected void add_Click(object sender, EventArgs e)
{
sqlTable st = new sqlTable();
//网页输入
string New_add_index = add_index.Text.Trim(); // 索引
//获取年月日以及用户名
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string username = HttpContext.Current.Session["username"].ToString();
//查找索引是否存在
string[] listNumber = { "year", "month", "username", "number" };
string[] sourceNumber = { year, month, username, New_add_index };
string[] selectNumber = { "number" };
string tableNameNumber = "Daily_Manage";
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[] list = { "year", "month", "username", "number" };
string[] source = { year, month, username, New_add_index };
string[] select_List = { "management", "affair_gonghui", "affair_dangzu", "affair_tuanzu", "examine", "kaoqin", "other", "remark" };
string[] data = new string[8];
st.select_delete("Daily_Manage", data, list, source, select_List);
//text框赋值
add_management.Text = data[0]; //部门内部日常管理
add_affair.Text = data[1]; //工会事务
add_affair2.Text = data[2]; //党组事务
add_affair3.Text = data[3]; //团组事务
add_examine.Text = data[4]; //体系内审/外审
add_check.Text = data[5]; //考勤
add_others.Text = data[6]; //其他报销
add_remarks.Text = data[7]; //备注
}
//修改内容拉取
protected void add_Click(object sender, EventArgs e)
{
sqlTable st = new sqlTable();
//网页输入
string New_add_index = add_index.Text.Trim(); // 索引
//获取年月日以及用户名
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string username = HttpContext.Current.Session["username"].ToString();
//查找索引是否存在
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[] list = { "year", "month", "username", "number" };
string[] source = { year, month, username, New_add_index };
string[] select_List = { "project_name", "digital_number", "analog_number", "programing_picture", "programing_day", "month_day", "remark" };
string[] data = new string[7];
st.select_delete("Programing_Picture", data, list, source, select_List);
//text框赋值
add_engineName.Text = data[0]; //项目名称
add_onOffNum.Text = data[1]; //总开关量点数
add_modeNum.Text = data[2]; //总模拟量点数
add_program.Value = data[3]; //编程/画面
add_allDays.Text = data[4]; //总工日数
add_finishedDays.Text = data[5]; //本月完成工日数
add_remarks.Text = data[6]; //备注
}
protected void Page_Load(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();
string team = HttpContext.Current.Session["team"].ToString();
//网页输入
//string New_add_workDays = add_workDays.Text.Trim();//本月工作日之和
//列名以及数据源
string[] list = { "year", "month", "username", "team" };
string[] source = { year, month, username, team };
string[] rest = { "" };
string[] selectLitst = { "work_day" };
//查找
st.select_delete("Summary", rest, list, source, selectLitst);
add_workDays.Text = rest[0];
}
//修改内容拉取
protected void add_Click(object sender, EventArgs e)
{
sqlTable st = new sqlTable();
//网页输入
string New_add_index = add_index.Text.Trim(); // 索引
//获取年月日以及用户名
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string username = HttpContext.Current.Session["username"].ToString();
//查找索引是否存在
string[] listNumber = { "year", "month", "username", "number" };
string[] sourceNumber = { year, month, username, New_add_index };
string[] selectNumber = { "number" };
string tableNameNumber = "Debug";
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[] list = { "year", "month", "username", "number" };
string[] source = { year, month, username, New_add_index };
string[] select_List = { "projectname", "site", "manageday", "debugday", "remark" };
string[] data = new string[5];
st.select_delete("Debug", data, list, source, select_List);
//text框赋值
add_engineName.Text = data[0]; //项目名称
add_enginePlace.Text = data[1]; //项目地点
add_manageDays.Text = data[2]; //本月工程管理天数
add_debugDays.Text = data[3]; //本月调试天数
add_remarks.Text = data[4]; //备注
}
//修改内容拉取
protected void add_Click(object sender, EventArgs e)
{
sqlTable st = new sqlTable();
//网页输入
string New_add_index = add_index.Text.Trim(); // 索引
//获取年月日以及用户名
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string username = HttpContext.Current.Session["username"].ToString();
//查找索引是否存在
string[] listNumber = { "year", "month", "username", "number" };
string[] sourceNumber = { year, month, username, New_add_index };
string[] selectNumber = { "number" };
string tableNameNumber = "LingXing";
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[] list = { "year", "month", "username", "number" };
string[] source = { year, month, username, New_add_index };
string[] select_List = { "chuchai_day", "jiaoliu_day", "other_day", "remark" };
string[] data = new string[4];
st.select_delete("LingXing", data, list, source, select_List);
//text框赋值
add_business.Text = data[0]; //本月出差天数
add_technical.Text = data[1]; //技术交流天数
add_others.Text = data[2]; //其他零星工日
add_remarks.Text = data[3]; //备注
}
//员工离职状态
protected void JobStatus_Click(object sender, EventArgs e)
{
string username = off_username.Text.Trim(); //用户名
string jobStatus = Request.Form["jobstatus"].ToString().Trim(); //工作状态
//查找是否有此用户
string[] pwd = new string[1];
string[] list01 = { "password" };
sqlTable st = new sqlTable();
st.select_onjob(username, pwd, "Login", list01);
if (pwd[0] == "NULL" || pwd[0] == "null")
{
Response.Write("<script>alert('员工姓名输入有误，请重新输入')</script>");
}
else
{
//更新状态
string[] list = { "on_job" };
string[] source = { jobStatus };
string[] selectList = { "name" };
string[] selectSource = { username };
int res = st.table_update("Login", list, source, selectList, selectSource);
if (res == 1)
{
Response.Write("<script>alert('修改成功')</script>");
Page_Load(sender, e);
}
else
{
Response.Write("<script>alert('语法错误')</script>");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (HttpContext.Current.Session["username"].ToString() == "null" || HttpContext.Current.Session["userpwd"].ToString() == "null")
{
HttpContext.Current.Response.Write(" <script> alert( '您还未登陆，请先登录！！！');window.location.href= 'Default.aspx ' </script> ");
}
string name = HttpContext.Current.Session["name"].ToString();
string[] selist = { "year", "month", "username" };
string[] solist = { DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), HttpContext.Current.Session["username"].ToString() };
string[] res = new string[1];
string[] sellist = { "transfer" };
sqlTable st = new sqlTable();
st.select_easy(selist, solist, res, "Jiediao", sellist);
string tran = res[0];
Response.Write(" <script>window.onload=function(){ var name=document.getElementById('name'); var tran=document.getElementById('tran'); name.innerHTML='欢迎你，" + name + "';tran.innerHTML='您已被" + tran + ",借调结束请点击下面按钮'} </script> ");
}
catch (Exception)
{
HttpContext.Current.Response.Write(" <script> alert( '您还未登陆，请先登录！！！');window.location.href= 'Default.aspx ' </script> ");
}
}
//修改事件
protected void modifybtn_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 New_add_engineName = add_engineName.Text.Trim(); //项目名称
string New_add_onOffNum = add_onOffNum.Text.Trim(); //总开关量点数
string New_add_modeNum = add_modeNum.Text.Trim(); //总模拟量点数
string New_add_program = Request.Form["add_program"].ToString().Trim(); //编程/画面
string New_add_allDays = add_allDays.Text.Trim(); //总工日数
string New_add_finishedDays = add_finishedDays.Text.Trim(); //本月完成工日数
string New_add_remarks = add_remarks.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[] list = { "project_name", "digital_number", "analog_number", "programing_picture", "programing_day", "month_day", "remark" };
string[] source = { New_add_engineName, New_add_onOffNum, New_add_modeNum, New_add_program, New_add_allDays, New_add_finishedDays, New_add_remarks };
//查找列名以及数据源
string[] selectList = { "year", "month", "username", "number" };
string[] selectSource = { year, month, username, New_add_index };
//插入
int res = st.table_update("Programing_Picture", list, source, selectList, selectSource);
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>");
}
}
//删除事件
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>");
}
}
//增加事件
protected void submit_Click(object sender, EventArgs e)
{
sqlTable st = new sqlTable();
int number = 0;//填写序号
//获取年月日以及用户名，小组
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string username = HttpContext.Current.Session["username"].ToString();
string team = HttpContext.Current.Session["team"].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_engineName = add_engineName.Text.Trim(); //项目名称
string New_add_onOffNum = add_onOffNum.Text.Trim(); //总开关量点数
string New_add_modeNum = add_modeNum.Text.Trim(); //总模拟量点数
string New_add_program = Request.Form["add_program"].ToString().Trim(); //编程/画面
string New_add_allDays = add_allDays.Text.Trim(); //总工日数
string New_add_finishedDays = add_finishedDays.Text.Trim(); //本月完成工日数
string New_add_remarks = add_remarks.Text.Trim(); //备注
//全为空不允许填写
if (New_add_engineName == "" && New_add_onOffNum == "" && New_add_modeNum == "" && New_add_program == "" && New_add_allDays == "" && New_add_finishedDays == "" && New_add_remarks == "")
{
Response.Write("<script>alert('插入工作量为空，请重新填写')</script>");
return;
}
//number在原有基础上加1
string list1 = "number";
string[] value = new string[1];
string[] tableName = { "Daily_Manage", "Debug", "Design", "LingXing", "Manage_Working", "Programing_Picture" };
st.select_number(list1, value, tableName, year, month, username);
if (value[0] != "" && value[0] != "NULL" && value[0] != "null")
{
number = int.Parse(value[0]) + 1;
}
else
{
number++;
}
//列名以及数据源
string[] list = { "year", "month", "username", "team", "number", "project_name", "digital_number", "analog_number", "programing_picture", "programing_day", "month_day", "remark" };
string[] source = { year, month, username, team, number.ToString(), New_add_engineName, New_add_onOffNum, New_add_modeNum, New_add_program, New_add_allDays, New_add_finishedDays, New_add_remarks };
//插入
int res = st.table_insert("Programing_Picture", list, source);
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>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
string username = "";
try
{
if (HttpContext.Current.Session["username"].ToString() == "null" || HttpContext.Current.Session["userpwd"].ToString() == "null")
{
HttpContext.Current.Response.Write(" <script> alert( '您还未登陆，请先登录！！！');window.location.href= 'Default.aspx ' </script> ");
}
username = HttpContext.Current.Session["username"].ToString();
string name = HttpContext.Current.Session["name"].ToString();
Response.Write(" <script>window.onload=function(){ var name=document.getElementById('name'); name.innerHTML='欢迎你，" + name + "'} </script> ");
}
catch (Exception)
{
HttpContext.Current.Response.Write(" <script> alert( '您还未登陆，请先登录！！！');window.location.href= 'Default.aspx ' </script> ");
}
sqlTable st = new sqlTable();
#region 设计工作量
string designTableName = "Design"; //表名
string[] designSourceList = { "number", "project_number", "project_name", "drawing_number", "A1_number", "zhehe_working_day", "month_day", "program_day", "basic_design_day", "leader", "remark" }; //查看列名
string[] designSelectList = { "year", "month", "username" }; //限定列名
string[] designSelectValue = { DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), username }; //限定列值
//连接数据查看并显示在网页
DataTable designCmd = st.selectLoop(designTableName, designSourceList, designSelectList, designSelectValue);
if (designCmd != null)
{
Design_Repeater.DataSource = designCmd;
Design_Repeater.DataBind();
}
#endregion
#region 编程/画面工作量
string programTableName = "Programing_Picture"; //表名
string[] programSourceList = { "number", "project_name", "digital_number", "analog_number", "programing_picture", "programing_day", "month_day", "remark" }; //查看列名
string[] programSelectList = { "year", "month", "username" }; //限定列名
string[] programSelectValue = { DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), username }; //限定列值
//连接数据查看并显示在网页
DataTable programCmd = st.selectLoop(programTableName, programSourceList, programSelectList, programSelectValue);
if (programCmd != null)
{
Programming_Picture_Repeater.DataSource = programCmd;
Programming_Picture_Repeater.DataBind();
}
#endregion
#region 调试/工程管理工作量
string debugTableName = "Debug"; //表名
string[] debugSourceList = { "number", "projectname", "site", "manageday", "debugday", "remark" }; //查看列名
string[] debugSelectList = { "year", "month", "username" }; //限定列名
string[] debugSelectValue = { DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), username }; //限定列值
//连接数据查看并显示在网页
DataTable debugCmd = st.selectLoop(debugTableName, debugSourceList, debugSelectList, debugSelectValue);
if (debugCmd != null)
{
Debug_Repeater.DataSource = debugCmd;
Debug_Repeater.DataBind();
}
#endregion
#region 经营工作量
string manageWorkingTableName = " Manage_Working"; //表名
string[] manageWorkingSourceList = { "number", "project_name", "xunjia_baojia", "tender", "sign", "toubiao", "equip", "test", "cuikuan", "contract", "other", "PM_day", "remark" }; //查看列名
string[] manageWorkingSelectList = { "year", "month", "username" }; //限定列名
string[] manageWorkingSelectValue = { DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), username }; //限定列值
//连接数据查看并显示在网页
DataTable manageWorkingCmd = st.selectLoop(manageWorkingTableName, manageWorkingSourceList, manageWorkingSelectList, manageWorkingSelectValue);
if (manageWorkingCmd != null)
{
Manage_Working_Repeater.DataSource = manageWorkingCmd;
Manage_Working_Repeater.DataBind();
}
#endregion
#region 日常管理工作量
string DailyManageTableName = " Daily_Manage"; //表名
string[] DailyManageSourceList = { "number", "management", "affair_gonghui", "affair_dangzu", "affair_tuanzu", "examine", "kaoqin", "other", "month_day", "remark" }; //查看列名
string[] DailyManageSelectList = { "year", "month", "username" }; //限定列名
string[] DailyManageSelectValue = { DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), username }; //限定列值
//连接数据查看并显示在网页
DataTable DailyManageCmd = st.selectLoop(DailyManageTableName, DailyManageSourceList, DailyManageSelectList, DailyManageSelectValue);
if (DailyManageCmd != null)
{
Daily_Manage_Repeater.DataSource = DailyManageCmd;
Daily_Manage_Repeater.DataBind();
}
#endregion
#region 零星工日
string lingXingTableName = " LingXing"; //表名
string[] lingXingSourceList = { "number", "chuchai_day", "jiaoliu_day", "other_day", "remark" }; //查看列名
string[] lingXingSelectList = { "year", "month", "username" }; //限定列名
string[] lingXingSelectValue = { DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), username }; //限定列值
//连接数据查看并显示在网页
DataTable lingXingCmd = st.selectLoop(lingXingTableName, lingXingSourceList, lingXingSelectList, lingXingSelectValue);
if (lingXingCmd != null)
{
LingXing_Repeater.DataSource = lingXingCmd;
LingXing_Repeater.DataBind();
}
#endregion
#region 本月工日之和
string summaryTableName = "Summary"; //表名
string[] summarySourceList = { "work_day" }; //查看列名
string[] summarySelectList = { "year", "month", "username" }; //限定列名
string[] summarySelectValue = { DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), username }; //限定列值
//连接数据查看并显示在网页
DataTable summaryCmd = st.selectLoop(summaryTableName, summarySourceList, summarySelectList, summarySelectValue);
if (summaryCmd != null)
{
Summary_Repeater.DataSource = summaryCmd;
Summary_Repeater.DataBind();
}
#endregion
}
//登录
protected void login_Click(object sender, EventArgs e)
{
sqlTable st = new sqlTable();
string[] value = new string[7];
string[] list = { "power", "username", "password", "name", "team", "transfer", "on_job" };
string username = UserName.Text.Trim();
string password = Password.Text.Trim();
if (username == "")
{
Response.Write(@"<script>alert('用户名不能为空！');</script>");
}
else if (password == "")
{
Response.Write(@"<script>alert('密码不能为空！');</script>");
}
else
{
st.select_login(username, value, "Login", list);
// root 跳转
if (int.Parse(value[6]) == 1)
{
if (username == value[1])
{
if (password == value[2])
{
if (int.Parse(value[0]) == 0)
{
//session存储用户信息
HttpContext.Current.Session["power"] = value[0]; //权限
HttpContext.Current.Session["username"] = value[1]; //获取用户名
HttpContext.Current.Session["userpwd"] = value[2]; //获取密码
HttpContext.Current.Session["name"] = value[3]; //获取用户名字
HttpContext.Current.Session["team"] = value[4]; //获取用户小组
HttpContext.Current.Session["transfer"] = value[5]; //获取用户借调状态
Response.Redirect("Root.aspx");
}
else if (int.Parse(value[0]) == 1)
{
//session存储用户信息
HttpContext.Current.Session["power"] = value[0]; //权限
HttpContext.Current.Session["username"] = value[1]; //获取用户名
HttpContext.Current.Session["userpwd"] = value[2]; //获取密码
HttpContext.Current.Session["name"] = value[3]; //获取用户名字
HttpContext.Current.Session["team"] = value[4]; //获取用户小组
HttpContext.Current.Session["transfer"] = value[5]; //获取用户借调状态
Response.Redirect("root/work.aspx");
}
else
{
//session存储用户信息
HttpContext.Current.Session["power"] = value[0]; //权限
HttpContext.Current.Session["username"] = value[1]; //获取用户名
HttpContext.Current.Session["userpwd"] = value[2]; //获取密码
HttpContext.Current.Session["name"] = value[3]; //获取用户名字
HttpContext.Current.Session["team"] = value[4]; //获取用户小组
HttpContext.Current.Session["transfer"] = value[5]; //获取用户借调状态
if (value[5] == "1")
{
Response.Redirect("workbra.aspx");
}
else
{
Response.Redirect("work.aspx");
}
}
}
else
{
Response.Write(@"<script>alert('密码输入有误！');</script>");
}
}
else
{
Response.Write(@"<script>alert('用户名输入有误！');</script>");
}
}
else
{
Response.Write(@"<script>alert('您已离职，无登录权限！');</script>");
}
}
}
//查询
protected void Select_Click(object sender, EventArgs e)
{
string NewUserName = Username.Text.ToString().Trim();//用户名
string[] value = new string[8];
string[] list01 = { "power", "username", "password", "name", "team", "transfer", "peoplenumber", "on_job" };
sqlTable st = new sqlTable();
st.select_login(NewUserName, value, "Login", list01);
if (value[0] == "18")
{
Post.Value = "18";
}
else if (value[0] == "1")
{
Post.Value = "1";
}
else if (value[0] == "2" || value[0] == "3" || value[0] == "4" || value[0] == "5" || value[0] == "6")
{
switch (value[0])
{
case "2":
Post.Value = "2";
fzr.Value = "2";
break;
case "3":
Post.Value = "2";
fzr.Value = "3";
break;
case "4":
Post.Value = "2";
fzr.Value = "4";
break;
case "5":
Post.Value = "2";
fzr.Value = "5";
break;
default:
Post.Value = "2";
fzr.Value = "6";
break;
}
}
Username.Text = value[1];
Pwd.Text = value[2];
PeopleName.Text = value[3];
group2.Value = value[4];
if (value[5] == "1")
{
JieDiao.Text = "已借调";
}
else
{
JieDiao.Text = "未借调";
}
StaffNumber.Text = value[6];
if (value[7] == "1")
{
OnJob.Text = "在职";
}
else
{
OnJob.Text = "已离职";
}
}
// Генирация для таблицы листа SQL
public void GenerateListForTable(ref sqlTable.Data.t_npc mob, MobAllLod lod)
{
mob.a_index = lod.NpcID;
mob.a_name = lod.Name;
mob.a_level = lod.Level;
mob.a_hp = lod.HP;
mob.a_mp = lod.MP;
mob.a_attackSpeed = Convert.ToSByte(lod.AttackSpeed);
mob.a_run_speed = lod.RunSpeed;
mob.a_walk_speed = lod.WalkSpeed;
mob.a_file_smc = lod.SMC;
mob.a_attack_area = lod.AttackArea;
mob.a_flag = lod.Flag;
mob.a_flag1 = lod.Flag1;
mob.a_scale = lod.Scale;
mob.a_size = lod.Size;
if (lod.SkillMaster == 255)
mob.a_skillmaster = -1;
else
mob.a_skillmaster = Convert.ToSByte(lod.SkillMaster);
if (lod.SSkillMaster == 255)
mob.a_sskill_master = -1;
else
mob.a_sskill_master = Convert.ToSByte(lod.SSkillMaster);
mob.a_motion_run = lod.Run;
mob.a_motion_walk = lod.Walk;
mob.a_motion_idle = lod.Idle;
mob.a_motion_idle2 = lod.Idle2;
mob.a_motion_die = lod.Die;
mob.a_motion_dam = lod.Damage;
mob.a_motion_attack = lod.Attack;
mob.a_motion_attack2 = lod.Attack2;
mob.a_fireDelayCount = Convert.ToSByte(lod.FireDelayCount);
mob.a_fireDelay0 = lod.FireDelay0;
mob.a_fireDelay1 = lod.FireDelay1;
mob.a_fireDelay2 = lod.FireDelay2;
mob.a_fireDelay3 = lod.FireDelay3;
mob.a_fireObject = Convert.ToSByte(lod.FireObject);
mob.a_fireSpeed = lod.FireSpeed;
if (lod.AttackType == 255)
mob.a_attackType = -1;
else
mob.a_attackType = Convert.ToSByte(lod.AttackType);
mob.a_fireEffect0 = lod.FireEffect0;
mob.a_fireEffect1 = lod.FireEffect1;
mob.a_fireEffect2 = lod.FireEffect2;
mob.a_rvr_grade = lod.RvRGrade;
mob.a_rvr_value = lod.RvRValue;
}
public bool UpdateExtraInfo(sqlTable.Data.t_npc npc, DBInfoConnection context)
{
try
{
using(var db = context.CreateMySQL)
{
db.t_npc.Where(p => p.a_index == npc.a_index)
.Set(p => p.a_maxplus, npc.a_maxplus)
.Set(p => p.a_minplus, npc.a_minplus)
.Set(p => p.a_probplus, npc.a_probplus)
.Set(p => p.a_prize, npc.a_prize)
.Set(p => p.a_skill_point, npc.a_skill_point)
.Set(p => p.a_exp, npc.a_exp)
.Set(p => p.a_item_0, npc.a_item_0)
.Set(p => p.a_item_1, npc.a_item_1)
.Set(p => p.a_item_2, npc.a_item_2)
.Set(p => p.a_item_3, npc.a_item_3)
.Set(p => p.a_item_4, npc.a_item_4)
.Set(p => p.a_item_5, npc.a_item_5)
.Set(p => p.a_item_6, npc.a_item_6)
.Set(p => p.a_item_7, npc.a_item_7)
.Set(p => p.a_item_8, npc.a_item_8)
.Set(p => p.a_item_9, npc.a_item_9)
.Set(p => p.a_item_10, npc.a_item_10)
.Set(p => p.a_item_11, npc.a_item_11)
.Set(p => p.a_item_12, npc.a_item_12)
.Set(p => p.a_item_13, npc.a_item_13)
.Set(p => p.a_item_14, npc.a_item_14)
.Set(p => p.a_item_15, npc.a_item_15)
.Set(p => p.a_item_16, npc.a_item_16)
.Set(p => p.a_item_17, npc.a_item_17)
.Set(p => p.a_item_18, npc.a_item_18)
.Set(p => p.a_item_19, npc.a_item_19)
.Set(p => p.a_item_percent_0, npc.a_item_percent_0)
.Set(p => p.a_item_percent_1, npc.a_item_percent_1)
.Set(p => p.a_item_percent_2, npc.a_item_percent_2)
.Set(p => p.a_item_percent_3, npc.a_item_percent_3)
.Set(p => p.a_item_percent_4, npc.a_item_percent_4)
.Set(p => p.a_item_percent_5, npc.a_item_percent_5)
.Set(p => p.a_item_percent_6, npc.a_item_percent_6)
.Set(p => p.a_item_percent_7, npc.a_item_percent_7)
.Set(p => p.a_item_percent_8, npc.a_item_percent_8)
.Set(p => p.a_item_percent_9, npc.a_item_percent_9)
.Set(p => p.a_item_percent_10, npc.a_item_percent_10)
.Set(p => p.a_item_percent_11, npc.a_item_percent_11)
.Set(p => p.a_item_percent_12, npc.a_item_percent_12)
.Set(p => p.a_item_percent_13, npc.a_item_percent_13)
.Set(p => p.a_item_percent_14, npc.a_item_percent_14)
.Set(p => p.a_item_percent_15, npc.a_item_percent_15)
.Set(p => p.a_item_percent_16, npc.a_item_percent_16)
.Set(p => p.a_item_percent_17, npc.a_item_percent_17)
.Set(p => p.a_item_percent_18, npc.a_item_percent_18)
.Set(p => p.a_item_percent_19, npc.a_item_percent_19)
.Update();
return true;
}
}
catch (Exception ex)
{
return false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (HttpContext.Current.Session["username"].ToString() == "null" || HttpContext.Current.Session["userpwd"].ToString() == "null")
{
HttpContext.Current.Response.Write(" <script> alert( '您还未登陆，请先登录！！！');window.parent.location.href= '../../Default.aspx' </script> ");
}
}
catch (Exception)
{
HttpContext.Current.Response.Write(" <script> alert( '您还未登陆，请先登录！！！');window.parent.location.href= '../../Default.aspx' </script> ");
}
sqlTable st = new sqlTable();
try
{
#region 设计工作量
string designTableName1 = "Design"; //表名1
string designTableName2 = "Login"; //表名2
string[] designSourceList = { "Design.number", "Login.name", "Design.project_number", "Design.project_name", "Design.drawing_number", "Design.A1_number", "Design.zhehe_working_day", "Design.month_day", "Design.program_day", "Design.basic_design_day", "Design.leader", "Design.remark" }; //查看列名
string[] designSelectList = { "year", "month", "Design.username" }; //限定列名
string[] designSelectValue = { HttpContext.Current.Session["yearh"].ToString(), HttpContext.Current.Session["monh"].ToString(), "Login.username" }; //限定列值
//连接数据查看并显示在网页
DataTable designCmd = st.selectAll(designTableName1, designTableName2, designSourceList, designSelectList, designSelectValue);
if (designCmd != null)
{
Design_Repeater.DataSource = designCmd;
Design_Repeater.DataBind();
}
#endregion
#region 编程/画面工作量
string programTableName1 = "Programing_Picture"; //表名1
string programTableName2 = "Login"; //表名2
string[] programSourceList = { "Programing_Picture.number", "Login.name", "Programing_Picture.project_name", "Programing_Picture.digital_number", "Programing_Picture.analog_number", "Programing_Picture.programing_picture", "Programing_Picture.programing_day", "Programing_Picture.month_day", "Programing_Picture.remark" }; //查看列名
string[] programSelectList = { "year", "month", "Programing_Picture.username" }; //限定列名
string[] programSelectValue = { HttpContext.Current.Session["yearh"].ToString(), HttpContext.Current.Session["monh"].ToString(), "Login.username" }; //限定列值
//连接数据查看并显示在网页
DataTable programCmd = st.selectAll(programTableName1, programTableName2, programSourceList, programSelectList, programSelectValue);
if (programCmd != null)
{
Programming_Picture_Repeater.DataSource = programCmd;
Programming_Picture_Repeater.DataBind();
}
#endregion
#region 调试/工程管理工作量
string debugTableName1 = "Debug"; //表名1
string debugTableName2 = "Login"; //表名2
string[] debugSourceList = { "Debug.number", "Login.name", "Debug.projectname", "Debug.site", "Debug.manageday", "Debug.debugday", "Debug.remark" }; //查看列名
string[] debugSelectList = { "year", "month", "Debug.username" }; //限定列名
string[] debugSelectValue = { HttpContext.Current.Session["yearh"].ToString(), HttpContext.Current.Session["monh"].ToString(), "Login.username" }; //限定列值
//连接数据查看并显示在网页
DataTable debugCmd = st.selectAll(debugTableName1, debugTableName2, debugSourceList, debugSelectList, debugSelectValue);
if (debugCmd != null)
{
Debug_Repeater.DataSource = debugCmd;
Debug_Repeater.DataBind();
}
#endregion
#region 经营工作量
string manageWorkingTableName1 = "Manage_Working"; //表名1
string manageWorkingTableName2 = "Login"; //表名2
string[] manageWorkingSourceList = { "Manage_Working.number", "Login.name", "Manage_Working.project_name", "Manage_Working.xunjia_baojia", "Manage_Working.tender", "Manage_Working.sign", "Manage_Working.toubiao", "Manage_Working.equip", "Manage_Working.test", "Manage_Working.cuikuan", "Manage_Working.contract", "Manage_Working.other", "Manage_Working.PM_day", "Manage_Working.remark" }; //查看列名
string[] manageWorkingSelectList = { "year", "month", "Manage_Working.username" }; //限定列名
string[] manageWorkingSelectValue = { HttpContext.Current.Session["yearh"].ToString(), HttpContext.Current.Session["monh"].ToString(), "Login.username" }; //限定列值
//连接数据查看并显示在网页
DataTable manageWorkingCmd = st.selectAll(manageWorkingTableName1, manageWorkingTableName2, manageWorkingSourceList, manageWorkingSelectList, manageWorkingSelectValue);
if (manageWorkingCmd != null)
{
Manage_Working_Repeater.DataSource = manageWorkingCmd;
Manage_Working_Repeater.DataBind();
}
#endregion
#region 日常管理工作量
string DailyManageTableName1 = "Daily_Manage"; //表名1
string DailyManageTableName2 = "Login"; //表名2
string[] DailyManageSourceList = { "Daily_Manage.number", "Login.name", "Daily_Manage.management", "Daily_Manage.affair_gonghui", "Daily_Manage.affair_dangzu", "Daily_Manage.affair_tuanzu", "Daily_Manage.examine", "Daily_Manage.kaoqin", "Daily_Manage.tel", "Daily_Manage.meal", "Daily_Manage.other", "Daily_Manage.month_day", "Daily_Manage.remark" }; //查看列名
string[] DailyManageSelectList = { "year", "month", "Daily_Manage.username" }; //限定列名
string[] DailyManageSelectValue = { HttpContext.Current.Session["yearh"].ToString(), HttpContext.Current.Session["monh"].ToString(), "Login.username" }; //限定列值
//连接数据查看并显示在网页
DataTable DailyManageCmd = st.selectAll(DailyManageTableName1, DailyManageTableName2, DailyManageSourceList, DailyManageSelectList, DailyManageSelectValue);
if (DailyManageCmd != null)
{
Daily_Manage_Repeater.DataSource = DailyManageCmd;
Daily_Manage_Repeater.DataBind();
}
#endregion
#region 零星工日
string lingXingTableName1 = "LingXing"; //表名1
string lingXingTableName2 = "Login"; //表名2
string[] lingXingSourceList = { "LingXing.number", "Login.name", "LingXing.chuchai_day", "LingXing.jiaoliu_day", "LingXing.other_day", "LingXing.remark" }; //查看列名
string[] lingXingSelectList = { "year", "month", "LingXing.username" }; //限定列名
string[] lingXingSelectValue = { HttpContext.Current.Session["yearh"].ToString(), HttpContext.Current.Session["monh"].ToString(), "Login.username" }; //限定列值
//连接数据查看并显示在网页
DataTable lingXingCmd = st.selectAll(lingXingTableName1, lingXingTableName2, lingXingSourceList, lingXingSelectList, lingXingSelectValue);
if (lingXingCmd != null)
{
LingXing_Repeater.DataSource = lingXingCmd;
LingXing_Repeater.DataBind();
}
#endregion
#region 本月工日之和
string summaryTableName1 = "Summary"; //表名
string summaryTableName2 = "Login"; //表名2
string summaryTableName3 = "Jiediao"; //表名3
string summaryTableName4 = "Summary_Month"; //表名4
string[] summarySourceList = { "Login.name", "Summary.work_day" }; //查看列名
string[] summarySourceList2 = { "Login.name", "Jiediao.transfer" }; //查看列名2
string[] summarySelectList = { "year", "month", "Summary.username" }; //限定列名
string[] summarySelectList2 = { "year", "month", "Jiediao.username" }; //限定列名2
string[] summarySelectValue = { HttpContext.Current.Session["yearh"].ToString(), HttpContext.Current.Session["monh"].ToString(), "Login.username" }; //限定列值
string[] summarySelectValue2 = { HttpContext.Current.Session["yearh"].ToString(), HttpContext.Current.Session["monh"].ToString(), "Login.username" }; //限定列值
//连接数据查看并显示在网页
DataTable summaryCmd = st.selectAll6(summaryTableName2, summaryTableName1, summaryTableName3, summaryTableName4, summarySourceList, summarySelectList, summarySelectValue, summarySourceList2, summarySelectList2, summarySelectValue2);
if (summaryCmd != null)
{
Summary_Repeater.DataSource = summaryCmd;
Summary_Repeater.DataBind();
}
#endregion
}
catch (Exception)
{
HttpContext.Current.Response.Write(" <script> alert( '您还未登陆，请先登录！！！');window.parent.location.href= '../../Default.aspx ' </script> ");
}
}
public void DropAll_NPC_Add(sqlTable.Data.t_npc_drop_all npc, DBInfoConnection context)
{
try
{
if (context.TestConnection())
{
using (var db = context.CreateMySQL)
{
db.t_npc_drop_all
.Value(p => p.a_npc_idx, npc.a_npc_idx)
.Value(p => p.a_item_idx, npc.a_item_idx)
.Value(p => p.a_prob, npc.a_prob).Insert();
}
}
}
catch (Exception ex)
{
}
}
//增加事件
protected void submit_Click(object sender, EventArgs e)
{
sqlTable st = new sqlTable();
int number = 0;//填写序号
//获取年月日以及用户名，小组
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string username = HttpContext.Current.Session["username"].ToString();
string team = HttpContext.Current.Session["team"].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_engineName = add_engineName.Text.Trim(); //项目名称
string New_add_quotation = add_quotation.Text.Trim(); //商务询价报价
string New_add_tender = add_tender.Text.Trim(); //标书制作
string New_add_sign = add_sign.Text.Trim(); //合同制作与签署
string New_add_bid = add_bid.Text.Trim(); //投标工作
string New_add_equip = add_equip.Text.Trim(); //设备招标采购
string New_add_test = add_test.Text.Trim(); //设备出厂检测
string New_add_dun = add_dun.Text.Trim(); //催款（要账）
string New_add_contract = add_contract.Text.Trim(); //合同管理
string New_add_others = add_others.Text.Trim(); //其他经营活动
string New_add_managerDays = add_managerDays.Text.Trim(); //项目经理
string New_add_remarks = add_remarks.Text.Trim(); //备注
//全为空不允许填写
if (New_add_engineName == "" && New_add_quotation == "" && New_add_tender == "" && New_add_sign == "" && New_add_bid == "" && New_add_equip == "" && New_add_test == "" && New_add_dun == "" && New_add_contract == "" && New_add_others == "" && New_add_managerDays == "" && New_add_remarks == "")
{
Response.Write("<script>alert('插入工作量为空，请重新填写')</script>");
return;
}
//number在原有基础上加1
string list1 = "number";
string[] value = new string[1];
string[] tableName = { "Daily_Manage", "Debug", "Design", "LingXing", "Manage_Working", "Programing_Picture" };
st.select_number(list1, value, tableName, year, month, username);
if (value[0] != "" && value[0] != "NULL" && value[0] != "null")
{
number = int.Parse(value[0]) + 1;
}
else
{
number = 1;
}
//列名以及数据源
string[] list = { "year", "month", "username", "team", "number", "project_name", "xunjia_baojia", "tender", "sign", "toubiao", "equip", "test", "cuikuan", "contract", "other", "PM_day", "remark" };
string[] source = { year, month, username, team, number.ToString(), New_add_engineName, New_add_quotation, New_add_tender, New_add_sign, New_add_bid, New_add_equip, New_add_test, New_add_dun, New_add_contract, New_add_others, New_add_managerDays, New_add_remarks };
//插入
int res = st.table_insert("Manage_Working", list, source);
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>");
}
}
//修改事件
protected void modifybtn_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 New_add_engineName = add_engineName.Text.Trim(); //项目名称
string New_add_quotation = add_quotation.Text.Trim(); //商务询价报价
string New_add_tender = add_tender.Text.Trim(); //标书制作
string New_add_sign = add_sign.Text.Trim(); //合同制作与签署
string New_add_bid = add_bid.Text.Trim(); //投标工作
string New_add_equip = add_equip.Text.Trim(); //设备招标采购
string New_add_test = add_test.Text.Trim(); //设备出厂检测
string New_add_dun = add_dun.Text.Trim(); //催款（要账）
string New_add_contract = add_contract.Text.Trim(); //合同管理
string New_add_others = add_others.Text.Trim(); //其他经营活动
string New_add_managerDays = add_managerDays.Text.Trim(); //项目经理
string New_add_remarks = add_remarks.Text.Trim(); //备注
//查找索引是否存在
string[] listNumber = { "year", "month", "username", "number" };
string[] sourceNumber = { year, month, username, New_add_index };
string[] selectNumber = { "number" };
string tableNameNumber = "Manage_Working";
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[] list = { "project_name", "xunjia_baojia", "tender", "sign", "toubiao", "equip", "test", "cuikuan", "contract", "other", "PM_day", "remark" };
string[] source = { New_add_engineName, New_add_quotation, New_add_tender, New_add_sign, New_add_bid, New_add_equip, New_add_test, New_add_dun, New_add_contract, New_add_others, New_add_managerDays, New_add_remarks };
//查找列名以及数据源
string[] selectList = { "year", "month", "username", "number" };
string[] selectSource = { year, month, username, New_add_index };
//插入
int res = st.table_update("Manage_Working", list, source, selectList, selectSource);
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>");
}
}
