/// <summary>
/// 执行硬删除操作，此操作将不可恢复
/// </summary>
/// <param name="table">数据库表</param>
/// <param name="ids">要删除的id</param>
/// <returns>返回受影响的行数</returns>
public static int Del(string table, string ids)
{
string strSql = string.Empty;
string columnParas = string.Empty;
string columnNames = BuildSql.GetSqlColumnAndSqlParams(table, out columnParas, true);
string[] names = columnNames.Split(',');
strSql = "DELETE FROM " + table + " WHERE " + names[0] + " IN (" + ids + ")";
return(SqlHelper.ExcuteNonQuery(strSql));
}
/// <summary>
/// 执行指定列值更新操作
/// </summary>
/// <param name="table">数据库表</param>
/// <param name="ids">操作的ID</param>
/// <param name="sqlField">数据库字段</param>
/// <param name="sqlValue">设置的值</param>
/// <returns>返回受影响的行数</returns>
public static int UpdateFieldValue(string table, string ids, string sqlField, string sqlValue)
{
string strSql = string.Empty;
string columnParas = string.Empty;
string columnNames = BuildSql.GetSqlColumnAndSqlParams(table, out columnParas, true);
string[] names = columnNames.Split(',');
strSql = "update " + table + " set " + sqlField + "=" + sqlValue + " where " + names[0] + " in(" + ids + ") ";
return(SqlHelper.ExcuteNonQuery(strSql));
}
/// <summary>
/// 保存学习题库,保存成功 题库学习人数加一
/// </summary>
/// <param name="eid">用户ID</param>
/// <param name="sid">题库ID</param>
/// <returns></returns>
public int saveLearnSubject(string eid, int sid)
{
string strSQL = "if not exists(select id from learnSubject where [eid]=@eid and [sid]=@sid) begin insert learnSubject(eid,sid) values(@eid,@sid);update subjectClass set learns=learns+1 where ID=@sid end";
SqlParameter[] pars =
{
new SqlParameter("@eid", eid),
new SqlParameter("@sid", sid)
};
return(SqlHelper.ExcuteNonQuery(strSQL, pars));
}
//修改职称
public void updatezc(Models.jobinfo m)
{
string sql = "update JobInfo set jobName=@jobName,levelID=@levelID,valid=@valid where ID=@ID";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@jobName", m.name),
new SqlParameter("@levelID", m.jbid),
new SqlParameter("@valid", m.valid),
new SqlParameter("@ID", m.id)
};
SqlHelper.ExcuteNonQuery(sql, param);
}
//保存职称
public void savezc(Models.jobinfo m)
{
string sql = "insert into JobInfo(companyID,jobName,levelID,valid)values(@companyID,@jobName,@levelID,@valid)";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@companyID", m.companyID),
new SqlParameter("@jobName", m.name),
new SqlParameter("@levelID", m.jbid),
new SqlParameter("@valid", m.valid)
};
SqlHelper.ExcuteNonQuery(sql, param);
}
public void save(Models.comment m)
{
string sql = "insert into comment(eid,[sid],content,evaluate)values(@eid,@sid,@content,@evaluate)";
SqlParameter[] pars =
{
new SqlParameter("@eid", m.eid),
new SqlParameter("@sid", m.sid),
new SqlParameter("@content", m.content),
new SqlParameter("@evaluate", m.evaluate)
};
SqlHelper.ExcuteNonQuery(sql, pars);
}
public void updateks(department m)
{
string sql = "update department set name=@name,pid=@pid,must=@must,valid=@valid,isExam=@isExam where ID=@ID";
SqlParameter[] pars = new SqlParameter[]
{
new SqlParameter("@name", m.name),
new SqlParameter("@pid", m.pid),
new SqlParameter("@must", m.must),
new SqlParameter("@valid", m.valid),
new SqlParameter("@isExam", m.isExam),
new SqlParameter("@ID", m.id)
};
SqlHelper.ExcuteNonQuery(sql, pars);
}
public void UpdateResultVehicleInfo(RESULT_VEHICLE_INFO entity)
{
PropertyInfo[] propertyInfos = entity.GetType().GetProperties();
string strSql = "UPDATE RESULT_VEHICLE_INFO SET ";
foreach (PropertyInfo p in propertyInfos)
{
if (p.Name != "ID" && p.Name != "JCLSH")
{
strSql += string.Format("{0}='{1}',", p.Name, p.GetValue(entity, null));
}
}
strSql = strSql.Substring(0, strSql.Length - 1);
strSql += string.Format(" WHERE JCLSH ='{0}'", entity.JCLSH);
SqlHelper.ExcuteNonQuery(CommandType.Text, strSql);
}
/// <summary>
/// 保存部门或科室
/// </summary>
/// <param name="m"></param>
public void save(department m)
{
string sql = "insert into department(companyID,name,pid,type,valid,must,isExam)values(@companyID,@name,@pid,@type,@valid,@must,@isExam)";
SqlParameter[] pars = new SqlParameter[]
{
new SqlParameter("@companyID", m.companyID),
new SqlParameter("@name", m.name),
new SqlParameter("@pid", m.pid),
new SqlParameter("@type", m.type),
new SqlParameter("@valid", m.valid),
new SqlParameter("@must", m.must),
new SqlParameter("@isExam", m.isExam)
};
SqlHelper.ExcuteNonQuery(sql, pars);
}
/// <summary>
/// 添加用户信息
/// </summary>
/// <param name="userInfo"></param>
/// <returns></returns>
public int AddUserInfo(UserInfo userInfo)
{
string sql = @"insert into UserInfo(UserName,UserPass,RegTime,Email)
values(@UserName,@UserPass,@RegTime,@Email)";
SqlParameter[] pars =
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 32),
new SqlParameter("@UserPass", SqlDbType.NVarChar, 32),
new SqlParameter("@RegTime", SqlDbType.DateTime),
new SqlParameter("@Email", SqlDbType.NVarChar, 32),
};
pars[0].Value = userInfo.UserName;
pars[1].Value = userInfo.UserPass;
pars[2].Value = userInfo.RegTime;
pars[3].Value = userInfo.Email;
return(SqlHelper.ExcuteNonQuery(sql, CommandType.Text, pars));
}
/// <summary>
/// 修改用户信息
/// </summary>
/// <param name="userInfo"></param>
/// <returns></returns>
public int EditUserInfo(UserInfo userInfo)
{
string sql = @"update UserInfo set UserName=@UserName,
UserPass=@UserPass,RegTime=@RegTime,Email=@Email where ID=@ID";
SqlParameter[] pars = new SqlParameter[]
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 32),
new SqlParameter("@UserPass", SqlDbType.NVarChar, 32),
new SqlParameter("@RegTime", SqlDbType.DateTime, 32),
new SqlParameter("@Email", SqlDbType.NVarChar, 32),
new SqlParameter("@ID", SqlDbType.NVarChar, 32),
};
pars[0].Value = userInfo.UserName;
pars[1].Value = userInfo.UserPass;
pars[2].Value = userInfo.RegTime;
pars[3].Value = userInfo.Email;
pars[4].Value = userInfo.Id;
return(SqlHelper.ExcuteNonQuery(sql, CommandType.Text, pars));
}
public void update(Models.subject m)
{
string sql = "update subjectClass set name=@sname,introduce=@introduce,valid=@valid where id=@id";
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@id", m.id),
new SqlParameter("@sname", m.sname),
new SqlParameter("@valid", m.valid),
new SqlParameter("@introduce", SqlDbType.NVarChar, 2000)
};
if (m.introduce != "" && m.introduce != null)
{
param[3].Value = m.introduce;
}
else
{
param[3].Value = DBNull.Value;
}
SqlHelper.ExcuteNonQuery(sql, param);
}
public bool UpdateResultBrakeEntity(RESULT_BRAKE entity)
{
bool succ = false;
PropertyInfo[] propertyInfos = entity.GetType().GetProperties();
string strSql = "UPDATE RESULT_BRAKE SET ";
foreach (PropertyInfo p in propertyInfos)
{
if (p.Name != "ID" && p.Name != "JCLSH")
{
strSql += string.Format("{0}='{1}',", p.Name, p.GetValue(entity, null));
}
}
strSql = strSql.Substring(0, strSql.Length - 1);
strSql += string.Format(" WHERE JCLSH ='{0}'", entity.JCLSH);
int i = SqlHelper.ExcuteNonQuery(CommandType.Text, strSql);
if (i > 0)
{
succ = true;
}
return(succ);
}
public void save(Models.subject m)
{
string sql = "declare @leved int,@id int";
sql += " select @leved=leved+1 from subjectClass where ID=@pid";
sql += " select top(1) @id=ID+1 from subjectClass order by ID desc";
sql += " insert into subjectClass(ID,name,pId,leved,valid,levelID,introduce) values(@id,@sname,@pid,@leved,@valid,@levelID,@introduce)";
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@sname", m.sname),
new SqlParameter("@pid", m.pid),
new SqlParameter("@valid", m.valid),
new SqlParameter("@levelID", m.levelID),
new SqlParameter("@introduce", SqlDbType.NVarChar, 2000)
};
if (m.introduce != "" && m.introduce != null)
{
param[4].Value = m.introduce;
}
else
{
param[4].Value = DBNull.Value;
}
SqlHelper.ExcuteNonQuery(sql, param);
}
