/// <summary>
/// 删除当月数据
/// </summary>
/// <param name="empid"></param>
/// <returns></returns>
public bool Delete(string year, string month)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from r_jshz ");
strSql.Append(" where year=@year and month=@month");
SqlParameter[] parameters =
{
new SqlParameter("@year", SqlDbType.VarChar, 100),
new SqlParameter("@month", SqlDbType.VarChar, 100)
};
parameters[0].Value = year;
parameters[1].Value = month;
int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.zxkc model)
{
using (SqlConnection conn = new SqlConnection(DbHelperSql.connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_zxkc set ");
strSql.Append("year=@year,");
strSql.Append("month=@month,");
strSql.Append("empid=@empid,");
strSql.Append("name=@name,");
strSql.Append("znjy=@znjy,");
strSql.Append("jxjy=@jxjy,");
strSql.Append("dbyl=@dbyl,");
strSql.Append("zfdk=@zfdk,");
strSql.Append("zfzj=@zfzj,");
strSql.Append("sylr=@sylr");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@year", SqlDbType.VarChar, 50),
new SqlParameter("@month", SqlDbType.VarChar, 50),
new SqlParameter("@empid", SqlDbType.VarChar, 50),
new SqlParameter("@name", SqlDbType.VarChar, 50),
new SqlParameter("@znjy", SqlDbType.Decimal),
new SqlParameter("@jxjy", SqlDbType.Decimal),
new SqlParameter("@dbyl", SqlDbType.Decimal),
new SqlParameter("@zfdk", SqlDbType.Decimal),
new SqlParameter("@zfzj", SqlDbType.Decimal),
new SqlParameter("@sylr", SqlDbType.Decimal),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.year;
parameters[1].Value = model.month;
parameters[2].Value = model.empid;
parameters[3].Value = model.name;
parameters[4].Value = model.znjy;
parameters[5].Value = model.jxjy;
parameters[6].Value = model.dbyl;
parameters[7].Value = model.zfdk;
parameters[8].Value = model.zfzj;
parameters[9].Value = model.sylr;
parameters[10].Value = model.id;
DbHelperSql.ExecuteSql(conn, trans, strSql.ToString(), parameters);
trans.Commit();
}
catch
{
trans.Rollback();
return(false);
}
}
}
return(true);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.zxkc model)
{
int newId;
using (SqlConnection conn = new SqlConnection(DbHelperSql.connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_zxkc(");
strSql.Append("year,month,empid,name,znjy,jxjy,dbyl,zfdk,zfzj,sylr)");
strSql.Append(" values (");
strSql.Append("@year,@month,@empid,@name,@znjy,@jxjy,@dbyl,@zfdk,@zfzj,@sylr)");
SqlParameter[] parameters =
{
new SqlParameter("@year", SqlDbType.VarChar, 50),
new SqlParameter("@month", SqlDbType.VarChar, 50),
new SqlParameter("@empid", SqlDbType.VarChar, 50),
new SqlParameter("@name", SqlDbType.VarChar, 50),
new SqlParameter("@znjy", SqlDbType.Decimal),
new SqlParameter("@jxjy", SqlDbType.Decimal),
new SqlParameter("@dbyl", SqlDbType.Decimal),
new SqlParameter("@zfdk", SqlDbType.Decimal),
new SqlParameter("@zfzj", SqlDbType.Decimal),
new SqlParameter("@sylr", SqlDbType.Decimal)
};
parameters[0].Value = model.year;
parameters[1].Value = model.month;
parameters[2].Value = model.empid;
parameters[3].Value = model.name;
parameters[4].Value = model.znjy;
parameters[5].Value = model.jxjy;
parameters[6].Value = model.dbyl;
parameters[7].Value = model.zfdk;
parameters[8].Value = model.zfzj;
parameters[9].Value = model.sylr;
DbHelperSql.ExecuteSql(conn, trans, strSql.ToString(), parameters);
//取得新插入的ID
newId = GetMaxId(conn, trans);
trans.Commit();
}
catch
{
trans.Rollback();
return(-1);
}
}
}
return(newId);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.users model)
{
using (SqlConnection conn = new SqlConnection(DbHelperSql.connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_users set ");
strSql.Append("name=@name,");
strSql.Append("departid=@departid,");
strSql.Append("username=@username,");
strSql.Append("password=@password,");
strSql.Append("role=@role,");
strSql.Append("addtime=@addtime,");
strSql.Append("note=@note");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@name", SqlDbType.VarChar, 50),
new SqlParameter("@departid", SqlDbType.VarChar, 50),
new SqlParameter("@username", SqlDbType.VarChar, 50),
new SqlParameter("@password", SqlDbType.VarChar, 50),
new SqlParameter("@role", SqlDbType.Int),
new SqlParameter("@addtime", SqlDbType.VarChar, 50),
new SqlParameter("@note", SqlDbType.VarChar, 50),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.name;
parameters[1].Value = model.departid;
parameters[2].Value = model.username;
parameters[3].Value = model.password;
parameters[4].Value = model.role;
parameters[5].Value = model.addtime;
parameters[6].Value = model.note;
parameters[7].Value = model.id;
DbHelperSql.ExecuteSql(conn, trans, strSql.ToString(), parameters);
trans.Commit();
}
catch
{
trans.Rollback();
return(false);
}
}
}
return(true);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.users model)
{
int newId;
using (SqlConnection conn = new SqlConnection(DbHelperSql.connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_users(");
strSql.Append("name,departid,username,password,role,addtime,note)");
strSql.Append(" values (");
strSql.Append("@name,@departid,@username,@password,@role,@addtime,@note)");
SqlParameter[] parameters =
{
new SqlParameter("@name", SqlDbType.VarChar, 50),
new SqlParameter("@departid", SqlDbType.VarChar, 50),
new SqlParameter("@username", SqlDbType.VarChar, 50),
new SqlParameter("@password", SqlDbType.VarChar, 50),
new SqlParameter("@role", SqlDbType.Int),
new SqlParameter("@addtime", SqlDbType.VarChar, 50),
new SqlParameter("@note", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.name;
parameters[1].Value = model.departid;
parameters[2].Value = model.username;
parameters[3].Value = model.password;
parameters[4].Value = model.role;
parameters[5].Value = model.addtime;
parameters[6].Value = model.note;
DbHelperSql.ExecuteSql(conn, trans, strSql.ToString(), parameters);
//取得新插入的ID
newId = GetMaxId(conn, trans);
trans.Commit();
}
catch
{
trans.Rollback();
return(-1);
}
}
}
return(newId);
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from r_jshz ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 根据工号删除记录
/// </summary>
public bool Delete(string username)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from t_users ");
strSql.Append(" where username=@username");
SqlParameter[] parameters =
{
new SqlParameter("@username", SqlDbType.VarChar, 100)
};
parameters[0].Value = username;
int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 根据工号删除记录
/// </summary>
public bool Delete(string empid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from t_zxkc ");
strSql.Append(" where empid=@empid");
SqlParameter[] parameters =
{
new SqlParameter("@empid", SqlDbType.VarChar, 100)
};
parameters[0].Value = empid;
int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.gsjs model)
{
int newId;
using (SqlConnection conn = new SqlConnection(DbHelperSql.connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into r_jshz(");
strSql.Append("year,month,depart,departid,empid,name,gzjb,yfje,kk,gjj,bxkk,zxkk,jckk,ysgzlj,gslj,bygs)");
strSql.Append(" values (");
strSql.Append("@year,@month,@depart,@departid,@empid,@name,@gzjb,@yfje,@kk,@gjj,@bxkk,@zxkk,@jckk,@ysgzlj,@gslj,@bygs)");
SqlParameter[] parameters =
{
new SqlParameter("@year", SqlDbType.VarChar, 50),
new SqlParameter("@month", SqlDbType.VarChar, 50),
new SqlParameter("@depart", SqlDbType.VarChar, 50),
new SqlParameter("@departid", SqlDbType.VarChar, 50),
new SqlParameter("@empid", SqlDbType.VarChar, 50),
new SqlParameter("@name", SqlDbType.VarChar, 50),
new SqlParameter("@gzjb", SqlDbType.VarChar, 50),
new SqlParameter("@yfje", SqlDbType.Decimal),
new SqlParameter("@kk", SqlDbType.Decimal),
new SqlParameter("@gjj", SqlDbType.Decimal),
new SqlParameter("@bxkk", SqlDbType.Decimal),
new SqlParameter("@zxkk", SqlDbType.Decimal),
new SqlParameter("@jckk", SqlDbType.Decimal),
new SqlParameter("@ysgzlj", SqlDbType.Decimal),
new SqlParameter("@gslj", SqlDbType.Decimal),
new SqlParameter("@bygs", SqlDbType.Decimal)
};
parameters[0].Value = model.year;
parameters[1].Value = model.month;
parameters[2].Value = model.depart;
parameters[3].Value = model.departid;
parameters[4].Value = model.empid;
parameters[5].Value = model.name;
parameters[6].Value = model.gzjb;
parameters[7].Value = model.yfje;
parameters[8].Value = model.kk;
parameters[9].Value = model.gjj;
parameters[10].Value = model.bxkk;
parameters[11].Value = model.zxkk;
parameters[12].Value = model.jckk;
parameters[13].Value = model.ysgzlj;
parameters[14].Value = model.gslj;
parameters[15].Value = model.bygs;
DbHelperSql.ExecuteSql(conn, trans, strSql.ToString(), parameters);
//取得新插入的ID
newId = GetMaxId(conn, trans);
trans.Commit();
}
catch
{
trans.Rollback();
return(-1);
}
}
}
return(newId);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.gsjs model)
{
using (SqlConnection conn = new SqlConnection(DbHelperSql.connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update r_jshz set ");
strSql.Append("year=@year,");
strSql.Append("month=@month,");
strSql.Append("depart=@depart,");
strSql.Append("departid=@departid,");
strSql.Append("empid=@empid,");
strSql.Append("name=@name,");
strSql.Append("yfje=@yfje,");
strSql.Append("kk=@kk,");
strSql.Append("gjj=@gjj,");
strSql.Append("bxkk=@bxkk,");
strSql.Append("zxkk=@zxkk,");
strSql.Append("jckk=@jckk,");
strSql.Append("ysgzlj=@ysgzlj,");
strSql.Append("gslj=@gslj,");
strSql.Append("bygs=@bygs");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@year", SqlDbType.VarChar, 50),
new SqlParameter("@month", SqlDbType.VarChar, 50),
new SqlParameter("@depart", SqlDbType.VarChar, 50),
new SqlParameter("@departid", SqlDbType.VarChar, 50),
new SqlParameter("@empid", SqlDbType.VarChar, 50),
new SqlParameter("@name", SqlDbType.VarChar, 50),
new SqlParameter("@gzjb", SqlDbType.VarChar, 50),
new SqlParameter("@yfje", SqlDbType.Decimal),
new SqlParameter("@kk", SqlDbType.Decimal),
new SqlParameter("@gjj", SqlDbType.Decimal),
new SqlParameter("@bxkk", SqlDbType.Decimal),
new SqlParameter("@zxkk", SqlDbType.Decimal),
new SqlParameter("@jckk", SqlDbType.Decimal),
new SqlParameter("@ysgzlj", SqlDbType.Decimal),
new SqlParameter("@gslj", SqlDbType.Decimal),
new SqlParameter("@bygs", SqlDbType.Decimal),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.year;
parameters[1].Value = model.month;
parameters[2].Value = model.depart;
parameters[3].Value = model.departid;
parameters[4].Value = model.empid;
parameters[5].Value = model.name;
parameters[6].Value = model.gzjb;
parameters[7].Value = model.yfje;
parameters[9].Value = model.kk;
parameters[10].Value = model.gjj;
parameters[11].Value = model.bxkk;
parameters[12].Value = model.zxkk;
parameters[13].Value = model.jckk;
parameters[14].Value = model.ysgzlj;
parameters[15].Value = model.gslj;
parameters[16].Value = model.bygs;
parameters[17].Value = model.id;
DbHelperSql.ExecuteSql(conn, trans, strSql.ToString(), parameters);
trans.Commit();
}
catch
{
trans.Rollback();
return(false);
}
}
}
return(true);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.gzmx model)
{
using (SqlConnection conn = new SqlConnection(DbHelperSql.connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_gzmx set ");
strSql.Append("year=@year,");
strSql.Append("month=@month,");
strSql.Append("name=@name,");
strSql.Append("yfje=@yfje,");
strSql.Append("kqtk=@kqtk,");
strSql.Append("kk=@kk,");
strSql.Append("gsk=@gsk,");
strSql.Append("gjj2=@gjj2,");
strSql.Append("gjj=@gjj,");
strSql.Append("bxkk=@bxkk,");
strSql.Append("sfje=@sfje");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@year", SqlDbType.VarChar, 50),
new SqlParameter("@month", SqlDbType.VarChar, 50),
new SqlParameter("@empid", SqlDbType.VarChar, 50),
new SqlParameter("@name", SqlDbType.VarChar, 50),
new SqlParameter("@yfje", SqlDbType.Decimal),
new SqlParameter("@kqtk", SqlDbType.Decimal),
new SqlParameter("@kk", SqlDbType.Decimal),
new SqlParameter("@gsk", SqlDbType.Decimal),
new SqlParameter("@gjj2", SqlDbType.Decimal),
new SqlParameter("@gjj", SqlDbType.Decimal),
new SqlParameter("@bxkk", SqlDbType.Decimal),
new SqlParameter("@sfje", SqlDbType.Decimal),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.year;
parameters[1].Value = model.month;
parameters[2].Value = model.empid;
parameters[3].Value = model.name;
parameters[4].Value = model.yfje;
parameters[5].Value = model.kqtk;
parameters[6].Value = model.kk;
parameters[7].Value = model.gsk;
parameters[8].Value = model.gjj2;
parameters[9].Value = model.gjj;
parameters[10].Value = model.bxkk;
parameters[11].Value = model.sfje;
parameters[12].Value = model.id;
DbHelperSql.ExecuteSql(conn, trans, strSql.ToString(), parameters);
trans.Commit();
}
catch
{
trans.Rollback();
return(false);
}
}
}
return(true);
}
