/// <summary> /// 新增一筆資料 /// </summary> /// <param name="CCC">傳入存放更新資料的SIS.Configuration.ClsCompanyConfig</param> /// <returns></returns> public bool InsertData(SIS.Configuration.ClsCompanyConfig CCC) { InitDB(); string insertCmd; insertCmd = "Insert Into " + TableName + " (CompanyID,CNAME,ENAME,UnifiedBusinessNo,CompanyType,Owner,Contact,Phone,MobilePhone,Fax,Address,WebSite,Notes"; insertCmd = insertCmd + ") Values("; insertCmd = insertCmd + "'" + CCC.CompanyID + "',"; insertCmd = insertCmd + "'" + CCC.CNAME + "',"; insertCmd = insertCmd + "'" + CCC.ENAME + "',"; insertCmd = insertCmd + "'" + CCC.UnifiedBusinessNo + "',"; insertCmd = insertCmd + "'" + CCC.CompanyType + "',"; insertCmd = insertCmd + "'" + CCC.Owner + "',"; insertCmd = insertCmd + "'" + CCC.Contact + "',"; insertCmd = insertCmd + "'" + CCC.Phone + "',"; insertCmd = insertCmd + "'" + CCC.MobilePhone + "',"; insertCmd = insertCmd + "'" + CCC.Fax + "',"; insertCmd = insertCmd + "'" + CCC.Address + "',"; insertCmd = insertCmd + "'" + CCC.WebSite + "',"; insertCmd = insertCmd + "'" + CCC.Notes + "'"; insertCmd = insertCmd + ")"; try { cmd = new SqlCommand(insertCmd, conn); cmd.ExecuteNonQuery(); conn.Close(); return(true); } catch (Exception ex) { errorMsg = ex.Message; conn.Close(); return(false); } }
/// <summary> /// 更新一筆資料 /// </summary> /// <param name="CCC">傳入存放更新資料的SIS.Configuration.ClsCompanyConfig</param> /// <returns></returns> public bool Update(SIS.Configuration.ClsCompanyConfig CCC) { InitDB(); string updateCmd; updateCmd = "UPDATE " + TableName + " SET "; updateCmd = updateCmd + " CompanyID='" + CCC.CompanyID + "',"; updateCmd = updateCmd + " CNAME='" + CCC.CNAME + "',"; updateCmd = updateCmd + " ENAME='" + CCC.ENAME + "',"; updateCmd = updateCmd + " UnifiedBusinessNo='" + CCC.UnifiedBusinessNo + "',"; updateCmd = updateCmd + " CompanyType='" + CCC.CompanyType + "',"; updateCmd = updateCmd + " Owner='" + CCC.Owner + "',"; updateCmd = updateCmd + " Contact='" + CCC.Contact + "',"; updateCmd = updateCmd + " Phone='" + CCC.Phone + "',"; updateCmd = updateCmd + " MobilePhone='" + CCC.MobilePhone + "',"; updateCmd = updateCmd + " Fax='" + CCC.Fax + "',"; updateCmd = updateCmd + " Address='" + CCC.Address + "',"; updateCmd = updateCmd + " WebSite='" + CCC.WebSite + "',"; updateCmd = updateCmd + " Notes='" + CCC.Notes + "'"; updateCmd = updateCmd + " WHERE CompanyID='" + CCC.CompanyID + "'"; try { cmd = new SqlCommand(updateCmd, conn); cmd.ExecuteNonQuery(); conn.Close(); return(true); } catch (Exception ex) { errorMsg = ex.Message; conn.Close(); return(false); } }