protected void IBtn_Click(object sender, ImageClickEventArgs e)
{
SqlAccess sqlAccess = null;
try
{
DataSet userData = new DataSet();
sqlAccess = new SqlAccess();
sqlAccess.Open();
string ID = this.txtname.Text.Trim();
string password = this.txtpassword.Text.Trim();
string[] Roles = null;
string outStr;
string queryString = "select role from ta_role ";//这里保证所有权限的用户均能进入此页面
DataSet dataSet = sqlAccess.OpenQuerry(queryString);
if (dataSet != null && dataSet.Tables[0].Rows.Count > 0)
{
Roles = new string[dataSet.Tables[0].Rows.Count];
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
Roles[i] = dataSet.Tables[0].Rows[i][0].ToString();
}
}
Byte[] Key = { 0x11, 0x22, 0x33, 0x44, 0x55, 0x66, 0x77, 0x88 };
Byte[] IV = { 0x12, 0x34, 0x56, 0x78, 0x90, 0xAB, 0xCD, 0xEF };
Hashtable ht = (Hashtable)ConfigurationManager.GetSection("superAdminSection");//从超级管理权限配置中取
foreach (DictionaryEntry key in ht)
{
if (ID == key.Key.ToString() && password == Encrypt.DecryptString(key.Value.ToString(), Key, IV))
{
Session["ID"] = ID;
Session["UserName"] = "******"+ID;
Session["Password"] = password;
Session["IsSuperAdmin"] = true;
Session["Login"] = true;
Session["Roles"] = Roles;
break;
}
}
if (SessionUser.IsSuperAdmin)
{
Response.Redirect("Main/index.aspx",false); return;
}
if (!Methods.CheckUser(this, ID, password, Roles, out outStr, false))//验证用户的存在与合法性
{
this.lblMsg.Text = outStr;
return;
}
//验证权限
queryString = "SELECT ID, Name, Password,state FROM TA_Employee where ID='" + ID + "' and Password= '******' and state !='2'";
dataSet = sqlAccess.OpenQuerry(queryString);
if (dataSet != null && dataSet.Tables[0].Rows.Count > 0)
{
DataRow row = dataSet.Tables[0].Rows[0];
Session["ID"] = row["id"].ToString();
Session["UserName"] = row["Name"].ToString();
Session["Account"] = row["ID"].ToString();
Session["Password"] = Encrypt.DecryptString(row["Password"].ToString());
Session["Login"] = true;
Session["UserHostName"] = this.Request.UserHostName;
Session["IP"] = this.Request.UserHostAddress;
Session["State"] = row["State"].ToString();
queryString = " select role from TRE_Employee_Role where EmployeeID='" + ID + "'";//找其角色并保存session变量中
dataSet = sqlAccess.OpenQuerry(queryString);
Roles = null;
if (dataSet != null && dataSet.Tables[0].Rows.Count > 0)
{
Roles = new string[dataSet.Tables[0].Rows.Count];
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
Roles[i] = dataSet.Tables[0].Rows[i]["role"].ToString();
}
}
Session["Roles"] = Roles;
//FormsAuthentication.SetAuthCookie(TextBoxUserName.Text, false);
Response.Redirect("Main/index.aspx");
}
else
{
Response.Write("<script>alert('工号密码不匹配！请重试！');</script>");
}
}
catch (Exception ex)
{
Response.Write("<script>alert('服务器错误！');</script>");
LogManager.Write(this, ex.ToString());
}
finally
{
sqlAccess.Close();
}
}
public void test1(string Barcode)
{
if (ComboBox1.SelectedItem.Value == "待定" || ComboBox2.SelectedItem.Value == "待定")
{
Ext.Msg.Alert("提示", "您必须选择工序和流向信息！").Show();
return;
}
//用户登陆名
string Id = SessionUser.ID;//"00002";//
//获取工序
//string[] process_probable = Hidden3.Text.Split('或');
string msg;
WSProcedureCtrl.ProcedureCtrl c = new MCSApp.WSProcedureCtrl.ProcedureCtrl();
WSProductTrace.ProductTrace P = new MCSApp.WSProductTrace.ProductTrace();
//如果品号未通过
if (!c.CheckModel(Barcode.Substring(0, 9), Id))
{
Ext.Msg.Alert("错误", "当前产品不是正在生产的产品。").Show();
return;
}
////这时还需要收集工艺信息
//if (Hidden4.Text == "待定")
//{
// //第一步：判断是否为新入工序的产品
// if (!c.CheckProcedure(Barcode, string.Empty, 0, out msg) && msg == "根据输入的条形码未查询到对应的产品")
// {
// P.SaveProduct(Id, Barcode, Barcode.Substring(0, 9), "", out msg);
// }
// //确定可能正确的工序
// for (int i = 0; i < process_probable.Length; i++)
// {
// if (c.CheckProcedure(Barcode, process_probable[i], 0, out msg))
// {
// Label3.Text = process_probable[i];
// Hidden3.Text = process_probable[i];
// Label4.Text = "入";
// Hidden4.Text = "入";
// break;
// }
// if (c.CheckProcedure(Barcode, process_probable[i], 1, out msg))
// {
// Label3.Text = process_probable[i];
// Hidden3.Text = process_probable[i];
// Label4.Text = "出";
// Hidden4.Text = "出";
// break;
// }
// }
// if (Hidden4.Text == "待定")
// {
// Ext.Msg.Alert("错误", msg).Show();
// return;
// }
if (Hidden_s.Value.ToString() != "")
{
Hidden_s.Value = string.Empty;
//自动提取已完工的数据清单
{
List<object[]> data = (List<object[]>)Cache["data"];
if (data == null) data = new List<object[]>();
string sql1 = "select ProductID, Name from dbo.TB_ProcedureHistory,dbo.TA_Employee where ProductID like '" + Barcode.Substring(0, 9) + "A%' and Process ='" + ComboBox1.SelectedItem.Value + "'";
if (ComboBox2.SelectedItem.Value == "出") sql1 += " and Result=0";
sql1 += " and TA_Employee.ID=EmployeeID";
SqlAccess sqlAccess = new SqlAccess();
DataTable mytab = sqlAccess.OpenQuerry(sql1).Tables[0];
foreach (DataRow row in mytab.Rows)
{
int id = (data.Count + 1);
string Barcode1 = row["ProductID"].ToString();
string ModelId = row["ProductID"].ToString().Substring(0, 9);
string PlanId = string.Empty;
string Process = ComboBox1.SelectedItem.Value;
string User = row["Name"].ToString();
{
SqlAccess sqlAccess1 = new SqlAccess();
DataRow myrow;
try
{
myrow = sqlAccess.OpenQuerry("select * from TC_PlanProcedure where ModelId= '" + ModelId + "'").Tables[0].Rows[0];
PlanId = myrow["PlanId"].ToString();
}
catch { }
}
data.Add(new object[] { id, Barcode1, PlanId, ModelId, Process, User });
}
Cache["data"] = data;
}
}
//}
//如果是新产品
if (!c.CheckProcedure(Barcode, string.Empty, 0, out msg) && msg == "根据输入的条形码未查询到对应的产品")
{
P.SaveProduct(Id, Barcode, Barcode.Substring(0, 9), "", out msg);
}
if (!c.CheckProcedure(Barcode, ComboBox1.SelectedItem.Value, ComboBox2.SelectedItem.Value == "入" ? 0 : 1, out msg))
{
Ext.Msg.Alert("错误", msg).Show();
return;
}
if (ComboBox2.SelectedItem.Value == "入")
{
if (!c.SaveProcessBegin(Barcode, ComboBox1.SelectedItem.Value, Id, DateTime.Now, out msg)) Ext.Msg.Alert("工序保存错误", msg);
}
if (ComboBox2.SelectedItem.Value == "出")
{
if (!c.SaveProcessEnd(Barcode, ComboBox1.SelectedItem.Value, 0, string.Empty, string.Empty, DateTime.Now, out msg)) Ext.Msg.Alert("工序保存错误", msg);
}
//下面是填充已扫描的列表数据--------------------------------------------------------------------------------------------------------------
{
List<object[]> data = (List<object[]>)Cache["data"];
if (data == null) data = new List<object[]>();
int id = (data.Count + 1);
string ModelId = Barcode.Substring(0, 9);
string PlanId = string.Empty;
string Process = ComboBox1.SelectedItem.Value;
string User = SessionUser.Name;
SqlAccess sqlAccess = new SqlAccess();
DataRow myrow;
try
{
myrow = sqlAccess.OpenQuerry("select * from TC_PlanProcedure where ModelId= '" + ModelId + "'").Tables[0].Rows[0];
}
catch { myrow = null; }
if (myrow != null)
{
PlanId = myrow["PlanId"].ToString();
data.Add(new object[] { id, Barcode, PlanId, ModelId, Process, User });
Cache["data"] = data;
}
else
{
Ext.Msg.Alert("警告", Barcode + "并不是正在生产的产品。").Show();
}
Cache["data"] = data;
this.Store2.DataSource = data;
this.Store2.DataBind();
}
}
/// <summary>
/// 根据用户信息获取部分信息
/// </summary>
protected void Msg_init()
{
string Id = SessionUser.ID;//"00002";//
SqlAccess sqlaccess = new SqlAccess();
string sql = @"select TA_Group.Name,TA_Group.PlanID
from dbo.TRE_Group_Employee,dbo.TA_Group,dbo.TA_Employee
where TA_Employee.ID='" + Id + @"'
and TA_Employee.ID=TRE_Group_Employee.EmployeeID
and TRE_Group_Employee.GroupID=TA_Group.ID";
DataRow row = null;
try
{
row = sqlaccess.OpenQuerry(sql).Tables[0].Rows[0];
}
catch { }
if (row != null)
{
Label1.Text = row["Name"].ToString();
Hidden1.Text = row["Name"].ToString();
Label2.Text = row["PlanID"].ToString();
Hidden2.Text = row["PlanID"].ToString();
}
string[,] groups = { { "预制", "装配", "调试", "电检", "包装" }, { "预制", "装配.总装", "调试.老化", "电检", "包装" } };
int groupIndex = 0;
for (int i = 0; i < 5; i++)
{
if (row["Name"].ToString().Contains(groups[0,i])) groupIndex = i;
}
foreach (string p in groups[1, groupIndex].Split('.'))
{
ComboBox1.Items.Add(new Coolite.Ext.Web.ListItem(p, p));
}
//寻找新定义的工序名称
DataSet ds = new DataSet();
string tmp = Database.DataCode("select ProcessConfig from dbo.TA_Procedure,TC_PlanProcedure where ProcedureID=TA_Procedure.ID AND TC_PlanProcedure.PlanID='" + Hidden2.Text.ToString() + "'");
XmlTextReader reader = new XmlTextReader(tmp, XmlNodeType.Document, null);
ds.ReadXml(reader);
foreach (DataRow row1 in ds.Tables[0].Rows)
{
if (row1["Range"].ToString().Contains(groups[0, groupIndex]))
{
groups[1, groupIndex] = groups[1, groupIndex] + "." + row1["Name"].ToString();
bool mark=false;
foreach (var a in ComboBox1.Items)
{
if (a.Value == row1["Name"].ToString()) mark = true;
}
if (!mark) ComboBox1.Items.Add(new Coolite.Ext.Web.ListItem(row1["Name"].ToString(), row1["Name"].ToString()));
}
}
//Label3.Text = groups[1, groupIndex].Replace(".", "或");
//Hidden3.Text = groups[1, groupIndex].Replace(".", "或");
}
private bool isAccountExist(string id, string Name)
{
bool isExist = false;
SqlAccess accesstmp = new SqlAccess();
string queryStr = "";
try
{
if ((bool)ViewState["newMark"])//新建态
{
queryStr = "select name from TA_Employee where id='" + id + "'";
}
else //更新态
{
//queryStr = "select name from TA_Employee where id<>'" + id + "'";
return false;
}
accesstmp.Open();
ds = accesstmp.OpenQuerry(queryStr);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
isExist = true;
}
return isExist;
}
catch (Exception ex)
{
LogManager.Write(this, ex.Message);
return true;
}
finally
{
accesstmp.Close();
}
}
