/// <summary>
/// 机构管理 添加数据
/// </summary>
/// <param name="base_organization">要添加的机构管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Add(base_organization info, out string errmsg)
{
List <DataParameter> pars = new List <DataParameter>();
pars.Add(new DataParameter("orgname", info.orgname));
pars.Add(new DataParameter("industry", info.industry));
pars.Add(new DataParameter("logo", info.logo));
pars.Add(new DataParameter("propaganda", info.propaganda));
pars.Add(new DataParameter("country", info.country));
pars.Add(new DataParameter("areacode", info.areacode));
pars.Add(new DataParameter("address", info.address));
pars.Add(new DataParameter("contacts", info.contacts));
pars.Add(new DataParameter("telphone", info.telphone));
pars.Add(new DataParameter("fax", info.fax));
pars.Add(new DataParameter("website", info.website));
pars.Add(new DataParameter("email", info.email));
pars.Add(new DataParameter("postcode", info.postcode));
pars.Add(new DataParameter("createddate", info.createddate));
pars.Add(new DataParameter("corporate", info.corporate));
pars.Add(new DataParameter("subjectclass", info.subjectclass));
pars.Add(new DataParameter("introduce", info.introduce));
pars.Add(new DataParameter("hits", info.hits));
pars.Add(new DataParameter("createdtime", info.createdtime));
pars.Add(new DataParameter("creator", info.creator));
pars.Add(new DataParameter("status", info.status));
string sqlstr = "insert into base_organization (orgname,industry,logo,propaganda,country,areacode,address,contacts,telphone,fax,website,email,postcode,createddate,corporate,subjectclass,introduce,hits,createdtime,creator,status) values (@orgname,@industry,@logo,@propaganda,@country,@areacode,@address,@contacts,@telphone,@fax,@website,@email,@postcode,@createddate,@corporate,@subjectclass,@introduce,@hits,@createdtime,@creator,@status) ";
return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0);
}
/// <summary>
/// 机构管理 更新数据
/// </summary>
/// <param name="base_organization">要更新的机构管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Update(base_organization info, out string errmsg)
{
List <DataParameter> pars = new List <DataParameter>();
pars.Add(new DataParameter("orgname", info.orgname));
pars.Add(new DataParameter("industry", info.industry));
pars.Add(new DataParameter("logo", info.logo));
pars.Add(new DataParameter("propaganda", info.propaganda));
pars.Add(new DataParameter("country", info.country));
pars.Add(new DataParameter("areacode", info.areacode));
pars.Add(new DataParameter("address", info.address));
pars.Add(new DataParameter("contacts", info.contacts));
pars.Add(new DataParameter("telphone", info.telphone));
pars.Add(new DataParameter("fax", info.fax));
pars.Add(new DataParameter("website", info.website));
pars.Add(new DataParameter("email", info.email));
pars.Add(new DataParameter("postcode", info.postcode));
pars.Add(new DataParameter("createddate", info.createddate));
pars.Add(new DataParameter("corporate", info.corporate));
pars.Add(new DataParameter("subjectclass", info.subjectclass));
pars.Add(new DataParameter("introduce", info.introduce));
pars.Add(new DataParameter("hits", info.hits));
pars.Add(new DataParameter("createdtime", info.createdtime));
pars.Add(new DataParameter("creator", info.creator));
pars.Add(new DataParameter("status", info.status));
string sqlstr = "update base_organization set orgname=@orgname,industry=@industry,logo=@logo,propaganda=@propaganda,country=@country,areacode=@areacode,address=@address,contacts=@contacts,telphone=@telphone,fax=@fax,website=@website,email=@email,postcode=@postcode,createddate=@createddate,corporate=@corporate,subjectclass=@subjectclass,introduce=@introduce,hits=@hits,createdtime=@createdtime,creator=@creator,status=@status where orgid=@orgid ";
pars.Add(new DataParameter("orgid", info.orgid));
return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0);
}
/// <summary>
/// 机构管理 详情查询
/// </summary>
public object Get(int id)
{
base_organization info = organizationBLL.GetInfo(id, out errmsg);
if (!string.IsNullOrEmpty(errmsg))
{
return(new { Rcode = -1, Rmsg = "获取数据失败" });
}
return(new { Rcode = 1, Rdata = info });
}
/// <summary>
/// 机构管理 添加数据
/// </summary>
public object Post([FromBody] base_organization info)
{
bool success = organizationBLL.Add(info, out errmsg);
WriteSysLog(0, string.Format("添加机构{0}，返回{1} {2}", info.orgname, success, errmsg));
if (!success || !string.IsNullOrEmpty(errmsg))
{
return new { Rcode = -1, Rmsg = "添加失败" }
}
;
return(new { Rcode = 1, Rmsg = "添加成功" });
}
/// <summary>
/// 机构管理 更新数据
/// </summary>
public object Put(int id, [FromBody] base_organization info)
{
info.orgid = id;
bool success = organizationBLL.Update(info, out errmsg);
WriteSysLog(1, string.Format("更新机构id为{0}，返回{1} {2}", id, success, errmsg));
if (!success || !string.IsNullOrEmpty(errmsg))
{
return new { Rcode = -1, Rmsg = "更新失败" }
}
;
return(new { Rcode = 1, Rmsg = "更新成功" });
}
public object Get(string codes, string type, string flig, string orgid)
{
if (!string.IsNullOrEmpty(type))
{
base_organization info = organizationBLL.selectbyType(codes, type, out errmsg);
if (string.Equals("修改", flig))
{
if (info != null)
{
return(new { valid = (string.Equals(info.orgid.ToString(), orgid)) ? true : false });
}
return(new { valid = true });
}
return(new { valid = (info == null) ? true : false });
}
return(new { valid = false });
}
/// <summary>
/// 机构管理 更新数据
/// </summary>
/// <param name="base_organization">要更新的机构管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Update(base_organization info, out string errmsg)
{
return(organizationDAL.Update(info, out errmsg));
}
/// <summary>
/// 机构管理 添加数据
/// </summary>
/// <param name="base_organization">要添加的机构管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Add(base_organization info, out string errmsg)
{
return(organizationDAL.Add(info, out errmsg));
}
/// <summary>
/// 机构管理 详情查询
/// </summary>
public static base_organization GetInfo(int orgid, out string errmsg)
{
base_organization info = organizationDAL.GetInfo(orgid, out errmsg);
return(info);
}
