/// <summary>
/// 按条件删除数据
/// </summary>
/// <returns></returns>
public int Delete(HashTableExp hash, String sqlWhere)
{
string sql = "delete from Temp_Data where 1=1 ";
#region 查询条件
if (hash != null)
{
if (hash["Id"] != null)
{
sql += string.Format(" and Id='{0}'", hash["Id"]);
}
if (hash["Email"] != null)
{
sql += string.Format(" and Email='{0}'", hash["Email"]);
}
if (hash["Expires"] != null)
{
sql += string.Format(" and Expires='{0}'", hash["Expires"]);
}
if (hash["CreateTime"] != null)
{
sql += string.Format(" and Create_Time='{0}'", hash["CreateTime"]);
}
}
#endregion
sql += sqlWhere;
return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, null));
}
/// <summary>
/// 数据库删除分组信息
/// </summary>
/// <param name="groupId"></param>
/// <returns></returns>
private bool WriteDbDeleteGrpInfomation(int groupId)
{
var strSql = "delete from grp_para where grp_id= " + groupId;
//SQLiteHelper.ExecuteNonQueryInThread(strSql);
// return true;
return SqlLiteHelper.ExecuteNonQuery(strSql) > 0;
}
private void button3_Click(object sender, EventArgs e)
{
//设定 comb1
if (dataGridView1.CurrentCell != null)
{
if (comboBox1.SelectedItem is AlarmStrategy)
{
AlarmStrategy cas = comboBox1.SelectedItem as AlarmStrategy;
//此处还应该操作数据库 使用helper+手写sql语句
if (dataGridView1.CurrentCell.Value is DateCell && (dataGridView1.CurrentCell.Value as DateCell).AS != cas)
{
DateCell dc = dataGridView1.CurrentCell.Value as DateCell;
dc.AS = cas;
dataGridView1.Refresh();
if (CurrentSensor.AlarmDic.ContainsKey(dc.YYYYMMDD))
{
CurrentSensor.AlarmDic[dc.YYYYMMDD] = cas;
//UPDATE SQL
string updateSql = string.Format("UPDATE T_ALARM_SENSOR_MAP SET aname='{0}' WHERE date='{1}' AND uid='{2}' AND node='{3}' AND port='{4}'", cas.Name, dc.YYYYMMDD, CurrentSensor.Uid, CurrentSensor.NodeId, CurrentSensor.PortId);
SqlLiteHelper.ExecuteNonQuery(db, updateSql);
}
else
{
CurrentSensor.AlarmDic.Add(dc.YYYYMMDD, cas);
//insert
string insertSql = string.Format("INSERT INTO T_ALARM_SENSOR_MAP (aname,date,uid,node,port) VALUES('{0}','{1}','{2}','{3}','{4}')", cas.Name, dc.YYYYMMDD, CurrentSensor.Uid, CurrentSensor.NodeId, CurrentSensor.PortId);
SqlLiteHelper.ExecuteNonQuery(db, insertSql);
}
}
}
}
}
/// <summary>
/// 按条件删除数据
/// </summary>
/// <returns></returns>
public int Delete(HashTableExp hash, String sqlWhere)
{
string sql = "delete from Role_To_Module where 1=1 ";
#region 查询条件
if (hash != null)
{
if (hash["Id"] != null)
{
sql += string.Format(" and Id='{0}'", hash["Id"]);
}
if (hash["RoleId"] != null)
{
sql += string.Format(" and Role_Id='{0}'", hash["RoleId"]);
}
if (hash["ModuleId"] != null)
{
sql += string.Format(" and Module_Id='{0}'", hash["ModuleId"]);
}
}
#endregion
sql += sqlWhere;
return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, null));
}
private void WriteUpdateDbByPrivate(int instancesId)
{
//menu_instances_relation id(father_id,id,sort_index,name,instances_id)
SqlLiteHelper.ExecuteNonQuery("delete from menu_instances_relation where instances_id=" + instancesId);
if (!DicInstanceRelation.ContainsKey(instancesId))
{
return;
}
foreach (var t in DicInstanceRelation[instancesId])
{
try
{
string strUpdateDirectroy =
"insert into menu_instances_relation(father_id,id,sort_index,name,instances_id) values";
strUpdateDirectroy += "(" + t.Value.FatherId + "," + t.Value.Id + "," + t.Value.SortIndex + ",'" +
t.Value.Name + "'," + t.Value.InstancesId + ")";
SqlLiteHelper.ExecuteNonQueryInThread(strUpdateDirectroy);
}
catch (Exception ex)
{
WriteLog.WriteLogError(
"Class MenuInstanceRelationHoldingExtend Function WriteUpdateDbByPrivate from SQLlite table menu_instances_relation Occer an Error:" +
ex.ToString());
}
}
}
private void WriteUpdateDbByPrivate(int keyId)
{
SqlLiteHelper.ExecuteNonQuery("delete from menu_classic where id=" + keyId);
if (!DicClassic.ContainsKey(keyId))
{
return;
}
string content = "";
foreach (var t in DicClassic[keyId].Items)
{
content += t;
content += "#";
}
string strUpdateDirectroy = "insert into menu_classic(id,name,content) values";
strUpdateDirectroy += "(" + keyId + ",'" + DicClassic[keyId].Name + "','" + content + "')";
try
{
SqlLiteHelper.ExecuteNonQueryInThread(strUpdateDirectroy);
}
catch (Exception ex)
{
ex.ToString();
}
}
private void Field_StateChanged(object sender, EventArgs e)
{
Field field = sender as Field;
AlarmInfo ai = new AlarmInfo();
ai.Time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
ai.Field = field.Alias;
ai.GroupName = field.CurrentSensor.GroupName;
ai.Comment = field.CurrentSensor.Comment;
switch (field.State)
{
case 0:
ai.State = state0;
break;
case 1:
ai.State = state1;
break;
case 2:
ai.State = state2;
break;
}
dt.Rows.Add(ai.Time, ai.Field, ai.GroupName, ai.Comment, ai.State);
string insertSql = string.Format("INSERT INTO record(time,field,groupname,comment,state) VALUES('{0}','{1}','{2}','{3}','{4}')", ai.Time, ai.Field, ai.GroupName, ai.Comment, ai.State);
try
{
SqlLiteHelper.ExecuteNonQuery(db, insertSql);
}
catch (Exception ex)
{
Utils.WriteEX(ex);
}
}
/// <summary>
/// 按条件删除数据
/// </summary>
/// <returns></returns>
public int Delete(HashTableExp hash, String sqlWhere)
{
string sql = "delete from Bank_Card where 1=1 ";
#region 查询条件
if (hash != null)
{
if (hash["Id"] != null)
{
sql += string.Format(" and Id='{0}'", hash["Id"]);
}
if (hash["Time"] != null)
{
sql += string.Format(" and TIME='{0}'", hash["Time"]);
}
if (hash["Price"] != null)
{
sql += string.Format(" and Price='{0}'", hash["Price"]);
}
if (hash["SaveType"] != null)
{
sql += string.Format(" and Save_Type='{0}'", hash["SaveType"]);
}
if (hash["Balance"] != null)
{
sql += string.Format(" and Balance='{0}'", hash["Balance"]);
}
if (hash["BankType"] != null)
{
sql += string.Format(" and Bank_Type='{0}'", hash["BankType"]);
}
if (hash["Note"] != null)
{
sql += string.Format(" and Note='{0}'", hash["Note"]);
}
if (hash["CreateBy"] != null)
{
sql += string.Format(" and Create_By='{0}'", hash["CreateBy"]);
}
if (hash["CreateTime"] != null)
{
sql += string.Format(" and Create_Time='{0}'", hash["CreateTime"]);
}
if (hash["UpdateBy"] != null)
{
sql += string.Format(" and UpDate_By='{0}'", hash["UpdateBy"]);
}
if (hash["UpdateTime"] != null)
{
sql += string.Format(" and UpDate_Time='{0}'", hash["UpdateTime"]);
}
}
#endregion
sql += sqlWhere;
return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, null));
}
/// <summary>
/// 按条件删除数据
/// </summary>
/// <returns></returns>
public int Delete(HashTableExp hash, String sqlWhere)
{
string sql = "delete from Lifing_Cost where 1=1 ";
#region 查询条件
if (hash != null)
{
if (hash["Id"] != null)
{
sql += string.Format(" and Id='{0}'", hash["Id"]);
}
if (hash["Time"] != null)
{
sql += string.Format(" and TIME='{0}'", hash["Time"]);
}
if (hash["Reason"] != null)
{
sql += string.Format(" and Reason='{0}'", hash["Reason"]);
}
if (hash["Price"] != null)
{
sql += string.Format(" and Price='{0}'", hash["Price"]);
}
if (hash["CostTypeId"] != null)
{
sql += string.Format(" and Cost_Type_Id='{0}'", hash["CostTypeId"]);
}
if (hash["Notes"] != null)
{
sql += string.Format(" and Notes='{0}'", hash["Notes"]);
}
if (hash["ImgUrl"] != null)
{
sql += string.Format(" and Img_Url='{0}'", hash["ImgUrl"]);
}
if (hash["CreateBy"] != null)
{
sql += string.Format(" and Create_By='{0}'", hash["CreateBy"]);
}
if (hash["CreateTime"] != null)
{
sql += string.Format(" and Create_Time='{0}'", hash["CreateTime"]);
}
if (hash["UpdateBy"] != null)
{
sql += string.Format(" and UpDate_By='{0}'", hash["UpdateBy"]);
}
if (hash["UpdateTime"] != null)
{
sql += string.Format(" and UpDate_Time='{0}'", hash["UpdateTime"]);
}
}
#endregion
sql += sqlWhere;
return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, null));
}
/// <summary>
/// 修改用户角色对应表
/// </summary>
/// <param name="index">用户角色对应表对象</param>
/// <returns></returns>
public int Update(UserToRole index)
{
string sql = "update User_To_Role set Id=@Id,User_Id=@User_Id,Role_Id=@Role_Id where Id=@Id";
SQLiteParameter[] parm = new SQLiteParameter[] {
new SQLiteParameter("@Id", index.Id),
new SQLiteParameter("@User_Id", index.UserId),
new SQLiteParameter("@Role_Id", index.RoleId)
};
return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, parm));
}
/// <summary>
/// 修改角色模块对应表
/// </summary>
/// <param name="index">角色模块对应表对象</param>
/// <returns></returns>
public int Update(RoleToModule index)
{
string sql = "update Role_To_Module set Id=@Id,Role_Id=@Role_Id,Module_Id=@Module_Id where Id=@Id";
SQLiteParameter[] parm = new SQLiteParameter[] {
new SQLiteParameter("@Id", index.Id),
new SQLiteParameter("@Role_Id", index.RoleId),
new SQLiteParameter("@Module_Id", index.ModuleId)
};
return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, parm));
}
/// <summary>
/// 修改角色表
/// </summary>
/// <param name="index">角色表对象</param>
/// <returns></returns>
public int Update(Roles index)
{
string sql = "update Roles set Role_Id=@Role_Id,Role_Name=@Role_Name,Notes=@Notes where Role_Id=@Role_Id";
SQLiteParameter[] parm = new SQLiteParameter[] {
new SQLiteParameter("@Role_Id", index.RoleId),
new SQLiteParameter("@Role_Name", index.RoleName),
new SQLiteParameter("@Notes", index.Notes)
};
return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, parm));
}
private void button3_Click(object sender, EventArgs e)
{
//保存
if (CAS.Name == null)
{
if (!SetName())
{
return;
}
}
if (CASCopy != null)
{
//编辑保存 //更新Alarm和Map
string usql = CASOrgin.CompareTo(CAS);
if (!string.IsNullOrWhiteSpace(usql))
{
//万一有人用这个策略咋办 此处想个办法调出Sensor的字典修改其引用.
//ConfigData.AllStrategy[ConfigData.AllStrategy.IndexOf(CASOrgin)] = CAS;
if (ConfigData.AllStrategy.Contains(CASOrgin))
{
int i = ConfigData.AllStrategy.IndexOf(CASOrgin);
ConfigData.AllStrategy[i] = CAS;
}
foreach (var item in ConfigData.allSensors)
{
for (int i = 0; i < item.AlarmDic.Keys.Count; i++)
{
if (item.AlarmDic[item.AlarmDic.Keys.ElementAt(i)] == CASOrgin)
{
item.AlarmDic[item.AlarmDic.Keys.ElementAt(i)] = CAS;
}
}
}
SqlLiteHelper.ExecuteNonQuery(db, usql);
userCalendar.DateTimePicker1_ValueChanged(null, null);
}
}
else //新建保存
{
foreach (var item in CAS.A24s)
{
string insertSql = @"INSERT INTO T_ALARM(name,field,warn,h0t,h0l,h1t,h1l,h2t,h2l,h3t,h3l,h4t,h4l,h5t,h5l,h6t,h6l,h7t,h7l,
h8t,h8l,h9t,h9l,h10t,h10l,h11t,h11l,h12t,h12l,h13t,h13l,h14t,h14l,h15t,h15l,h16t,h16l,h17t,h17l,h18t,h18l,h19t,h19l,h20t,h20l,h21t,h21l,h22t,h22l,h23t,h23l)
VALUES('" + CAS.Name + "','" + item.Field + "','" + item.Warn + "','" + item.Hs[0].Top + "','" + item.Hs[0].Low + "','" + item.Hs[1].Top + "','" + item.Hs[1].Low + "','" + item.Hs[2].Top + "','" + item.Hs[2].Low + "','" + item.Hs[3].Top + "','" + item.Hs[3].Low + "','" + item.Hs[4].Top + "','" + item.Hs[4].Low + "','" + item.Hs[5].Top + "','" + item.Hs[5].Low + "','" + item.Hs[6].Top + "','" + item.Hs[6].Low + "','" + item.Hs[7].Top + "','" + item.Hs[7].Low +
"','" + item.Hs[8].Top + "','" + item.Hs[8].Low + "','" + item.Hs[9].Top + "','" + item.Hs[9].Low + "','" + item.Hs[10].Top + "','" + item.Hs[10].Low + "','" + item.Hs[11].Top + "','" + item.Hs[11].Low + "','" + item.Hs[12].Top + "','" + item.Hs[12].Low + "','" + item.Hs[13].Top + "','" + item.Hs[13].Low + "','" + item.Hs[14].Top + "','" + item.Hs[14].Low + "','" + item.Hs[15].Top + "','" + item.Hs[15].Low + "','" + item.Hs[16].Top + "','" + item.Hs[16].Low + "','" + item.Hs[17].Top + "','" + item.Hs[17].Low +
"','" + item.Hs[18].Top + "','" + item.Hs[18].Low + "','" + item.Hs[19].Top + "','" + item.Hs[19].Low + "','" + item.Hs[20].Top + "','" + item.Hs[20].Low + "','" + item.Hs[21].Top + "','" + item.Hs[21].Low + "','" + item.Hs[22].Top + "','" + item.Hs[22].Low + "','" + item.Hs[23].Top + "','" + item.Hs[23].Low + "')";
SqlLiteHelper.ExecuteNonQuery(db, insertSql);
}
ConfigData.AllStrategy.Add(CAS);
userCalendar.RefreshComb();
}
this.Visible = false;
this.userCalendar.Visible = true;
}
/// <summary>
/// 增加角色表
/// </summary>
/// <param name="index">角色表对象</param>
/// <returns></returns>
public int Add(Roles index)
{
string sql = string.Format("insert into Roles(Role_Id,Role_Name,Notes) values(@Role_Id,@Role_Name,@Notes)");
SQLiteParameter[] parm = new SQLiteParameter[] {
new SQLiteParameter("@Role_Id", index.RoleId),
new SQLiteParameter("@Role_Name", index.RoleName),
new SQLiteParameter("@Notes", index.Notes)
};
return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, parm));
}
/// <summary>
/// 增加角色模块对应表
/// </summary>
/// <param name="index">角色模块对应表对象</param>
/// <returns></returns>
public int Add(RoleToModule index)
{
string sql = string.Format("insert into Role_To_Module(Id,Role_Id,Module_Id) values(@Id,@Role_Id,@Module_Id)");
SQLiteParameter[] parm = new SQLiteParameter[] {
new SQLiteParameter("@Id", index.Id),
new SQLiteParameter("@Role_Id", index.RoleId),
new SQLiteParameter("@Module_Id", index.ModuleId)
};
return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, parm));
}
private void button1_Click(object sender, EventArgs e)
{
string db = Path.Combine(Utils.GetUserPath(), "alarm.db");
string sql = "SELECT COUNT(*) FROM sqlite_master where type = 'table' and name = 'record'";
object obj = SqlLiteHelper.ExecuteScalar(db, sql);
if (Convert.ToInt32(obj) == 0)
{
string createSql = "CREATE TABLE record(time varchar(50),field varchar(50),groupname varchar(50),comment varchar(50),state varchar(50))";
int res = SqlLiteHelper.ExecuteNonQuery(db, createSql);
}
}
/// <summary>
/// 修改临时信息存储表
/// </summary>
/// <param name="index">临时信息存储表对象</param>
/// <returns></returns>
public int Update(TempData index)
{
string sql = "update Temp_Data set Id=@Id,Email=@Email,Expires=@Expires,Create_Time=@Create_Time where Id=@Id";
SQLiteParameter[] parm = new SQLiteParameter[] {
new SQLiteParameter("@Id", index.Id),
new SQLiteParameter("@Email", index.Email),
new SQLiteParameter("@Expires", index.Expires),
new SQLiteParameter("@Create_Time", index.CreateTime)
};
return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, parm));
}
/// <summary>
/// 增加临时信息存储表
/// </summary>
/// <param name="index">临时信息存储表对象</param>
/// <returns></returns>
public int Add(TempData index)
{
string sql = string.Format("insert into Temp_Data(Id,Email,Expires,Create_Time) values(@Id,@Email,@Expires,@Create_Time)");
SQLiteParameter[] parm = new SQLiteParameter[] {
new SQLiteParameter("@Id", index.Id),
new SQLiteParameter("@Email", index.Email),
new SQLiteParameter("@Expires", index.Expires),
new SQLiteParameter("@Create_Time", index.CreateTime)
};
return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, parm));
}
/// <summary>
/// 将汉化将使用的语言写入数据库 下次启动时自动加载汉化版本
/// </summary>
/// <param name="culture"></param>
public void SetCultureToDb(string culture)
{
try
{
SqlLiteHelper.ExecuteNonQuery("delete from i36n_culture");
string strUpdateDirectroy = "insert into i36n_culture(culture) values ('" + culture.Trim() + "')";
SqlLiteHelper.ExecuteNonQuery(strUpdateDirectroy);
}
catch (Exception ex)
{
ex.ToString();
}
}
/// <summary>
/// 增加收入记录表
/// </summary>
/// <param name="index">收入记录表对象</param>
/// <returns></returns>
public int Add(Student index)
{
string sql = string.Format("insert into Student(id,name,card_no,birth_day,sex,addr,remark) values(@id,@name,@card_no,@birth_day,@sex,@addr,@remark)");
SQLiteParameter[] parm = new SQLiteParameter[] {
new SQLiteParameter("@id", index.Id),
new SQLiteParameter("@name", index.Name),
new SQLiteParameter("@card_no", index.CardNo),
new SQLiteParameter("@birth_day", index.BirthDay),
new SQLiteParameter("@sex", index.Sex),
new SQLiteParameter("@addr", index.Addr),
new SQLiteParameter("@remark", index.Remark)
};
return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, parm));
}
/// <summary>
/// 修改收入记录表
/// </summary>
/// <param name="index">收入记录表对象</param>
/// <returns></returns>
public int Update(Student index)
{
string sql = "update Student set id=@id,name=@name,card_no=@card_no,birth_day=@birth_day,sex=@sex,addr=@addr,remark=@remark where id=@id";
SQLiteParameter[] parm = new SQLiteParameter[] {
new SQLiteParameter("@id", index.Id),
new SQLiteParameter("@name", index.Name),
new SQLiteParameter("@card_no", index.CardNo),
new SQLiteParameter("@birth_day", index.BirthDay),
new SQLiteParameter("@sex", index.Sex),
new SQLiteParameter("@addr", index.Addr),
new SQLiteParameter("@remark", index.Remark)
};
return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, parm));
}
/// <summary>
/// 修改文章类型表
/// </summary>
/// <param name="index">文章类型表对象</param>
/// <returns></returns>
public int Update(ArtCategory index)
{
string sql = "update Art_Category set Cat_Id=@Cat_Id,Cat_Name=@Cat_Name,Cat_Remark=@Cat_Remark,Cat_Order=@Cat_Order,Create_By=@Create_By,Create_Time=@Create_Time,UpDate_By=@UpDate_By,UpDate_Time=@UpDate_Time where Cat_Id=@Cat_Id";
SQLiteParameter[] parm = new SQLiteParameter[] {
new SQLiteParameter("@Cat_Id", index.CatId),
new SQLiteParameter("@Cat_Name", index.CatName),
new SQLiteParameter("@Cat_Remark", index.CatRemark),
new SQLiteParameter("@Cat_Order", index.CatOrder),
new SQLiteParameter("@Create_By", index.CreateBy),
new SQLiteParameter("@Create_Time", index.CreateTime),
new SQLiteParameter("@UpDate_By", index.UpdateBy),
new SQLiteParameter("@UpDate_Time", index.UpdateTime)
};
return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, parm));
}
public int Add(Module index)
{
string sql = string.Format("insert into Module(Module_ID,Module_Name,Module_URL,Icon_Url,Parent_Id,Order_Id,Notes,STATUS) values(@Module_ID,@Module_Name,@Module_URL,@Icon_Url,@Parent_Id,@Order_Id,@Notes,@STATUS)");
SQLiteParameter[] parm = new SQLiteParameter[] {
new SQLiteParameter("@Module_ID", index.ModuleId),
new SQLiteParameter("@Module_Name", index.ModuleName),
new SQLiteParameter("@Module_URL", index.ModuleUrl),
new SQLiteParameter("@Icon_Url", index.IconUrl),
new SQLiteParameter("@Parent_Id", index.ParentId),
new SQLiteParameter("@Order_Id", index.OrderId),
new SQLiteParameter("@Notes", index.Notes),
new SQLiteParameter("@STATUS", index.Status)
};
return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, parm));
}
/// <summary>
/// 修改模块表
/// </summary>
/// <param name="index">模块表对象</param>
/// <returns></returns>
public int Update(Module index)
{
string sql = "update Module set Module_ID=:Module_ID,Module_Name=:Module_Name,Module_URL=:Module_URL,Icon_Url=:Icon_Url,Parent_Id=:Parent_Id,Order_Id=:Order_Id,Notes=:Notes,STATUS=:STATUS where Module_ID=:Module_ID";
SQLiteParameter[] parm = new SQLiteParameter[] {
new SQLiteParameter(":Module_ID", index.ModuleId),
new SQLiteParameter(":Module_Name", index.ModuleName),
new SQLiteParameter(":Module_URL", index.ModuleUrl),
new SQLiteParameter(":Icon_Url", index.IconUrl),
new SQLiteParameter(":Parent_Id", index.ParentId),
new SQLiteParameter(":Order_Id", index.OrderId),
new SQLiteParameter(":Notes", index.Notes),
new SQLiteParameter(":STATUS", index.Status)
};
return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, parm));
}
/// <summary>
/// 增加文章表
/// </summary>
/// <param name="index">文章表对象</param>
/// <returns></returns>
public int Add(Article index)
{
string sql = string.Format("insert into Article(Id,Title,Content,Cate_Id,Create_By,Create_Time,UpDate_By,UpDate_Time) values(@Id,@Title,@Content,@Cate_Id,@Create_By,@Create_Time,@UpDate_By,@UpDate_Time)");
SQLiteParameter[] parm = new SQLiteParameter[] {
new SQLiteParameter("@Id", index.Id),
new SQLiteParameter("@Title", index.Title),
new SQLiteParameter("@Content", index.Content),
new SQLiteParameter("@Cate_Id", index.CateId),
new SQLiteParameter("@Create_By", index.CreateBy),
new SQLiteParameter("@Create_Time", index.CreateTime),
new SQLiteParameter("@UpDate_By", index.UpdateBy),
new SQLiteParameter("@UpDate_Time", index.UpdateTime)
};
return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, parm));
}
/// <summary>
/// 修改文章表
/// </summary>
/// <param name="index">文章表对象</param>
/// <returns></returns>
public int Update(Article index)
{
string sql = "update Article set Id=@Id,Title=@Title,Content=@Content,Cate_Id=@Cate_Id,Create_By=@Create_By,Create_Time=@Create_Time,UpDate_By=@UpDate_By,UpDate_Time=@UpDate_Time where Id=@Id";
SQLiteParameter[] parm = new SQLiteParameter[] {
new SQLiteParameter("@Id", index.Id),
new SQLiteParameter("@Title", index.Title),
new SQLiteParameter("@Content", index.Content),
new SQLiteParameter("@Cate_Id", index.CateId),
new SQLiteParameter("@Create_By", index.CreateBy),
new SQLiteParameter("@Create_Time", index.CreateTime),
new SQLiteParameter("@UpDate_By", index.UpdateBy),
new SQLiteParameter("@UpDate_Time", index.UpdateTime)
};
return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, parm));
}
/// <summary>
/// 增加文章类型表
/// </summary>
/// <param name="index">文章类型表对象</param>
/// <returns></returns>
public int Add(ArtCategory index)
{
string sql = string.Format("insert into Art_Category(Cat_Id,Cat_Name,Cat_Remark,Cat_Order,Create_By,Create_Time,UpDate_By,UpDate_Time) values(@Cat_Id,@Cat_Name,@Cat_Remark,@Cat_Order,@Create_By,@Create_Time,@UpDate_By,@UpDate_Time)");
SQLiteParameter[] parm = new SQLiteParameter[] {
new SQLiteParameter("@Cat_Id", index.CatId),
new SQLiteParameter("@Cat_Name", index.CatName),
new SQLiteParameter("@Cat_Remark", index.CatRemark),
new SQLiteParameter("@Cat_Order", index.CatOrder),
new SQLiteParameter("@Create_By", index.CreateBy),
new SQLiteParameter("@Create_Time", index.CreateTime),
new SQLiteParameter("@UpDate_By", index.UpdateBy),
new SQLiteParameter("@UpDate_Time", index.UpdateTime)
};
return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, parm));
}
/// <summary>
/// 修改用户表
/// </summary>
/// <param name="index">用户表对象</param>
/// <returns></returns>
public int Update(Users index)
{
string sql = "update Users set Id=@Id,Login_Id=@Login_Id,Login_Pwd=@Login_Pwd,Name=@Name,Phone=@Phone,Mail=@Mail,Address=@Address,Age=@Age,Notes=@Notes where Id=@Id";
SQLiteParameter[] parm = new SQLiteParameter[] {
new SQLiteParameter("@Id", index.Id),
new SQLiteParameter("@Login_Id", index.LoginId),
new SQLiteParameter("@Login_Pwd", index.LoginPwd),
new SQLiteParameter("@Name", index.Name),
new SQLiteParameter("@Phone", index.Phone),
new SQLiteParameter("@Mail", index.Mail),
new SQLiteParameter("@Address", index.Address),
new SQLiteParameter("@Age", index.Age),
new SQLiteParameter("@Notes", index.Notes)
};
return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, parm));
}
/// <summary>
/// 新增
/// </summary>
/// <returns>影响的行数</returns>
public int Add(Users index)
{
string sql = string.Format("insert into Users(Id,Login_Id,Login_Pwd,Name,Phone,Mail,Address,Age,Notes) values(@Id,@Login_Id,@Login_Pwd,@Name,@Phone,@Mail,@Address,@Age,@Notes)");
SQLiteParameter[] parm = new SQLiteParameter[] {
new SQLiteParameter("@Id", index.Id),
new SQLiteParameter("@Login_Id", index.LoginId),
new SQLiteParameter("@Login_Pwd", index.LoginPwd),
new SQLiteParameter("@Name", index.Name),
new SQLiteParameter("@Phone", index.Phone),
new SQLiteParameter("@Mail", index.Mail),
new SQLiteParameter("@Address", index.Address),
new SQLiteParameter("@Age", index.Age),
new SQLiteParameter("@Notes", index.Notes)
};
return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, parm));
}
public int update(string seqNo)
{
string sql = "update Monitor set Status ='N' where SeqNo=" + seqNo;
SQLiteParameter[] sqllite = new SQLiteParameter[] {};
int i = sqlLiteHelper.ExecuteNonQuery(sql, sqllite);
if (i > 0)
{
DataRow[] dataRows = loadData.Select("SeqNo =" + seqNo + "");
if (dataRows.Count() > 0)
{
dataRows[0]["Status"] = "N";
}
}
return(i);
}
