📄 moas1103.aspx.cs
字号:
{
Page.RegisterStartupScript("startup","<script language='javascript'>alert('不存在这样的职员!');</script>");
}
}
catch(Exception ex)
{
HttpContext.Current.Response.Redirect("ErrorMessage.aspx?message="+ex.Message+""); //有异常.抛出异常画面..
}
}
}
private void Button1_Click(object sender, System.EventArgs e)
{
try
{
string[] strcmpn1={"职员ID",""+TextBox1.Value+""};
string[] strcmpn2={"用户名",""+TextBox2.Text+""};
string[] strcmpn3={"身份证号",""+TextBox3.Text+""};
string[] strcmpn4={"内线号码",""+TextBox4.Text+""};
string[] strcmpn5={"公司Email",""+TextBox5.Text+""};
string[] strcmpn6={"公司IP",""+TextBox6.Text+""};
string[] strcmpn7={"职员ID",""+TextBox1.Value+"",""+TextBox1.MaxLength+""};//职员ID
Compare cmp=new Compare();
if(cmp.CompareNull(strcmpn1)==true&&cmp.CompareNull(strcmpn2)==true&&cmp.CompareNull(strcmpn3)==true&&cmp.CompareNull(strcmpn4)==true&&cmp.CompareNull(strcmpn5)==true&&cmp.CompareNull(strcmpn6)==true&&cmp.CompareNumber(strcmpn1)==true&&cmp.CompareNumber(strcmpn3)==true&&cmp.CompareNumber(strcmpn4)==true&&cmp.CompareNumber(strcmpn6)==true&&cmp.CompareLength(strcmpn7))
{
string id="'"+TextBox1.Value+"'";
string strSqlid="select id from USERS where id="+id+"";
CCoSearchFromDatabase search= new CCoSearchFromDatabase();
string[,] userInfo=search.getList(strSqlid);
if(userInfo!=null)
{
Page.RegisterStartupScript("startup","<script language='javascript'>alert('该社员ID已经存在!');</script>");
}
else
{
if(TextBox1.Value.Substring(5,2)!=DropDownList4.SelectedItem.Value)
{
Page.RegisterStartupScript("startup","<script language='javascript'>alert('性别选择有错误!');</script>"); //02003[01]13..02003[02]23== "01"代表男 “02“代表女
}
else
{
string textbox1="'"+TextBox1.Value+"'";
string textbox2="'"+TextBox2.Text.Replace(" ","")+"'";
string textbox3="'"+TextBox3.Text.Replace(" ","")+"'";
string drop1="'"+DropDownList1.SelectedItem.Value+"'";
string drop2="'"+DropDownList2.SelectedItem.Value+"'";
string textbox4="'"+TextBox4.Text+"'";
string textbox5="'"+TextBox5.Text.Replace(" ","")+"'";
string textbox6="'"+TextBox6.Text+"'";
string textbox7="'"+TextBox7.Text+"'";
string textbox8="'"+TextBox8.Text+"'";
string textbox9="'"+TextBox9.Text+"'";
string insertText="("+textbox1+","+textbox2+",'00000000',"+textbox3+","+drop1+","+drop2+","+textbox4+","+textbox5+","+textbox6+","+textbox7+","+textbox8+","+textbox9+",'1',"+DateTime.Now.Date.ToString().Substring(0,10).Replace("/","-")+",null);";
string ins="Insert into USERS Values "+insertText+"";
CCoSearchFromDatabase insert=new CCoSearchFromDatabase();
insert.Execute(ins);
Page.RegisterStartupScript("startup","<script language='javascript'>alert('添加用户成功!');</script>");
}
}
}
}
catch(Exception ex)
{
HttpContext.Current.Response.Redirect("ErrorMessage.aspx?message="+ex.Message+""); //有异常.抛出异常画面..
}
}
private void Button2_Click(object sender, System.EventArgs e)
{
try
{
string[] str={"用户ID",""+TextBox1.Value+""};
string[] str1={"用户ID",""+TextBox1.Value+"",""+TextBox1.MaxLength+""};
Compare cmp=new Compare();
if(cmp.CompareNull(str)==true&&cmp.CompareNumber(str)&&cmp.CompareLength(str1))
{
string id="'"+TextBox1.Value+"'";
string strSqlid="select id from USERS where id="+id+"";
CCoSearchFromDatabase search= new CCoSearchFromDatabase();
string[,] userInfo=search.getList(strSqlid);
if(userInfo!=null)
{
string textbox1="ID='"+TextBox1.Value+"'";
string deleteText="delete from USERS where "+textbox1+"";
CCoSearchFromDatabase delete=new CCoSearchFromDatabase();
delete.Execute(deleteText);
Page.RegisterStartupScript("startup","<script language='javascript'>alert('用户删除成功,该用户被永久删除!');</script>");
}
else
{
Page.RegisterStartupScript("startup","<script language='javascript'>alert('输入职员ID有错误,不存在该职员!');</script>");
}
}
}
catch(Exception ex)
{
HttpContext.Current.Response.Redirect("ErrorMessage.aspx?message="+ex.Message+""); //有异常.抛出异常画面..
}
}
private void Button3_Click(object sender, System.EventArgs e)
{
try
{
string[] strcmpn1={"职员ID",""+TextBox1.Value+""};
string[] strcmpn2={"用户名",""+TextBox2.Text+""};
string[] strcmpn3={"身份证号",""+TextBox3.Text+""};
string[] strcmpn4={"内线号码",""+TextBox4.Text+""};
string[] strcmpn5={"公司Email",""+TextBox5.Text+""};
string[] strcmpn6={"公司IP",""+TextBox6.Text+""};
string[] strcmpn7={"职员ID",""+TextBox1.Value+"",""+TextBox1.MaxLength+""};
Compare cmp=new Compare();
if(cmp.CompareNull(strcmpn1)==true&&cmp.CompareNull(strcmpn2)==true&&cmp.CompareNull(strcmpn3)==true&&cmp.CompareNull(strcmpn4)==true&&cmp.CompareNull(strcmpn5)==true&&cmp.CompareNull(strcmpn6)==true&&cmp.CompareNumber(strcmpn1)==true&&cmp.CompareNumber(strcmpn3)==true&&cmp.CompareNumber(strcmpn4)==true&&cmp.CompareNumber(strcmpn6)==true&&cmp.CompareLength(strcmpn7))
{
string id="'"+TextBox1.Value+"'";
string strSqlid="select id from USERS where id="+id+"";
CCoSearchFromDatabase search= new CCoSearchFromDatabase();
string[,] userInfo=search.getList(strSqlid);
if(userInfo!=null)
{
if(TextBox1.Value.Substring(5,2).Equals(DropDownList4.SelectedItem.Value))
{
string textbox1="ID='"+TextBox1.Value+"'";
string textbox2="NAME='"+TextBox2.Text+"'";
string textbox3="ID_CARD='"+TextBox3.Text+"'";
string drop1="DEP_ID='"+DropDownList1.SelectedItem.Value+"'";
string drop2="JOB_ID='"+DropDownList2.SelectedItem.Value+"'";
string textbox4="TEL='"+TextBox4.Text+"'";
string textbox5="MAIL='"+TextBox5.Text+"'";
string textbox6="IP='"+TextBox6.Text+"'";
string textbox7="MOBILE='"+TextBox7.Text+"'";
string textbox8="HOMETEL='"+TextBox8.Text+"'";
string textbox9="HOMEMAIL='"+TextBox9.Text+"'";
string status="";
if(Select1.SelectedIndex.ToString()!="2") //没有选择“离职人员”情况下
{
status="STATUS='1'";
}
else
{
status="STATUS='0'";
string searchId="'"+TextBox1.Value+"'";
string updateValue="update SEAT set OWNERID='kuuseki ' WHERE OWNERID="+searchId+" ";
CCoSearchFromDatabase updateEct=new CCoSearchFromDatabase();
updateEct.Execute(updateValue);
}
string starttime="START_TIME='"+DateTime.Now.Date.ToString().Substring(0,10).Replace("/","")+"'";
string updateText=""+textbox2+","+textbox3+","+drop1+","+drop2+","+textbox4+","+textbox5+","+textbox6+","+textbox7+","+textbox8+","+textbox9+","+status+","+starttime+"";
string updateText1="update USERS set "+updateText+" where "+textbox1+"";
CCoSearchFromDatabase update=new CCoSearchFromDatabase();
update.Execute(updateText1);
Page.RegisterStartupScript("startup","<script language='javascript'>alert('用户信息修改成功!');</script>");
}
else
{
Page.RegisterStartupScript("startup","<script language='javascript'>alert('性别选择有错误!');</script>"); //02003[01]13..02003[02]23== "01"代表男 “02“代表女
}
}
else
{
Page.RegisterStartupScript("startup","<script language='javascript'>alert('输入的社员ID错误,不存在这样的职员!');</script>");
}
}
}
catch(Exception ex)
{
HttpContext.Current.Response.Redirect("ErrorMessage.aspx?message="+ex.Message+""); //有异常.抛出异常画面..
}
}
// public bool CompareNull(string[,] str)
// {
// bool a=false;
// for(int j=0;j<(str.Length/2);j++)
// {
//
// if(str[j,1]=="")
// {
//
// Page.RegisterStartupScript("startup","<script language='javascript'>alert('"+str[j,0]+"不能为空!');</script>");
// a=false;
// break;
//
// }
// a=true;
//
// }
// return a;
// }
// public bool CompareLength()
// {
// bool b=false;
// if(TextBox1.Value.Length==9)
// {
// b=true;
// }
// else
// {
// Page.RegisterStartupScript("startup","<script language='javascript'>alert('用户ID输入错误,应该为9位数字!');</script>");
// TextBox1.Value="";
// Page.RegisterStartupScript("focus", "<script language=javascript>document.getElementById('TextBox1').focus();</script>");
//
// }
// return b;
// }
// public bool CompareNumber(string[,] w)
// {
// bool c=false;
// string str="0123456789";
// int v=0;
// bool a=false;
// for(int j=0;j<(w.Length/2);j++)
// {
// while(v<w[j,1].Length)
// {
// if (str.IndexOf(w[j,1].Substring(v,1))==-1)
// {
// a=true; //不全是数字
// break;
// }
// v++;
// }
// if(a==true)
// {
//
// Page.RegisterStartupScript("startup","<script language='javascript'>alert('"+w[j,0]+"输入有错误,以数字形式输入!');</script>");
// c=false;
// break;
// }
// else
// {
// v=0;
// c=true; //quan全为数字；
//
// }
// }
// return c;
// }
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -