/// <summary>
/// 保存
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public int Save(List<EmpModel> list, string empid, bool deleted)
{
int result = 0;
try
{
if (deleted) //删除模式
{
if (Delete(empid))
{
if (list != null)
{
foreach (EmpModel model in list)
{
result += Insert(model);
}
}
}
}
else //更新模式
{
if (list != null)
{
foreach (EmpModel model in list)
{
if (!Exist(model))
result += Insert(model);
else
result += Update(model);
}
}
}
return result;
}
catch
{
return -1;
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Save(EmpModel model, bool deleted)
{
int result = 0;
try
{
if (deleted) //删除模式
{
if (Delete(model.empid))
{
result += Insert(model);
}
}
else //更新模式
{
if (!Exist(model))
result += Insert(model);
else
result += Update(model);
}
return result;
}
catch
{
return -1;
}
}
/// <summary>
/// 存在
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Exist(EmpModel model)
{
bool ret = false;
string sql = @"select count(0) from emp
where empid=@empid
";
OleDbParameter[] parameters = {
new OleDbParameter("@empid",model.empid)
};
object o = null;
o = SqlHelper.GetSingle(SqlHelper.connectionString, sql, parameters);
if (o != null && (int)o > 0)
{
ret = true;
}
return ret;
}
/// <summary>
/// 批量插入
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public int Insert(List<EmpModel> list)
{
int result = 0;
try
{
foreach (EmpModel model in list)
{
result += Insert(model);
}
return result;
}
catch
{
return -1;
}
}
/// <summary>
/// 插入
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(EmpModel model)
{
string sql = @"insert into emp(empid,empname)
values(@empid,@empname)
";
OleDbParameter[] parameters = {
new OleDbParameter("@empid",model.empid),
new OleDbParameter("@empname",model.empname))
};
return SqlHelper.ExecuteSql(SqlHelper.connectionString, sql, parameters);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(EmpModel model)
{
string sql = @" update emp
set empname=@empname
where empid=@empid
";
OleDbParameter[] parameters = {
new OleDbParameter("@empname",model.empname),
new OleDbParameter("@empid",model.empid)
};
return SqlHelper.ExecuteSql(SqlHelper.connectionString, sql, parameters);
}
/// <summary>
/// 删除
/// </summary>
/// <returns></returns>
public bool Delete(string empid)
{
string sql = @" delete from emp
where empid=@empid
";
OleDbParameter[] parameters = {
new OleDbParameter("@empid", empid)
};
int ret = SqlHelper.ExecuteSql(SqlHelper.connectionString, sql, parameters);
return true;
}
/// 保存
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public int Save(List<EmpModel> list, string empid, bool deleted)
{
int result = 0;
try
{
if (deleted) //删除模式
{
if (Delete(empid))
{
if (list != null)
{
foreach (EmpModel model in list)
{
result += Insert(model);
}
}
}
}
else //更新模式
{
if (list != null)
{
foreach (EmpModel model in list)
{
if (!Exist(model))
result += Insert(model);
else
result += Update(model);
}
}
}
return result;
}
catch
{
return -1;
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Save(EmpModel model, bool deleted)
{
int result = 0;
try
{
if (deleted) //删除模式
{
if (Delete(model.empid))
{
result += Insert(model);
}
}
else //更新模式
{
if (!Exist(model))
result += Insert(model);
else
result += Update(model);
}
return result;
}
catch
{
return -1;
}
}
/// <summary>
/// 存在
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Exist(EmpModel model)
{
bool ret = false;
string sql = @"select count(0) from emp
where empid=@empid
";
OleDbParameter[] parameters = {
new OleDbParameter("@empid",model.empid)
};
object o = null;
o = SqlHelper.GetSingle(SqlHelper.connectionString, sql, parameters);
if (o != null && (int)o > 0)
{
ret = true;
}
return ret;
}
/// <summary>
/// 批量插入
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public int Insert(List<EmpModel> list)
{
int result = 0;
try
{
foreach (EmpModel model in list)
{
result += Insert(model);
}
return result;
}
catch
{
return -1;
}
}
/// <summary>
/// 插入
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(EmpModel model)
{
string sql = @"insert into emp(empid,empname)
values(@empid,@empname)
";
OleDbParameter[] parameters = {
new OleDbParameter("@empid",model.empid),
new OleDbParameter("@empname",model.empname))
};
return SqlHelper.ExecuteSql(SqlHelper.connectionString, sql, parameters);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(EmpModel model)
{
string sql = @" update emp
set empname=@empname
where empid=@empid
";
OleDbParameter[] parameters = {
new OleDbParameter("@empname",model.empname),
new OleDbParameter("@empid",model.empid)
};
return SqlHelper.ExecuteSql(SqlHelper.connectionString, sql, parameters);
}
/// <summary>
/// 删除
/// </summary>
/// <returns></returns>
public bool Delete(string empid)
{
string sql = @" delete from emp
where empid=@empid
";
OleDbParameter[] parameters = {
new OleDbParameter("@empid", empid)
};
int ret = SqlHelper.ExecuteSql(SqlHelper.connectionString, sql, parameters);
return true;
}