/// <summary> /// 获取指定Id的公司信息 /// </summary> /// <param name="id">公司Id</param> /// <returns>CompanyModel</returns> public CompanyModel GetCompanyById(int id) { string strCommandText = "SELECT C_Id AS CId,C_Name AS CName,C_Address AS CAddress,C_Url AS CUrl,C_Tel AS CTel FROM c_info_table WHERE C_Status='N'"; strCommandText += " And C_Id='" + id.ToString() + "'"; CompanyModel objCompany = new CompanyModel(); try { DataTable dt = MySQLHelper.GetDataTable(MySQLHelper.Conn, CommandType.Text, strCommandText, null); if (dt.Rows.Count > 0) { objCompany.Id = id; objCompany.Name = dt.Rows[0]["CName"].ToString(); objCompany.Address = dt.Rows[0]["CAddress"].ToString(); objCompany.Url = dt.Rows[0]["CUrl"].ToString(); objCompany.Tel = dt.Rows[0]["CTel"].ToString(); } return(objCompany); } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// /// </summary> /// <param name="item"></param> /// <returns></returns> public bool UpdateCompany(CompanyModel item) { if (item == null) { throw new ArgumentNullException("item"); } //UPDATE c_info_table SET C_Status="Y" WHERE C_Id=2; string strCommandText = "UPDATE c_info_table SET"; strCommandText += " C_Name ='" + item.Name + "',"; strCommandText += " C_Address='" + item.Address + " ',"; strCommandText += " C_Url='" + item.Url + "',"; strCommandText += " C_Tel='" + item.Tel + "'"; strCommandText += " WHERE C_Id=" + item.Id; try { int iResult = MySQLHelper.ExecuteNonQuery(MySQLHelper.Conn, CommandType.Text, strCommandText, null); return(true); } catch (Exception ex) { throw new Exception(ex.Message); } }