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)); }