/// <summary>
/// 得到一个对象实体
/// </summary>
public static EtNet_Models.StaffExperience GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,staffid,stime,etime,yearsnum,workunit,post,remark from StaffExperience ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
EtNet_Models.StaffExperience model = new EtNet_Models.StaffExperience();
DataTable tbl = EtNet_DAL.DBHelper.GetDataSet(strSql.ToString(), parameters);
if (tbl.Rows.Count > 0)
{
model.id = int.Parse(tbl.Rows[0]["id"].ToString());
model.staffid = int.Parse(tbl.Rows[0]["staffid"].ToString());
model.stime = DateTime.Parse(tbl.Rows[0]["stime"].ToString());
model.etime = DateTime.Parse(tbl.Rows[0]["etime"].ToString());
model.yearsnum = int.Parse(tbl.Rows[0]["yearsnum"].ToString());
model.workunit = tbl.Rows[0]["workunit"].ToString();
model.post = tbl.Rows[0]["post"].ToString();
model.remark = tbl.Rows[0]["remark"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(EtNet_Models.StaffExperience model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update StaffExperience set ");
strSql.Append("staffid=@staffid,");
strSql.Append("stime=@stime,");
strSql.Append("etime=@etime,");
strSql.Append("yearsnum=@yearsnum,");
strSql.Append("workunit=@workunit,");
strSql.Append("post=@post,");
strSql.Append("remark=@remark");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@staffid", SqlDbType.Int, 4),
new SqlParameter("@stime", SqlDbType.SmallDateTime),
new SqlParameter("@etime", SqlDbType.SmallDateTime),
new SqlParameter("@yearsnum", SqlDbType.Int, 4),
new SqlParameter("@workunit", SqlDbType.VarChar, 100),
new SqlParameter("@post", SqlDbType.VarChar, 100),
new SqlParameter("@remark", SqlDbType.VarChar, 200),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.staffid;
parameters[1].Value = model.stime;
parameters[2].Value = model.etime;
parameters[3].Value = model.yearsnum;
parameters[4].Value = model.workunit;
parameters[5].Value = model.post;
parameters[6].Value = model.remark;
parameters[7].Value = model.id;
int result = EtNet_DAL.DBHelper.ExecuteCommand(strSql.ToString(), parameters);
if (result >= 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public static bool Add(EtNet_Models.StaffExperience model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into StaffExperience(");
strSql.Append("staffid,stime,etime,yearsnum,workunit,post,remark)");
strSql.Append(" values (");
strSql.Append("@staffid,@stime,@etime,@yearsnum,@workunit,@post,@remark)");
SqlParameter[] parameters =
{
new SqlParameter("@staffid", SqlDbType.Int, 4),
new SqlParameter("@stime", SqlDbType.SmallDateTime),
new SqlParameter("@etime", SqlDbType.SmallDateTime),
new SqlParameter("@yearsnum", SqlDbType.Int, 4),
new SqlParameter("@workunit", SqlDbType.VarChar, 100),
new SqlParameter("@post", SqlDbType.VarChar, 100),
new SqlParameter("@remark", SqlDbType.VarChar, 200)
};
parameters[0].Value = model.staffid;
parameters[1].Value = model.stime;
parameters[2].Value = model.etime;
parameters[3].Value = model.yearsnum;
parameters[4].Value = model.workunit;
parameters[5].Value = model.post;
parameters[6].Value = model.remark;
int result = EtNet_DAL.DBHelper.ExecuteCommand(strSql.ToString(), parameters);
if (result >= 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(EtNet_Models.StaffExperience model)
{
return(EtNet_DAL.StaffExperienceService.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public static bool Add(EtNet_Models.StaffExperience model)
{
return(EtNet_DAL.StaffExperienceService.Add(model));
}
