public string UpdateCompany(sys_CompanyModel companyModel)
{
JsonMessage json = new JsonMessage();
string strWhere = "CompanyId!=" + companyModel.CompanyId + " and CompanyName ='" + companyModel.CompanyName + "'";
if (companyDAL.GetCompanyByWhere(strWhere).Rows.Count == 0)
{
int number = companyDAL.UpdateCompany(companyModel);
if (number > 0)
{
json.Success = true;
json.Msg = "企业信息修改成功";
}
else if (number == 0)
{
json.Success = false;
json.Msg = "企业信息修改失败";
}
else
{
json.Success = false;
json.Msg = "企业信息修改出错";
}
}
else
{
json.Success = false;
json.Msg = "该企业名已存在";
}
return(JsonHelper.ToJson(json));
}
/// <summary>
/// 把企业实体类信息添加到数据库中，得到对数据库操作结果如果大于0添加成功，如果等于0添加失败，如果小于0添加出错
/// </summary>
/// <param name="companyModel">企业实体类信息</param>
/// <returns></returns>
public int AddCompany(sys_CompanyModel companyModel)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sys_Company ( ");
strSql.Append(" CompanyName,CompanyAddress,CompanyPerson,CompanyTelPhone, ");
strSql.Append(" CompanyOthInfo,CompanyState ) values ( ");
strSql.Append(" @CompanyName,@CompanyAddress,@CompanyPerson,@CompanyTelPhone,");
strSql.Append(" @CompanyOthInfo,@CompanyState )");
SqlParameter[] paras =
{
new SqlParameter("@CompanyName", SqlDbType.VarChar, 50),
new SqlParameter("@CompanyAddress", SqlDbType.VarChar, 200),
new SqlParameter("@CompanyPerson", SqlDbType.VarChar, 50),
new SqlParameter("@CompanyTelPhone", SqlDbType.VarChar, 50),
new SqlParameter("@CompanyOthInfo", SqlDbType.VarChar, 500),
new SqlParameter("@CompanyState", SqlDbType.Int, 4)
};
paras[0].Value = companyModel.CompanyName;
paras[1].Value = companyModel.CompanyAddress;
paras[2].Value = companyModel.CompanyPerson;
paras[3].Value = companyModel.CompanyTelPhone;
paras[4].Value = companyModel.CompanyOthInfo;
paras[5].Value = companyModel.CompanyState;
int number = DBHelper.ExecuteNonQuery(strSql.ToString(), paras);
return(number);
}
catch (Exception)
{
return(-1);
throw;
}
}
/// <summary>
/// 根据企业编号查询该企业信息，得到企业实体类信息
/// </summary>
/// <param name="CompanyId">企业编号</param>
/// <returns></returns>
public sys_CompanyModel GetCompanyByCompanyId(int CompanyId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 CompanyId,CompanyName,CompanyAddress,CompanyPerson,");
strSql.Append("CompanyTelPhone,CompanyOthInfo,CompanyState from sys_Company ");
strSql.Append(" where CompanyId=@CompanyId ");
SqlParameter[] paras =
{
new SqlParameter("@CompanyId", SqlDbType.Int, 4)
};
paras[0].Value = CompanyId;
sys_CompanyModel companyModel = new sys_CompanyModel();
SqlDataReader reader = DBHelper.ExecuteReader(strSql.ToString(), paras);
if (reader != null)
{
while (reader.Read())
{
companyModel.CompanyId = reader.GetInt32(0);
companyModel.CompanyName = reader.GetString(1);
try
{
companyModel.CompanyAddress = reader.GetString(2);
}
catch (Exception)
{
companyModel.CompanyAddress = null;
}
try
{
companyModel.CompanyPerson = reader.GetString(3);
}
catch (Exception)
{
companyModel.CompanyPerson = null;
}
try
{
companyModel.CompanyTelPhone = reader.GetString(4);
}
catch (Exception)
{
companyModel.CompanyTelPhone = null;
}
try
{
companyModel.CompanyOthInfo = reader.GetString(5);
}
catch (Exception)
{
companyModel.CompanyOthInfo = null;
}
companyModel.CompanyState = reader.GetInt32(6);
}
}
reader.Close();
return(companyModel);
}
private string UpdateCompany(HttpContext context)
{
sys_CompanyModel companyModel = new sys_CompanyModel();
companyModel.CompanyId = int.Parse(context.Request.Form["cid"].ToString());
companyModel.CompanyName = context.Request.Form["cname"].ToString();
companyModel.CompanyAddress = context.Request.Form["caddress"].ToString();
companyModel.CompanyPerson = context.Request.Form["cperson"].ToString();
companyModel.CompanyTelPhone = context.Request.Form["ctelphone"].ToString();
companyModel.CompanyOthInfo = context.Request.Form["cothinfo"].ToString();
companyModel.CompanyState = int.Parse(context.Request.Form["cstate"].ToString());
string result = companyBLL.UpdateCompany(companyModel);
return(result);
}
private string AddCompany(HttpContext context)
{
try
{
sys_CompanyModel companyModel = new sys_CompanyModel();
companyModel.CompanyName = context.Request.Form["cname"].ToString();
companyModel.CompanyAddress = context.Request.Form["caddress"].ToString();
companyModel.CompanyPerson = context.Request.Form["cperson"].ToString();
companyModel.CompanyTelPhone = context.Request.Form["ctelphone"].ToString();
companyModel.CompanyOthInfo = context.Request.Form["cothinfo"].ToString();
companyModel.CompanyState = int.Parse(context.Request.Form["cstate"].ToString());
string result = companyBLL.AddCompany(companyModel);
return(result);
}
catch (Exception)
{
return("{\"Success\":\"False\",\"Msg\":\"企业信息中类型转换出错\"}");
throw;
}
}
public string AddCompany(sys_CompanyModel companyModel)
{
JsonMessage json = new JsonMessage();
int number = companyDAL.AddCompany(companyModel);
if (number > 0)
{
json.Success = true;
json.Msg = "企业信息添加成功";
}
else if (number == 0)
{
json.Success = false;
json.Msg = "企业信息添加失败";
}
else
{
json.Success = false;
json.Msg = "企业信息添加出错";
}
return(JsonHelper.ToJson(json));
}
/// <summary>
/// 根据企业实体信息，修改企业信息，得到对数据库操作结果 如果大于0操作成功，等于0操作失败，小于0操作出错
/// </summary>
/// <param name="companyModel">企业实体信息</param>
/// <returns></returns>
public int UpdateCompany(sys_CompanyModel companyModel)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update sys_Company set CompanyName =@CompanyName,");
strSql.Append(" CompanyAddress=@CompanyAddress,CompanyPerson=@CompanyPerson,");
strSql.Append(" CompanyTelPhone=@CompanyTelPhone,CompanyOthInfo=@CompanyOthInfo,");
strSql.Append(" CompanyState=@CompanyState where CompanyId=@CompanyId ");
SqlParameter[] paras =
{
new SqlParameter("@CompanyName", SqlDbType.VarChar, 50),
new SqlParameter("@CompanyAddress", SqlDbType.VarChar, 200),
new SqlParameter("@CompanyPerson", SqlDbType.VarChar, 50),
new SqlParameter("@CompanyTelPhone", SqlDbType.VarChar, 50),
new SqlParameter("@CompanyOthInfo", SqlDbType.VarChar, 500),
new SqlParameter("@CompanyState", SqlDbType.Int, 4),
new SqlParameter("@CompanyId", SqlDbType.Int, 4)
};
paras[0].Value = companyModel.CompanyName;
paras[1].Value = companyModel.CompanyAddress;
paras[2].Value = companyModel.CompanyPerson;
paras[3].Value = companyModel.CompanyTelPhone;
paras[4].Value = companyModel.CompanyOthInfo;
paras[5].Value = companyModel.CompanyState;
paras[6].Value = companyModel.CompanyId;
int number = DBHelper.ExecuteNonQuery(strSql.ToString(), paras);
return(number);
}
catch (Exception)
{
return(-1);
throw;
}
}
public string GetCompanyByCompanyId(int companyId)
{
sys_CompanyModel companyModel = companyDAL.GetCompanyByCompanyId(companyId);
return(JsonHelper.ToJson(companyModel));
}
