/// <summary>
/// 修改一条数据
/// </summary>
/// <param name="model">实体对象</param>
/// <returns></returns>
public bool Update(Common.Entity.DICDomain model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"Update Dictionary set Name=@Name where Code=@Code ");
SqlParameter[] param =
{
new SqlParameter("@Name", model.Name),
new SqlParameter("@Code", model.Code)
};
try
{
int result = SqlHelper.ExecuteNonQuery(SqlHelper.connStr, CommandType.Text, strSql.ToString(), param);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 新增一条记录
/// </summary>
/// <param name="model">实体对象</param>
/// <returns></returns>
public bool Add(Common.Entity.DICDomain model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"Insert into Dictionary(Code,Name,ListName,Sort,Remark) Values");
strSql.Append("(@Code,@Name,@ListName,@Sort,@Remark)");
strSql.Append(";SELECT @@IDENTITY");// 返回插入用户的主键
SqlParameter[] param =
{
new SqlParameter("@Code", model.Code),
new SqlParameter("@Name", model.Name),
new SqlParameter("@ListName", model.ListName),
new SqlParameter("@Sort", model.Sort),
new SqlParameter("@Remark", model.Remark)
};
try
{
int result = SqlHelper.ExecuteNonQuery(SqlHelper.connStr, System.Data.CommandType.Text, strSql.ToString(), param);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据PKID获取实体对象
/// </summary>
/// <param name="pkid">PKID</param>
/// <returns>返回值</returns>
public Common.Entity.DICDomain GetDicDomainByPKID(int pkid)
{
string sql = string.Format(@" select * from Dictionary where PKID=@PKID");
SqlParameter[] param =
{
new SqlParameter("@PKID", pkid)
};
try
{
Common.Entity.DICDomain model = new Common.Entity.DICDomain();
DataTable dt = SqlHelper.GetDateTable(SqlHelper.connStr, CommandType.Text, sql, param);
if (dt.Rows.Count > 0)
{
model.PKID = Convert.ToInt32(dt.Rows[0]["PKID"].ToString());
model.Code = dt.Rows[0]["Code"].ToString();
model.Name = dt.Rows[0]["Name"].ToString();
model.ListName = dt.Rows[0]["ListName"].ToString();
model.Sort = Convert.ToInt32(dt.Rows[0]["Sort"].ToString());
model.Remark = dt.Rows[0]["Remark"].ToString();
}
return(model);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据PKID修改一条记录
/// </summary>
/// <param name="model">实体对象</param>
/// <returns>返回值</returns>
public bool UpdateDomainItem(Common.Entity.DICDomain model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"Update Dictionary set ListName=@ListName,Sort=@Sort,Remark=@Remark where PKID=@PKID ");
SqlParameter[] param =
{
new SqlParameter("@ListName", model.ListName),
new SqlParameter("@Sort", model.Sort),
new SqlParameter("@Remark", model.Remark),
new SqlParameter("@PKID", model.PKID)
};
try
{
int result = SqlHelper.ExecuteNonQuery(SqlHelper.connStr, CommandType.Text, strSql.ToString(), param);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据域编码查询实体数据
/// </summary>
/// <param name="code">域编码</param>
/// <returns></returns>
public Common.Entity.DICDomain GetDicDomainByCode(string code)
{
string sql = string.Format(@"select * from Dictionary where Code=@Code");
SqlParameter[] param =
{
new SqlParameter("@Code", code)
};
DataTable dt = SqlHelper.GetDateTable(SqlHelper.connStr, System.Data.CommandType.Text, sql, param);
Common.Entity.DICDomain model = new Common.Entity.DICDomain();
if (dt.Rows.Count > 0)
{
model.PKID = Convert.ToInt32(dt.Rows[0]["PKID"]);
model.Code = dt.Rows[0]["Code"].ToString();
model.Name = dt.Rows[0]["Name"].ToString();
model.ListName = dt.Rows[0]["ListName"].ToString();
model.Sort = Convert.ToInt32(dt.Rows[0]["Sort"].ToString());
model.Remark = dt.Rows[0]["Remark"].ToString();
}
return(model);
}
