/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(JSOA.Model.Sys_Department model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Sys_Department(");
strSql.Append("No,Name,ParentNo,Remarks)");
strSql.Append(" values (");
strSql.Append("@No,@Name,@ParentNo,@Remarks)");
SqlParameter[] parameters = {
new SqlParameter("@No", SqlDbType.VarChar,50),
new SqlParameter("@Name", SqlDbType.VarChar,100),
new SqlParameter("@ParentNo", SqlDbType.VarChar,50),
new SqlParameter("@Remarks", SqlDbType.VarChar,500)};
parameters[0].Value = model.No;
parameters[1].Value = model.Name;
parameters[2].Value = model.ParentNo;
parameters[3].Value = model.Remarks;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(JSOA.Model.Employee model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Employee(");
strSql.Append("No,Name,Pass,FK_Dept,FK_Unit,SID)");
strSql.Append(" values (");
strSql.Append("@No,@Name,@Pass,@FK_Dept,@FK_Unit,@SID)");
SqlParameter[] parameters = {
new SqlParameter("@No", SqlDbType.VarChar,20),
new SqlParameter("@Name", SqlDbType.VarChar,100),
new SqlParameter("@Pass", SqlDbType.VarChar,100),
new SqlParameter("@FK_Dept", SqlDbType.VarChar,100),
new SqlParameter("@FK_Unit", SqlDbType.VarChar,100),
new SqlParameter("@SID", SqlDbType.VarChar,20)};
parameters[0].Value = model.No;
parameters[1].Value = model.Name;
parameters[2].Value = model.Pass;
parameters[3].Value = model.FK_Dept;
parameters[4].Value = model.FK_Unit;
parameters[5].Value = model.SID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(JSOA.Model.Sys_Department model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Sys_Department set ");
strSql.Append("Name=@Name,");
strSql.Append("ParentNo=@ParentNo,");
strSql.Append("Remarks=@Remarks");
strSql.Append(" where No=@No ");
SqlParameter[] parameters = {
new SqlParameter("@Name", SqlDbType.VarChar,100),
new SqlParameter("@ParentNo", SqlDbType.VarChar,50),
new SqlParameter("@Remarks", SqlDbType.VarChar,500),
new SqlParameter("@No", SqlDbType.VarChar,50)};
parameters[0].Value = model.Name;
parameters[1].Value = model.ParentNo;
parameters[2].Value = model.Remarks;
parameters[3].Value = model.No;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(JSOA.Model.Employee model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Employee set ");
strSql.Append("Name=@Name,");
strSql.Append("Pass=@Pass,");
strSql.Append("FK_Dept=@FK_Dept,");
strSql.Append("FK_Unit=@FK_Unit,");
strSql.Append("SID=@SID");
strSql.Append(" where No=@No ");
SqlParameter[] parameters = {
new SqlParameter("@Name", SqlDbType.VarChar,100),
new SqlParameter("@Pass", SqlDbType.VarChar,100),
new SqlParameter("@FK_Dept", SqlDbType.VarChar,100),
new SqlParameter("@FK_Unit", SqlDbType.VarChar,100),
new SqlParameter("@SID", SqlDbType.VarChar,20),
new SqlParameter("@No", SqlDbType.VarChar,20)};
parameters[0].Value = model.Name;
parameters[1].Value = model.Pass;
parameters[2].Value = model.FK_Dept;
parameters[3].Value = model.FK_Unit;
parameters[4].Value = model.SID;
parameters[5].Value = model.No;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(JSOA.Model.Employee model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(JSOA.Model.Employee model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(JSOA.Model.Sys_Department model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(JSOA.Model.Sys_Department model)
{
return dal.Update(model);
}
