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