public bool InsertPoint(PointInfo point, DbTransaction tran)
{
object o = processor.QueryScalar("select 1 from pointinfo where id=" + point.ID.ToString(), null);
if (o != null && o.ToString() != "")
{
point.ID = GetPointPKValue() + 1;
}
return(processor.Insert <PointInfo>(point, tran));
}
public int GetDigitalSignaturePKValue()
{
object u = processor.QueryScalar("select max(id) from DigitalSignature", null);
if (u != null && u.ToString() != string.Empty)
{
return(Convert.ToInt32(u));
}
else
{
return(0);
}
}
public bool IsExist(string username, string right)
{
Dictionary <string, object> dic = new Dictionary <string, object> ();
dic.Add("username", username);
dic.Add("right", right);
object o = processor.QueryScalar("select 1 from userright where username=@username COLLATE NOCASE and right=@right", dic);
if (o == null || o.ToString() == "")
{
return(false);
}
return(true);
}
/// <summary>
/// 插入用户操作日志
/// </summary>
/// <param name="dic"></param>
/// <returns></returns>
public bool InsertLog(Dictionary <string, object> dic)
{
OperationLog log = new OperationLog();
if (dic.Keys.Contains("ID"))
{
log.ID = (int)dic.First(p => { return(p.Key == "ID"); }).Value;
}
else
{
object o = processor.QueryScalar("select max(id) from OperationLog", null);
int id = 0;
if (o != null && !string.IsNullOrEmpty(o.ToString()))
{
id = Convert.ToInt32(o);
}
log.ID = id + 1;
}
log.Operatetime = (DateTime)dic.First(p => { return(p.Key == "OperateTime"); }).Value;
log.Action = (string)dic.First(p => { return(p.Key == "Action"); }).Value;
log.Username = (string)dic.First(p => { return(p.Key == "UserName"); }).Value;
log.Fullname = (string)dic.First(p => { return(p.Key == "FullName"); }).Value;
log.Detail = (string)dic.First(p => { return(p.Key == "Detail"); }).Value;
log.LogType = (int)dic.First(p => { return(p.Key == "LogType"); }).Value;//0系统，1分析
return(this.InsertLog(log));
}
private int GetCurrentUserId()
{
object u = processor.QueryScalar("select max(userid) from userinfo", null);
if (u != null && u.ToString() != string.Empty)
{
return(Convert.ToInt32(u));
}
else
{
return(0);
}
}
public int GetAlarmConfigPKValue()
{
object u = processor.QueryScalar("select max(id) from AlarmConfig", null);
if (u != null && u.ToString() != string.Empty)
{
return(Convert.ToInt32(u));
}
else
{
return(0);
}
}
/// <summary>
/// 插入relation
/// </summary>
/// <param name="username"></param>
/// <param name="dic"></param>
/// <returns></returns>
public bool InsertMeanRel(string username, Dictionary <string, object> dic, DbTransaction tran)
{
/*先查询是否存在username->meaning的关系*/
Dictionary <string, object> condition = new Dictionary <string, object>();
condition.Add("username", username);
condition.Add("desc", dic["Desc"]);
object o = processor.QueryScalar("select 1 from UserMeanRelation where username=@username and MeaningDesc=@desc", condition);
if (o == null || o.ToString() == "")
{
UserMeanRelation rel = new UserMeanRelation();
//if (dic.Keys.Contains("mID"))
// rel.MeaningsID = (int)dic.First(p => p.Key == "mID").Value;
//else
//{
//查询meaning id
// Meanings m = this.GetMeaningByName(dic["Desc"].ToString());
//if(m!=null&&m.Id!=0)
//{
if (dic.Keys.Contains("ID"))
{
rel.ID = (int)dic.First(p => { return(p.Key == "ID"); }).Value;
}
else
{
int id = this.GetRelationPKValue();
rel.ID = id + 1;
}
rel.MeaningDesc = dic["Desc"].ToString();
rel.Username = username;
rel.Remark = DateTime.Now.ToString();
return(processor.Insert <UserMeanRelation>(rel, tran));
//}
}
return(false);
}
/// <summary>
/// 查询是否存在用户列表
/// </summary>
/// <returns></returns>
public bool QueryUser()
{
try
{
object o = processor.QueryScalar("SELECT count(1) FROM UserInfo ", null);
if (o != null && o.ToString() != "0")
{
return(true);
}
else
{
return(false);
}
}
catch (Exception exc) { return(false); }
}
private void OK(object sender, EventArgs args)
{
if (processor == null)
{
processor = new DeviceProcessor();
}
if (this.tbMean.Text == string.Empty)
{
MessageBox.Show("Please input the meaning");
}
else
{
if (meaning == null)
{
Meanings mean = new Meanings();
object o = processor.QueryScalar("SELECT MAX(ID) FROM Meanings", null);
mean.Id = o != null && o.ToString() != string.Empty ? Convert.ToInt32(o) + 1 : 1;
mean.Desc = this.tbMean.Text.TrimEnd();
mean.Remark = DateTime.Now.ToString();
if (processor.Insert <Meanings>(mean, null))
{
form.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("Saved Failure");
form.DialogResult = DialogResult.No;
}
}
else
{
Meanings mean = new Meanings();
mean.Id = meaning.First().Key;
mean.Desc = this.tbMean.Text.TrimEnd();
mean.Remark = DateTime.Now.ToString();
if (processor.Update <Meanings>(mean, null))
{
form.DialogResult = MessageBox.Show("Saved Successfully");
}
else
{
MessageBox.Show("Saved Failure");
form.DialogResult = DialogResult.No;
}
}
}
}
private void InitEvents()
{
/*删除用户*/
this.btnDelete.Click += new EventHandler(delegate(object sender, EventArgs args)
{
DataTable dt = dgvUser.DataSource as DataTable;
if (null != dt)
{
Dictionary <string, object> dic;
foreach (DataGridViewRow row in this.dgvUser.SelectedRows)
{
dic = new Dictionary <string, object>();
dic.Add("username", row.Cells["User Name"].Value.ToString());
processor.ExecuteNonQuery("DELETE FROM USERINFO WHERE username=@username", dic);
dt.Rows.RemoveAt(row.Index);
}
//this.InitUsers();
this.dgvUser.DataSource = dt;
}
});
/*删除meanings*/
this.btnDelMean.Click += new EventHandler(delegate(object sender, EventArgs args)
{
object o = this.clbMeaning.SelectedValue;
if (o == null && o.ToString() == string.Empty)
{
MessageBox.Show("Please select the item!");
}
else
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("id", o.ToString());
processor.ExecuteNonQuery("DELETE FROM Meanings WHERE id=@id", dic);
processor.ExecuteNonQuery("DELETE FROM UserMeanRelation WHERE MeaningsID=@id", dic);
//this.InitMeaning();
/* 重新绑定数据源 取消从数据库中读取*/
List <Meanings> list = this.clbMeaning.DataSource as List <Meanings>;
if (list != null)
{
list = new List <Meanings>(list);//it does not make sense? it is bugged?
list.Remove(this.clbMeaning.SelectedItem as Meanings);
this.clbMeaning.DataSource = list;
this.clbMeaning.ValueMember = "ID";
this.clbMeaning.DisplayMember = "Desc";
}
}
});
#region comment itemcheck
/*list check event*/
this.clbMeaning.ItemCheck += new ItemCheckEventHandler(delegate(object sender, ItemCheckEventArgs args)
{
if (!flag)
{
return;
}
if (this.dgvUser.SelectedRows.Count <= 0)
{
MessageBox.Show("Please select the user!");
args.NewValue = args.CurrentValue;
}
else
{
Dictionary <string, object> dic = new Dictionary <string, object>();
int meanid = ((Meanings)clbMeaning.SelectedItem).Id;
string username = this.dgvUser.SelectedRows[0].Cells["User Name"].Value.ToString();
dic.Add("MeaningsID", meanid);
dic.Add("username", username);
object obj = processor.QueryScalar("SELECT 1 FROM UserMeanRelation where MeaningsID=@MeaningsID AND username=@username", dic);
if (args.NewValue == CheckState.Checked && obj == null)//添加
{
obj = processor.QueryScalar("SELECT MAX(ID) FROM UserMeanRelation", null);
UserMeanRelation u = new UserMeanRelation();
u.ID = obj != null && obj.ToString() != string.Empty ? Convert.ToInt32(obj) + 1 : 1;
//u.MeaningsID = meanid;
u.Username = username;
u.MeaningDesc = ((Meanings)clbMeaning.SelectedItem).Desc;
u.Remark = DateTime.Now.ToString();
if (processor.Insert <UserMeanRelation>(u, null))
{
return;//MessageBox.Show("Add the meaning to " + username + " successfully!");
}
else
{
MessageBox.Show("Add the meaning to " + username + " error!");
}
}
else if (args.NewValue == CheckState.Unchecked && obj != null)
{
processor.ExecuteNonQuery("DELETE FROM UserMeanRelation WHERE MeaningsID=@MeaningsID AND username=@username ", dic);
}
}
});
#endregion
//selection changed
this.dgvUser.SelectionChanged += new EventHandler(delegate(object sender, EventArgs args)
{
this.UserSelectedChange();
});
#region comment
//this.clbMeaning.SelectedIndexChanged += new EventHandler(delegate(object sender, EventArgs args)
//{
// if (!flag) return;
// CheckState ck = this.clbMeaning.GetItemCheckState(clbMeaning.Items.IndexOf(clbMeaning.SelectedItem));
// if (this.dgvUser.SelectedRows.Count <= 0)
// {
// MessageBox.Show("Please select the user!");
// //args.NewValue = args.CurrentValue;
// }
// else
// {
// Dictionary<string, object> dic = new Dictionary<string, object>();
// int meanid = ((Meanings)clbMeaning.SelectedItem).Id;
// string username = this.dgvUser.SelectedRows[0].Cells["User Name"].Value.ToString();
// dic.Add("MeaningsID", meanid);
// dic.Add("username", username);
// object obj = processor.QueryScalar("SELECT 1 FROM UserMeanRelation where MeaningsID=@MeaningsID AND username=@username", dic);
// if (ck == CheckState.Unchecked && obj == null)//添加
// {
// obj = processor.QueryScalar("SELECT MAX(ID) FROM UserMeanRelation", null);
// UserMeanRelation u = new UserMeanRelation();
// u.ID = obj != null && obj.ToString() != string.Empty ? Convert.ToInt32(obj) + 1 : 1;
// u.MeaningsID = meanid;
// u.Username = username;
// u.MeaningDesc = ((Meanings)clbMeaning.SelectedItem).Desc;
// u.Remark = DateTime.Now.ToString();
// if (processor.Insert<UserMeanRelation>(u, null))
// {
// //MessageBox.Show("Add the meaning to " + username + " successfully!");
// this.clbMeaning.SetItemCheckState(this.clbMeaning.SelectedIndex, ck == CheckState.Checked ? CheckState.Unchecked : CheckState.Checked);
// }
// else
// MessageBox.Show("Add the meaning to " + username + " error!");
// }
// else if (ck == CheckState.Checked && obj != null)
// {
// processor.ExecuteNonQuery("DELETE FROM UserMeanRelation WHERE MeaningsID=@MeaningsID AND username=@username ", dic);
// this.clbMeaning.SetItemCheckState(this.clbMeaning.SelectedIndex, ck == CheckState.Checked ? CheckState.Unchecked : CheckState.Checked);
// }
// }
//});
#endregion
}